(Sorry for the cross-post, just thought additional eyes might be able to see this and offer some advice.)

I'm having a couple of problems related to this topic and was wondering if someone could assist.

If I try to set up a linked server via ODBC to data that is on another server, I get an error stating that the server is unable to open the DBC file. However, if I try to simply execute a DSN-less query against that remote data from the same source server, I can select data without a problem.

So, I thought I would try the OLEDB provider. Well, that one produces an error message stating that a registry entry couldn't be found for the provider, thinking it's not registered. However, the class exists in the registry and (like the ODBC situation) I am able to execute an ADO query using the provider without a problem.

Any ideas??

Laterness,
Jon