I'm using the latest version of pymssql to connect (VPN) a Ubuntu 8.04 Server to a Windows 2000 Server machine, mounting SQLServer 2000. from the server I can ping the Windows machine. the connection worked correctly for some days, but today I get this error message:
DB-Lib error message 20009, severity 9: Unable to connect: Adaptive Server is unavailable or does not exist Net-Lib error during Operation now in progress Error 115 - Operation now in progress
and "tsql -H theip -p 1433 -U theuser" says:
Msg 20009, Level 9, State -1, Server OpenClient, Line -1
Unable to connect: Adaptive Server is unavailable or does not exist
There was a problem connecting to the server
what's the problem? what can I check?
thank you very much for your support. :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
that suggests it's not a problem within pymssql, so I'm unable to assist you. There may be many sources of problem, however it seems to be at network level. You have to check your addresses, firewalls, switches, VLANs, routers, cables, IPSes/IDSes, VPN server and client configuration and maybe many more.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi all,
I'm using the latest version of pymssql to connect (VPN) a Ubuntu 8.04 Server to a Windows 2000 Server machine, mounting SQLServer 2000. from the server I can ping the Windows machine. the connection worked correctly for some days, but today I get this error message:
DB-Lib error message 20009, severity 9: Unable to connect: Adaptive Server is unavailable or does not exist Net-Lib error during Operation now in progress Error 115 - Operation now in progress
and "tsql -H theip -p 1433 -U theuser" says:
Msg 20009, Level 9, State -1, Server OpenClient, Line -1
Unable to connect: Adaptive Server is unavailable or does not exist
There was a problem connecting to the server
what's the problem? what can I check?
thank you very much for your support. :)
any help about this, please?
thanks.
"tsql -H theip -p 1433 -U theuser"
that suggests it's not a problem within pymssql, so I'm unable to assist you. There may be many sources of problem, however it seems to be at network level. You have to check your addresses, firewalls, switches, VLANs, routers, cables, IPSes/IDSes, VPN server and client configuration and maybe many more.