Hello World!
This is my first foray into python and SQL Alchemy, and I'm spinning my
wheels. I'm running the code below and am able to connect to my DB and
query data without error.
import pyodbc
cnxn = pyodbc.connect('DSN=py_test; Trusted_Connection=Yes')
However, when I try
import sqlalchemy
engine = sqlalchemy.create_engine('mssql+pyodbc://DSN=py_test;
Trusted_Connection=Yes')
result = engine.execute("SELECT * FROM dbo.test_table")
I receive the following error, I am running python 3.3 on 32 bit Windows 7
Enterprise
Traceback (most recent call last):
File "C:\Python33\lib\site-packages\sqlalchemy\pool.py", line 757, in
_do_get
return self._pool.get(wait, self._timeout)
File "C:\Python33\lib\site-packages\sqlalchemy\util\queue.py", line 166,
in get
raise Empty
sqlalchemy.util.queue.Empty
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Python33\lib\site-packages\sqlalchemy\engine\strategies.py",
line 80, in connect
return dialect.connect(*cargs, **cparams)
File "C:\Python33\lib\site-packages\sqlalchemy\engine\default.py", line
285, in connect
return self.dbapi.connect(*cargs, **cparams)
pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified (0)
(SQLDriverConnect)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"C:\Users\V114804\workspace\Remetrica_Simulated_ILC_WW_AP_20130520_ELT\Src\Test_DB_Connection.py",
line 11, in <module>
result = engine.execute("SELECT * FROM dbo.test_table")
File "C:\Python33\lib\site-packages\sqlalchemy\engine\base.py", line
1613, in execute
connection = self.contextual_connect(close_with_result=True)
File "C:\Python33\lib\site-packages\sqlalchemy\engine\base.py", line
1661, in contextual_connect
self.pool.connect(),
File "C:\Python33\lib\site-packages\sqlalchemy\pool.py", line 272, in
connect
return _ConnectionFairy(self).checkout()
File "C:\Python33\lib\site-packages\sqlalchemy\pool.py", line 425, in
__init__
rec = self._connection_record = pool._do_get()
File "C:\Python33\lib\site-packages\sqlalchemy\pool.py", line 777, in
_do_get
con = self._create_connection()
File "C:\Python33\lib\site-packages\sqlalchemy\pool.py", line 225, in
_create_connection
return _ConnectionRecord(self)
File "C:\Python33\lib\site-packages\sqlalchemy\pool.py", line 318, in
__init__
self.connection = self.__connect()
File "C:\Python33\lib\site-packages\sqlalchemy\pool.py", line 368, in
__connect
connection = self.__pool._creator()
File "C:\Python33\lib\site-packages\sqlalchemy\engine\strategies.py",
line 87, in connect
) from e
sqlalchemy.exc.DBAPIError: (Error) ('IM002', '[IM002] [Microsoft][ODBC
Driver Manager] Data source name not found and no default driver specified
(0) (SQLDriverConnect)') None None
I have also tried:
import sqlalchemy
import pyodbc
def connect():
pyodbc.connect('DRIVER={SQL
Server};Server=SDAWWRMSD05;Database=ReMetrica_Results_201207;Trusted_Connection=Yes')
print('Connect Method Created')
created_engine = sqlalchemy.create_engine('mssql://', creator=connect)
created_result = created_engine.execute("SELECT * FROM dbo.test_table")
The definition is called, then the program hangs.
If anyone could please give me some advice on how to get around this that
would be great.
Thank you for your help, please let me know if I can provide any additional
information.
~Victor
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
