Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cs_bhimavarapu
Starting Member
23 Posts |
 Posted - 2004-07-06 : 17:02:55
|
| Having trouble finding the ODBC driver for connecting to Informix from SQL Server2000. Microsoft site says SQL Server also includes an ODBC driver that supports Informix subscriptions to SQL Server, but I don't find one from the new install of SQL Server or from microsoft website. Appreciate your help...CSB |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-06 : 17:39:20
|
| You will need to install the Informix client on the database server. Hopefully, you can just install a driver and not the entire client.Tara |
 |
|
|
cs_bhimavarapu
Starting Member
23 Posts |
Posted - 2004-07-13 : 13:03:33
|
| Wanted to have some more inputs on this one...My requirement:I need to continuously update a SQL Server database from the source data that is on Informix.What are the possible alternatives to do the job?If somebody have done it before, please provide inputs of how it was done?This is what I've gathered sofar:Microsoft site says SQL Server also includes an ODBC driver that supports Informix subscriptions to SQL Server, but I did't find one from the new install of SQL Server or from microsoft website.Like, DB2 has DB2 Connect to connect to DB2 from SQL Server...I,ve seen Informix Connect on IBM website...It finally leads me to loading of Informix client tools on the destination SQL Server...Appreciate your help...CSB |
|
|
|
debug2k
Starting Member
18 Posts |
Posted - 2004-07-14 : 12:09:36
|
| Hi,We have a similar system running and we installed the Informinx Open Client utility which installs the related odbc drivers and u can then mention the user id and password for the same.Regards,Deepak U |
|
|
|
cs_bhimavarapu
Starting Member
23 Posts |
Posted - 2004-07-14 : 13:46:02
|
Thanks Deepak... |
|
|
|
|
|
|
Connecting to Informix