Re: [Sqlalchemy-users] accessing ms sql server from linux

2006-03-10 Thread Brad Clements
On 10 Mar 2006 at 15:37, Rick Morrision wrote: > Try building pymssql from source as well, that might resolve the link > dependency. > > IIRC, that's what I did. > On my machine: > > # ldd /usr/lib/python2.4/site-packages/_mssql.so > libsybdb.so.5 => /usr/local/lib/libsybdb.so.5 (0x235f

Re: [Sqlalchemy-users] accessing ms sql server from linux

2006-03-10 Thread mike
Rick Morrision wrote: Try building pymssql from source as well, that might resolve the link dependency. i'd tried that; but taking a closer look, i've discovered what the problem was: i assumed that "python2.4 setup.py clean" in pymssql would remove _mssql.so from build/ so it would be reb

Re: [Sqlalchemy-users] accessing ms sql server from linux

2006-03-10 Thread Rick Morrision
Try building pymssql from source as well,  that might resolve the link dependency. IIRC, that's what I did. On my machine: # ldd /usr/lib/python2.4/site-packages/_mssql.so     libsybdb.so.5 => /usr/local/lib/libsybdb.so.5 (0x235fd000)     libpthread.so.0 => /lib/i686/libpthread.so.0 (0x2

Re: [Sqlalchemy-users] accessing ms sql server from linux

2006-03-10 Thread mike
thanks for the reply - Rick Morrision wrote: Perhaps Sarge includes the Sybase TDS libraries in the distro. it does, but the version in sarge doesn't seem to have some functions in it called by _mssql.so: import pymssql Traceback (most recent call last): File "", line 1, in ? File "/usr

Re: [Sqlalchemy-users] accessing ms sql server from linux

2006-03-10 Thread Rick Morrision
Perhaps Sarge includes the Sybase TDS libraries in the distro. There are date translation issues when using the Sybase libraries against MSSQL. Read up on things here IMO, the cleanest way to go is to build FreeTDS from source and use pymssql against that. Rick On 3/10/06, mike <[EMAIL PRO

[Sqlalchemy-users] accessing ms sql server from linux

2006-03-10 Thread mike
hello - has anyone successfully set up a linux box to allow python to access an ms sql server? if so, which packages/versions did you use, and which linux distribution? i've been able to get pymssql mostly working, but it required me to symlink libsybdb.so.5 as libsybdb.so.3. i'm wonderi