Print Page | Close Window

Database connection error

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17103
Printed Date: 27 Apr 2024 at 8:50pm


Topic: Database connection error
Posted By: masterdineen
Subject: Database connection error
Date Posted: 25 Jul 2012 at 3:12am
Hello there

I have created a http://www.access-programmers.co.uk/forums/showthread.php?p=1176279# - - 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 http://www.access-programmers.co.uk/forums/showthread.php?p=1176279# - - 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


Replies:
Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: masterdineen
Date 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

Posted By: masterdineen
Date Posted: 25 Jul 2012 at 4:21am
Is there another way i could execute the stored proc?

Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: masterdineen
Date 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

Posted By: floada
Date 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.


Print Page | Close Window