PDA

View Full Version : Connecting to the database server through ODBC


dewangb
06-19-2003, 10:14 AM
We are facing the problem in connecting to ASA server from the client in peer to peer network. Whenever the client tries to connect to the server the message comes either Database engine is not running, or There is not enough data to process.

Server startup string (winnt)

C:\Maxfreight\bin\dbsrv6.exe -Q -c20M -nFrtrates
"C:\Maxfreight\data\Frtrates.db" -n Frtrates -x (serverport=2639)

Client side ODBC setting

ODBC
DSN=Frtrates
Server Name=Frtrates
Database Name=Frtrates
TCP/IP=(host=winnt:2639)

What could be the problem. I am able to ping to the server. On the server I am able to connect to the database from the odbc, but on another client i am not able to connect to the server.

Tried out all possible solution. Please help

Regards,
Dewang

stuka
06-19-2003, 12:23 PM
I've never run into this before myself - once the DSN is set up on the client, it's always been easy. However, one thing to test is that you can connect to port 2369 on the server (I usually try with telnet, just to see if I'm getting through).