urgent: database vendor code 17

[Former Member]

all the crystal report running in the server are good, but when i run the report on client workstation, it doesn't work, connection error: database vendor code 17 pop up. is it a odbc connection error or network error or the report programming issue? Thanks

server:

windows 2012

SQL server 2008

workstation

windows 7 64bit

[former_member207611]

When you say 'Client Workstation', do you mean that you are running the report in Crystal designer ?

Also, does the client workstation has same connection, (ODBC or Native) created and pointing to same Database as the server ?

You need to verify that first, before trying to run the report locally.

More information might help if the above connectivity is already there on client workstation and if it still throwing error. like version of crystal designer etc..

[Former Member]

I mean client workstation is one pc in the network, the report is store in a server folder, client pc run the report through the network, the network folder is already access by everyone, should I need to setup a odbc? need to open dataport for client to access SQL? Thx

when I run the report in client, it take a long loading time then error code 17 pop up, why it need to load for a long time, it is connecting to somewhere not the server?

[former_member11696]

If you have any of the Verify Database options enabled then it will try to connect.

[Former Member]

Thanks, so if I run the report in the client pc, the sql database is on the server, should I open the network port 1433/1434?

[former_member11696]

I suggest contacting Microsoft and ask them how to resolve that error.

CR assumes the connection to the Server is working.

Don

[kaus19d]

Hi ,

You do understand that any service if runs on a port no. then you will be able to telnet from other systems. If the service does not run, then pinging, telnet-ing fails simply. OS matters are generally handed to the OS support team in every company. You can ask your OS team for help in this matter, even if it includes raising a Microsoft call like mentioned.

Thanks,

Kaushik

[former_member11696]

Database error code 17 is MS's, look on their site for what the error means, CR is simply passing it through to you.