I use it with SQL Server 2000.  Are you able to connect to the server using just the ADODBAPI library?  Best to build your own connection string for testing and back into the URI from there,
I'd refer to:


Common issues include unresolved host names and named SQL server instances.  But without more detail, I'm not sure what your issue is.


On 1/24/06, Don Smith <donwsmith@gmail.com> wrote:
Has anyone been able to connect to MSSQL w/ SQLObject? I get this error:

2006/01/24 12:30:03  INFO Traceback (most recent call last):
  File "c:\python24\lib\site-packages\CherryPy-2.1.1-py2.4.egg\cherrypy\_cphttptools.py ", line 271, in run
  File "c:\python24\lib\site-packages\CherryPy-2.1.1-py2.4.egg\cherrypy\_cphttptools.py", line 502, in main
    body = page_handler(*args, **cherrypy.request.paramMap )
  File "c:\python24\lib\site-packages\TurboGears-0.8.8-py2.4.egg\turbogears\controllers.py", line 124, in newfunc
    output = func(self, *args, **kw)
  File "C:\turbogears\tt_reports\tt_reports\controllers.py", line 12, in index
    results = list(HPD_HelpDesk.select(HPD_HelpDesk.q.priority==1))
  File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1457-py2.4.egg\sqlobject\sresults.py", line 149, in __iter__
    return iter(list( self.lazyIter()))
  File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1457-py2.4.egg\sqlobject\sresults.py", line 157, in lazyIter
    return conn.iterSelect(self)
  File "c:\python24\lib\site-packages\SQLObject- 0.7.1dev_r1457-py2.4.egg\sqlobject\dbconnection.py", line 360, in iterSelect
    return select.IterationClass(self, self.getConnection(),
  File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1457-py2.4.egg\sqlobject\dbconnection.py ", line 226, in getConnection
    conn = self.makeConnection()
  File "c:\python24\lib\site-packages\SQLObject-0.7.1dev_r1457-py2.4.egg\sqlobject\mssql\mssqlconnection.py", line 78, in makeConnection
    con = self.dbconnection( *self.make_conn_str(self) )
  File "c:\python24\lib\site-packages\adodbapi\adodbapi.py", line 224, in connect
    raise DatabaseError(e)
DatabaseError: (-2147352567, 'Exception occurred.', (0, 'Microsoft OLE DB Provider for SQL Server', '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.', None, 0, -2147467259), None)

Yes, this MSSQL instance is up and running and I can connect to it by other means than Python. I've tried two different MSSQL servers, and I get the same error for each. Any ideas?



Runar Petursson
runar@betur.net -- http://betur.net
301 West 22nd Street Suite 68
New York, NY 10011
+1 (917) 570-1305