Can't use DB name with dashes using pymssql ???

[Samuel Morhaim]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20080813/4dacde81/attachment.html>