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 |
|
aberton
Starting Member
3 Posts |
 Posted - 2005-12-14 : 19:56:26
|
| Hi all,I have tried everything to resolve this problem but nothing has worked. I have a client PC running Query Analyzer, trying to execute an OPENQUERY statement to a 'personal' SQL Server database sitting on another machine running XP Pro. After creating a linked server, I have no problems running the SQL statement from query analyzer on the same machine as the SQL Server database, BUT whenn I try running the same sql statement from the remote client, I get the following sort of errors - OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: I have then tried recreating the linked server with every possible sp_linkedserver command without any luck. Is it because I am using a personal editional of SQL Server? Surely not, as I can execute from the client SQL statements that don't require a linked server. Please help.Thanks.Alex. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-12-14 : 20:16:31
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59149 |
 |
|
|
|
|
|
MSDASQL linked server problem