Hi
I cannot connect to SQL Server 2005 (Express) from my linux box using
the suggested SA method. I can connect to SQL Server using sqsh which
indicates that freetds and unixodbc are correctly set up.
I can also connect using pyodbc. Although, only with the DSN method or
with DRIVER={}. For details, see:
http://sourceforge.net/forum/message.php?msg_id=4348161
This is probably more of a pyodbc problem (or a problem created by me
(wouldn't be the first time)) so this post is more of an FYI and a
WTF? than a bug report ;-)
The following thread contains reference to SA's pyodbc connection
mechanism:
http://groups.google.co.uk/group/sqlalchemy/browse_thread/thread/b5909dceb2178a1d
It seems that setting the DRIVER keyword to {SQL Server} is the method
employed by SA:
def make_connect_string(self, keys):
connectors = ["Driver={SQL Server}"]
...
So, I guess my questions are how I could get SA to use the DSN I have
defined in /etc/freetds/freetds.conf and /etc/odbc*.conf. Or, how I
could force SA to use DRIVER={} instead of Driver={SQL Server}. (Note
that, for me, the DRIVER keyword is case-sensitive when using pyodbc
directly.)
Thanks for a kick-ass database doo-hicky (I am still getting to know
all the TLA's)
Cheers,
Ryan
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
