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 |
|
Mathias
Posting Yak Master
119 Posts |
 Posted - 2004-09-03 : 08:09:40
|
| Hi,I have a single instance of SQL2000 sp3 running on a NT4 sp6 workstation with the analysis tools installed. When I use the ODBC from Excel, I don't have any problem. When I create a link server on the SQL2000 (with allow inProcess checked), I always get an error 7399 or error 7302.However, if I link a SQL database, it works.I have checked the MSDTC service (allow service to interact with desktop is unchecked, system account checked). The concerned linked databases are on Oracle Rdb and Sysbase AnywhereThanks, Paul |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-03 : 18:41:34
|
| Can you give us the connection strings you are using?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2004-09-06 : 06:27:37
|
| I have found the problem : ODBC dsn were setup at the user and not system levelEven if I had the two connections fully working as user dsn, SQL server will only see them if they are entered as system dsn. I have changed it and it works!I know it is quite logical but I got stuck on the error messages that are not explicit at all. All the help that I found on the web with a similar error message talked about upgrading the MDAC. In fact, you get the same error messages if you setup an ODBC connection with fake parameters. |
|
|
|
|
|
|
Don't manage to use OLEDB ODBC for any DB type