Fredrik Lundh wrote:
reading the documentation might help:
http://pymssql.sourceforge.net/troubleshooting.html#dbid
also see the SQL server reference documentation (the section "Rules for
Regular Identifiers" describes the valid syntax):
http://msdn.microsoft.com/en-us/library/ms17
Samuel Morhaim 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
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 databa
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
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 i
