I'd refer to:
http://www.sqlstrings.com/SQL-Server-connection-strings.htm
Common issues include unresolved host names and named SQL server instances. But without more detail, I'm not sure what your issue is.
Runar
On 1/24/06, Don Smith <[EMAIL PROTECTED]> 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
main()
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?
Thanks,
Don
--
Runar Petursson
Betur
[EMAIL PROTECTED] -- http://betur.net
301 West 22nd Street Suite 68
New York, NY 10011
+1 (917) 570-1305
