DSXchange

can you please describe me how to do this?

ray.wurlod wrote:You have the alternative of accessing through SQL Server.

mctny wrote:can you please describe me how to do this?

ray.wurlod wrote:You have the alternative of accessing through SQL Server.

You can use SQL Server to create a linked server to an ODBC driver. You would then create views on the sql server that select data from the linked servers. At that point they appear to DataStage as normal views in a SQL Server database. You can then use the SQL Server ODBC driver on the Unix server.

thank you very much Shawn. does anybody know how to make a direct connection from SQL server to MS Access?

shawn_ramsey wrote:

mctny wrote:can you please describe me how to do this?

ray.wurlod wrote:You have the alternative of accessing through SQL Server.

You can use SQL Server to create a linked server to an ODBC driver. ....

same way