Linked Server Query Fails
- From: "Haident" <Haident@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 25 Jul 2005 14:48:02 -0700
I am working with a linked server (using MS OLE DB Provider for ODBC Drivers)
performing select queries from the ODBC DB and inserting the results into
tables in SQL Server.
Suddenly this is stopped working (everything was fine, but then....). Now I
can sometimes get a result from a very small table in the ODBC DB, but
queries are always failing against the larger tables in the linked server and
in many cases the queries of the small tables generate the same error
message, which is as follows:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [QODBC] Error]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
0x80004005: ].
I have tried to troubleshoot this by setting up the SQL Server DB and the
linked ODBC DB in two completely separate environments, but I am getting the
same result...the error message above. Since these queries were working
flawlessly before, and the problem does not appear to be specific to the
environment (machine, network, OS, etc.), I am wondering if there has been a
security update that may be playing havoc???
environment 1 - Windows server 2003, SQL Server 2000 SP4
environment 2 - Win 2k server, SQL Server 2000 SP 3a
--
Haiden Turner
Winged Disc Technologies, LLC
Dallas, Texas
.
- Follow-Ups:
- Re: Linked Server Query Fails
- From: Erland Sommarskog
- Re: Linked Server Query Fails
- Prev by Date: CSession: what is better way?...
- Next by Date: Para Access Algun Codigo Create Database Con oledb ??.
- Previous by thread: CSession: what is better way?...
- Next by thread: Re: Linked Server Query Fails
- Index(es):
Relevant Pages
|
