database connection error (1 Viewer)

[masterdineen]

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

 

[kevlray]

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.

 

[masterdineen]

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

 

[kevlray]

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

 

[masterdineen]

thanks for getting back mate

 

[masterdineen]

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.

 

[kevlray]

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).

 

[masterdineen]

Hello Kevlray

I cannot see the option to choose an RDO connection.

I have double checked and i do have the SP option ticked.

 

[kevlray]

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.

 

[masterdineen]

Go back and read to post from the beginning mate