database connection error

M

masterdineen

New member
Local time
Today, 02:04
Joined
Jul 25, 2012
Messages
9
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
 
You are choosing a table and a SP? I have seen odd issues in doing this (ODBC does not like for some reason). For testing purposes can you choose a table and see if that works, then choose the SP and see if that works. Also we had a odd issue because the table we choose was also a reserved name for the DB, we aliased the table and it works fine now.
 
I also found out that crystal does not like connecting accross 64bit machines. and only like 32 bit

This seems to be the case with me.

Thank you for your reply

Regards

Rob
 
That is true, Crystal still only uses 32 bit connections (unless you are using Crystal Enterprise).
 
Hi

I have a stored proc that populates a table and does not require any parameters.

How would i get the proc to execute through crystal with a OLE BD connection.?

and obviously display the table data in a crystal report.
 
I am not sure through an OLE DB connection, but I know that with an RDO connection it will show up (provided that under the options for the database you have SP's selected).
 
Hello Kevlray

I cannot see the option to choose an RDO connection.

I have double checked and i do have the SP option ticked.
 
Not sure what is going on. I did a quick check with a database using an OLE DB and an ODBC (RDO) connection and saw the SP's in both of them.
 
You must log in or register to reply here.

Similar threads

Snowflake68
Catch Error - Mapped Network drive
Replies
17
Views
202
The_Doc_Man
The_Doc_Man
M
ODBC -call failed
2
Replies
21
Views
455
mdfOffman
M
D
Updating ADP - Which ADODB connection to use
Replies
1
Views
143
sonic8
S
Pyro
MS Access to Azure SQL Connection String Variables
Replies
1
Views
239
sonic8
S
monheimx9
Pass-Through Query - Connecting to another Access Backend
Replies
9
Views
371
The_Doc_Man
The_Doc_Man

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom