Anyone heard of 4D? Probably not, but I would love to work with
SQLAlchemy and this database.
How hard is it to write a new dialect?
Anyone had luck using generic odbc (ie not mysql moduled to pyodbc) to
connect to various "unsupported" databases?
I've tried a couple connection strings, the biggest problem is 4D
doesn't have a "database" name.
# connect to the actual database
from sqlalchemy import create_engine
#using DSN
engine = create_engine('mysql+pyodbc://4D_v11_Dev/DEFAULT_SCHEMA')
#using URL
engine = create_engine('mysql://user:[email protected]', module='pyodbc')
#another dialect with DSN => ERROR: AttributeError: 'str' object has
no attribute 'paramstyle'
engine = create_engine('mssql://4D_v11_Dev', module='pyodbc')
# yet another try
engine = create_engine('mysql+pyodbc://4D_v11_Dev')
# show me output
engine.echo = True
None of those work, I have some stack traces, but the gist is this:
# when used without a database name
sqlalchemy.exc.DBAPIError: (Error) ('08004', '[08004] Server rejected
the connection:\nFailed to parse statement.\r (1301)
(SQLExecDirectW)') 'SELECT DATABASE()' ()
# when I try to specify a name
sqlalchemy.exc.DBAPIError: (Error) ('00000', '[00000] [iODBC][Driver
Manager]dlopen({MySQL}, 6): image not found (0) (SQLDriverConnectW)')
None None
But connection directly via pyodbc does work
import pyodbc
cnxn = pyodbc.connect("DSN=4D_v11_Dev;UID=user;PWD=pass")
cursor = cnxn.cursor()
cursor.execute('select * from ODBCTest')
a=cursor.fetchall()
print 'pyodbc',a
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
