File 'C:\\home\\app\\pylons\\globetrack\\globetrack\\controllers\\jdb.py', line 7 in index
  c.clients = self.session.query(Client).select()
File 'build\\bdist.win32\\egg\\sqlalchemy\\orm\\query.py', line 247 in select
File 'build\\bdist.win32\\egg\\sqlalchemy\\orm\\query.py', line 252 in select_whereclause
File 'build\\bdist.win32\\egg\\sqlalchemy\\orm\\query.py', line 378 in _select_statement
File 'build\\bdist.win32\\egg\\sqlalchemy\\orm\\query.py', line 308 in execute
File 'build\\bdist.win32\\egg\\sqlalchemy\\orm\\session.py', line 133 in execute
File 'build\\bdist.win32\\egg\\sqlalchemy\\orm\\session.py', line 126 in connection
File 'build\\bdist.win32\\egg\\sqlalchemy\\engine\\base.py', line 499 in contextual_connect
File 'build\\bdist.win32\\egg\\sqlalchemy\\engine\\base.py', line 199 in __init__
File 'build\\bdist.win32\\egg\\sqlalchemy\\engine\\base.py', line 517 in raw_connection
File 'build\\bdist.win32\\egg\\sqlalchemy\\engine\\default.py', line 19 in get_connection
File 'build\\bdist.win32\\egg\\sqlalchemy\\pool.py', line 115 in connect
File 'build\\bdist.win32\\egg\\sqlalchemy\\pool.py', line 194 in __init__
File 'build\\bdist.win32\\egg\\sqlalchemy\\pool.py', line 128 in get
File 'build\\bdist.win32\\egg\\sqlalchemy\\pool.py', line 366 in do_get
File 'build\\bdist.win32\\egg\\sqlalchemy\\pool.py', line 111 in create_connection
File 'build\\bdist.win32\\egg\\sqlalchemy\\pool.py', line 149 in __init__
File 'build\\bdist.win32\\egg\\sqlalchemy\\pool.py', line 174 in __connect
File 'build\\bdist.win32\\egg\\sqlalchemy\\engine\\strategies.py', line 57 in connect
DBAPIError: (Connection failed) (InterfaceError) 



See this:

Module sqlalchemy.engine.strategies:57 in connect     

cargs	['Provider=SQLOLEDB;Data Source=test01;User Id=sa;Password=demo;Initial Catalog=Demo273']	
cparams	{}
	
dbapi	<module 'adodbapi' from 'c:\opt\python24\lib\site-packages\adodbapi\__init__.pyc'>	
e	<adodbapi.adodbapi.InterfaceError instance at 0x0164D5A8>	

sqlalchemy.exceptions.DBAPIError: (Connection failed) (InterfaceError) 




and compare with this:


>>> dsn = 'Provider=SQLOLEDB;Data Source=test01;User Id=sa;Password=demo;Initial Catalog=Demo273'
>>> import adodbapi
>>> adodbapi.connect(dsn)
<adodbapi.adodbapi.Connection instance at 0x00D94B98>