Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Database connection error Post Reply Post New Topic
Author Message
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet Topic: Database connection error
    Posted: 25 Jul 2012 at 3:12am
Hello there

I have created a database connection using a dns file.

When i choose a table and stored proc.

I am asked to enter parameters, then i get the following message.

"database connection error : 'cannot obtain message from server".

I am using a logon within the odbc connection that has sufficient rights on stored proc.

what other areas could i look at.

Regards

Rob
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 25 Jul 2012 at 3:47am
What type of database are you connecting to?  Which driver are you using?  NOTE:  If you're set up using a 64-bit database driver and ODBC connection, it won't work - Crystal requires a 32-bit connection.
 
-Dell
IP IP Logged
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet Posted: 25 Jul 2012 at 4:18am
Yes i think so.
 
can you choose between a 64 and 32
 
or does it depend on the machine ie 64bit or 32 bit
IP IP Logged
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet Posted: 25 Jul 2012 at 4:21am
Is there another way i could execute the stored proc?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 25 Jul 2012 at 5:01am
No, you can't chose - Crystal will only work with 32-bit connections.  What type of database are you connecting to?  If it's SQL Server, have you tried using an OLEDb connection instead of ODBC?  Sometimes there are issues running SP's through ODBC connections.
You don't mention which version of Crystal you're using.  The version will determine which data types Crystal "understands".  So, I would also check the data types of the input parameters to the SP and see whether there are any "new" data types being used.  If there are, you may want to see whether they can be converted to older data types and see if that works in your report.
 
-Dell
IP IP Logged
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet Posted: 25 Jul 2012 at 5:09am
o sorry yeah
 
Crystal XI
 
My sp only has 2 parameters and they are both varchars.
 
I shall try with the ODBCd
IP IP Logged
floada
Newbie
Newbie
Avatar

Joined: 03 Sep 2012
Location: United States
Online Status: Offline
Posts: 3
Quote floada Replybullet Posted: 03 Sep 2012 at 10:33am
Is using Win7 64 bit, try running odbcad32.exe, from the search field of Win7 Start Icon.

The make your ODBC connections.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.020 seconds.