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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-16 : 07:58:39
|
| Chandrika writes "Hi,I am running SQL Server 2000 on Windows 2003 server. I am tring to crete a link to the Informix database. Following is the Code that I am using in creting the link server.-----------USE MASTERGOEXEC sp_addlinkedserver@server = 'CSSLink',@srvproduct = 'MERANT 3.60 32-BIT INFORMIX',@provider = 'MSDASQL',@datasrc = 'CSSDatabase'-----------My DSN is working properly. The above script tested and worked fine on few other machines.(OS-XP,200 Server)When I click on the Tables on the linked server it gives the following error.-----------Error 7399: OLE DB provider 'UNKNOWN' reported an error. Cannot open file 'csqli.iem']OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowset::GetRowset returned 0x80004005: ].-----------I am tring this for few days without any luck.Your help is very much appreciated.Thanks" |
|
|
|
|
|
SQL Server "Link Server" Error