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 |
|
smccreadie
Aged Yak Warrior
505 Posts |
 Posted - 2002-11-22 : 13:04:02
|
| I just had my laptop reimaged from Win2K to XP pro and can no longer setup a linked server to Informix. Because Informix is such a pain to work with, I carefully documented path statements, setnet settings, host and service file entries, etc. and made sure the new image was correct.I am able to add the linked server and login via QA. When I try to run an openquery statement, QA locks up. I do get a beep but no error message. Similiarly, I get a beep and no error message and then EM locks up if I try to view the tables or views for the linked server. When I did this with Win2K in the past, I would at least get an error message.I checked the SQL logs and Windows logs and didn't see anything.Has anyone out there had trouble with SQL2K client tools and linked servers on WinXP? Anyone have advice on this Informix issue? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-22 : 13:11:40
|
| Have you tried getting updated OLE DB/ODBC drivers from Informix? I know WinXP defaults to MDAC 2.7, and the drivers may be incompatible with it (unless you know you had it working with MDAC 2.7 on Win2K) There is a service pack or two for MDAC 2.7, you can get it here:http://www.microsoft.com/data/download.htmThe same applies to SQL2K service packs, applying the latest might also fix the issue. And if none of these work, you might need to go back to Win2K. |
 |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-11-22 : 13:36:15
|
| I'll look into it. Getting Informix set up correctly is always a full-day effort. |
|
|
|
|
|
|
Windows XP, linked server and Informix