My server machine is running on Windows XP and running MSSQL.
I have another client machine which also installed on Windows 2000 and since i cannot install the whole MSSQL, I installed the Client Tools only.
After installing,through my query analyser in client machine i can query the tables in my server machine.
However, the problem arose when i tried to use python-MSSQL connector called pymssql.
This error resulted :
>>> import pymssql
>>> db = pymssql.connect(host=r'192.168.1.204:1279',user='loginpls',password='qwerty',database='FR6EnterpriseDB')
Traceback (most recent call last):
File "<pyshell#1>", line 1, in -toplevel-
db = pymssql.connect(host=r'192.168.1.204:1279',user='loginpls',password='qwerty',database='FR6EnterpriseDB')
File "E:\Python24\Lib\site-packages\pymssql.py", line 310, in connect
con = _mssql.connect(dbhost, dbuser, dbpasswd)
error: DB-Lib error message 10004, severity 9:
Unable to connect: SQL Server is unavailable or does not exist. Invalid connection.
Net-Lib error during ConnectionOpen (ParseConnectParams()).
Error 14 - Not enough storage is available to complete this operation.
Quite surprising, When i first tried a week ago, there was no problem.
I also know for a fact, the problem isnt with the server either as my collegue running on Linux can connect via this pymssql driver too.
I think probably some setting somewhere or sumtin like that has been turned off/on..
Anyone can help me guide in the right direction
Thanks in advance.