I was able to connect to mssql vi ceODBC driver on linux using unixODBC.

How hard would it be to support ceODBC in sqlalchemy?


--

Instructions to setup dsn on unix:
http://lucasmanual.com/mywiki/TurboGears#head-bab4c0bbfb83fb7c376a8a0cb68841c4e76ad130

apt-get install python-dev
apt-get install unixodbc
apt-get install unixodbc-dev

To get ceODBC:
svn co https://ceodbc.svn.sourceforge.net/svnroot/ceodbc/trunk

cd trunk
python setup.py build
python setup.py install

In python:
import ceODBC
 c = ceODBC.Connection("DSN=MYDSN;UID=USERNAME;PWD=PASSWORD")
cursor=c.cursor()
 cursor.execute('SELECT * FROM INFORMATION_SCHEMA.TABLES')
<ceODBC.Cursor on <ceODBC.Connection to DSN=MYDSN;UID=USERNAME;PWD=PASSWORD>>
data=cursor.fetchall()

and you are connected.
Lucas

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to