You probably don't have a new enough version of MDAC installed on your Win2k machine...
Quote from Andrzej Kukula in another thread here (why didn't you read it - there aren't many threads!):
Please be sure to use ntwdblib.dll at its latest version, you can download it from the pymssql's CVS: http://pymssql.cvs.sourceforge.net/pymssql/pymssql/
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm using pymssql ta acces MS SQL server 2005, from WXP machines i find no problem, but I can't run my scripts from w2k machines in the same network.
With w2k I get this error message:
Traceback (most recent call last):
File "E:\BaaN\Notifica_email\notifica_por_email.2.py", line 6, in ?
con=pymssql.connect(host='gi-clsql', database='baandb',user='baan', password='baan' )
File "C:\Python24\Lib\site-packages\pymssql.py", line 310, in connect
con = _mssql.connect(dbhost, dbuser, dbpasswd)
error: DB-Lib error message 10040, severity 9:
Db-library network communications layer not loaded.
The installations in w2k run OK. Is pymssql only for WXP?
pymssql is not only for WXP. (I use it on Linux.)
You probably don't have a new enough version of MDAC installed on your Win2k machine...
Quote from Andrzej Kukula in another thread here (why didn't you read it - there aren't many threads!):
Please be sure to use ntwdblib.dll at its latest version, you can download it from the pymssql's CVS: http://pymssql.cvs.sourceforge.net/pymssql/pymssql/