talking to a MS SQL server database from informix/unix

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

Jack Avenevoli — Fri, 05 Feb 1999 15:28:44 -0600 — source: Informix-list mailing list archive (1991-1998)

Hello all, We are trying to automate some of our database operations, and one of the stumbling blocks we have come across is trying to talk to a different departments MS SQL server running on an NT box from our Informix 9.14uc4 database running on a SGI Origin 200 running IRIX 6.4. We have talked to several different vendors, informix, etc...all didnt seem to be of any help. Does anyone have any ideas on how to accomplish this through ODBC? -- ======================== Jack Avenevoli Web Database Specialist The Sporting News Online

↪ replying to Jack Avenevoli

Frank — Sat, 6 Feb 1999 15:50:40 -0500 — source: Informix-list mailing list archive (1991-1998)

Well, there is always VTI, but this is a complex solution. Depending on what you are trying to accomplish by talking to the other server, you may be able to simply use something like DataStage to move data around. Frank Oelschlager Director, Software Engineering ECOlogic Corporation Jack Avenevoli wrote in message <36BB628C.5A6A8D5C@sportingnews.com>... >Hello all, >We are trying to automate some of our database operations, >and one of the stumbling blocks we have come across is trying >to talk to a different departments MS SQL server running on >an NT box from our Informix 9.14uc4 database running on >a SGI Origin 200 running IRIX 6.4. We have talked to several >different vendors, informix, etc...all didnt seem to be of any help. >Does anyone have any ideas on how to accomplish this through >ODBC? > >-- >======================== >Jack Avenevoli >Web Database Specialist >The Sporting News Online > > >