Connecting to MSSQL Server 7 from Linux
 

hi all

i want to access MS SQL Server 7.0 database from my Linux Machine using JSP.

i am right now having Mandrake linux,probably 9.1..
iam ready to install some other Linux if needed

i do not know which Driver can help me to connect to windows from Linux,

can anyone suggest for the Freely available Driver that can be used to connect to an Windows Data Source from Linux Machine and any another Resource which help me in in this Task

thanks

http://www.unixodbc.org/



Cheers,
Tink

the question:
if using EasySoft's client/server odbc-odbc bridge drivers (which cost $100 & $400),
how can they be accessed via Zope?

what I've found so far (unixODBC is far from answering the original question)
iodbc and unixodbc are both odbc "DriverManagers", not "Drivers".

Trying to access SQL Server and Interbase databases running on Windows
from Linux seems to still be an expensive proposition.

from http://www.unixodbc.org/,
you'll find the list of drivers here: http://www.unixodbc.org/drivers.html

and most of them reference a 30-day trial of an EasySoft driver.
That driver has a client AND server component.
Client = $100,
Server = $400

The server runs on one Windows machine and makes ALL windows odbc connections on that machine accessible via the client EasySoft OOB client/driver running on Linux.

I'm still trying to get a proof-of-concept using the 30-day trial.
A demo connection is setup on install ... which isn't accessible/visible in Zope running on Linux.
Only MySQL and GadFly connections are visible.

what a joyous migration ....

freetds.org

Works for me... and supports 4.2 and 7 for MS SQL servers.

Between unixodbc.org and freetds.org there is more than enough documentation to get you going.

GL