On Mon, Mar 31, 2008 at 4:57 PM, Rick Morrison <[EMAIL PROTECTED]> wrote:
>
> >
> >
> > You are correct:
> > Port=
> > fixes it.
> >
> >
> > If you guys could fix this in svn, and point me to some instructions
> > on how to install sqlalchemy in virtual / home directory that would be
> > great.
> >
> >
> >
> >
>
>
> OK, great, then r4387 rolls up everything covered in this thread and works
> on Windows: please give it a try on Linux.
Yes it does work.
The last 2 issue in this thread are driver name, and documentation update.
1. "SQL Server" might be a default in windows, but in linux all
howto/docs use a default name which is either TDS or FREETDS. This
means either sqlalchemy documentation will have to tells unixodbc
users to change their driver name like:
"
[SQL Server]
Description = FreeTDS Driver for Linux & MSSQL on Win32
Driver = /usr/lib/odbc/libtdsodbc.so
Setup = /usr/lib/odbc/libtdsS.so
"
or sqlalchemy connection string will have to provide some way to add a
driver name to connection string.
sqlalchemy.create_engine('mssql://user:[EMAIL PROTECTED]:1433/?driver=TDS')
I would prefer a second way because on linux a user might not be an
administrator and might not have privileges to change drivers name,
and all dsn that use that driver.
2. Could you add unixODBC instructions to sqlalchemy docs, namely:
a)Required: pyodbc, unixodbc, tdsodbc
b)sqlalchemy.create_engine('mssql://user:[EMAIL PROTECTED]:1433/?driver=TDS')
Thanks you.
Lucas
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
