And.. confirmed.. it has to be a bug in Python _mssql.
#sample.py import _mssql dbhost = 'gmed-4-int' dbuser = 'myuser' dbpasswd = 'mypassword' dbbase = 'Gcare4UI-B6_3_dev' con = _mssql.connect(dbhost, dbuser, dbpasswd) con.select_db(dbbase) ... Could not locate entry in sysdatabases for database 'Gcare4UI' ======= I have confirmed the db Gcare4UI-B6_3_dev does exist. I also tried connecting to one of the other DB in the same server that do not contain a DASH in the name and the connection was successful. How can I fix this? Do I report this as a bug? Can somebody point me in the right direction? Thank you. On Wed, Aug 13, 2008 at 6:30 PM, Samuel Morhaim <[EMAIL PROTECTED]>wrote: > I believe there is a bug in Python.. _mssql ... I am not too familiar > with Python yet, but after adding several breakpoints and watching the > variable, the last step of pymssql.py is > > # open the connection > con = _mssql.connect(dbhost, dbuser, dbpasswd) > > con.select_db(dbbase) > > > At this point the contents of dbbase is "Gcare4UI-B6_3_dev" (no quotes)... > however, the immediate error is that > "Gcare4UI" does not exist. > > Again removing the DASH from Gcare4UI-B6_3_dev and turning it into > Gcare4UIB6_3_dev results in error that can't find DB Gcare4UIB6_3_dev (of > course because the DB without the - doesnt exist... ) > > please help... thanks. > > > > On Wed, Aug 13, 2008 at 4:54 PM, Samuel Morhaim <[EMAIL PROTECTED]>wrote: > >> I tried: >> >> import sys >> import pymssql >> >> db = 'Gcare4UI-B6_3_dev' >> >> conn = pymssql.connect (host = "localhost", >> user = "myname", >> password = "mypassword", >> database = db) >> >> >> >> And this returns an error saying >> Could not locate entry in sysdatabases for database 'Gcare4UI'. No entry >> found with that name. >> >> It is not reading the db name after the Dash... if i remove the dash from >> the db to see what happens, it shows this obvious error, because it doesnt >> exist... i was just making sure the problem was with the dash >> >> Could not locate entry in sysdatabases for database 'Gcare4UIB6_3_dev'. No >> entry found with that name. >> >> Anyone had this problem? >> >> Thanks. >> >> >
-- http://mail.python.org/mailman/listinfo/python-list
