How can I get data in SQL Server from Unix

[hubbell]

The reason I have this question is because we want to update the application running on Unix to have it to be able to read the information in a SQL Server on NT Server. Since ODBC is actually to support Windows application to access other kinds of database, I don't know whether it provides the features in the opposite way. Or is there any product that will give me this function?

Thanks in advance for any suggestion

Colin
Programmer

 

[foxdev]

An ODBC driver is tied to/specific to a data source, not the client. Since your data source is SQL Server, you'd use the SQL Server ODBC driver. However, I assume that you cannot use ODBC on Unix, so the direct approach seems to be out.

The other approach is to export from SQL Server then import the data using your Unix data program. SQL Server has several options for exporting data, and these exports can be scheduled. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[nshen]

There are ODBC Driver vendors out there that support ODBC on Unix. Some require a server piece to be installed on your RDBMS site to use their private protocol, some licensed with RDBMS vendors to provide a ODBC Driver Manger and a full function ODBC driver that connect directly to the RDBMS, without a client.
You can check with Microsoft to see which ODBC Drivers would they recommand.

Regards, Nancy