Discussion:
Server: Msg 7399, Level 16, State 1, Line 3
(too old to reply)
tapmrp1
2006-01-20 18:57:02 UTC
Permalink
I am using SQL 2000 with SP3a and MDAC 2.8 RTM on two sql servers with
Windows 2000 SP4. I linked a third sql server from both using same parametres
for the link server settings and runt the a qurey. But it runs ok on one sql
server and getting following error on another sql server all the time. I
need help to findout what could be the differnce?

Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetNextRows returned
0x80004005: ].

Thanks
John Bell
2006-01-21 21:30:02 UTC
Permalink
Hi

It seems that there must be some difference between the server that works
and the one that doesn't! May be this is applicable to this one?

http://support.microsoft.com/default.aspx?scid=kb;en-us;890759


John
Post by tapmrp1
I am using SQL 2000 with SP3a and MDAC 2.8 RTM on two sql servers with
Windows 2000 SP4. I linked a third sql server from both using same parametres
for the link server settings and runt the a qurey. But it runs ok on one sql
server and getting following error on another sql server all the time. I
need help to findout what could be the differnce?
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetNextRows returned
0x80004005: ].
Thanks
tapmrp1
2006-01-23 13:10:04 UTC
Permalink
I did look at that article but I am not gettign similer error. I noticed not
sone time it does wok not the SQL server where before it use to fail all the
time. I am not sure but it has to do with load on the server at that time.
Any other idea on how I can troubleshoot?

Thanks
Post by John Bell
Hi
It seems that there must be some difference between the server that works
and the one that doesn't! May be this is applicable to this one?
http://support.microsoft.com/default.aspx?scid=kb;en-us;890759
John
Post by tapmrp1
I am using SQL 2000 with SP3a and MDAC 2.8 RTM on two sql servers with
Windows 2000 SP4. I linked a third sql server from both using same parametres
for the link server settings and runt the a qurey. But it runs ok on one sql
server and getting following error on another sql server all the time. I
need help to findout what could be the differnce?
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetNextRows returned
0x80004005: ].
Thanks
Gabriele
2006-01-23 17:47:02 UTC
Permalink
Hi,
to solve the problem go the registry
(HKLM\Software\Microsoft\Mssqlserver\providers\SQLOLEDB ) and make sure all
except "AllowInProcess" have a value of 0.

Bye

Gabriele
MCP
Post by tapmrp1
I did look at that article but I am not gettign similer error. I noticed not
sone time it does wok not the SQL server where before it use to fail all the
time. I am not sure but it has to do with load on the server at that time.
Any other idea on how I can troubleshoot?
Thanks
Post by John Bell
Hi
It seems that there must be some difference between the server that works
and the one that doesn't! May be this is applicable to this one?
http://support.microsoft.com/default.aspx?scid=kb;en-us;890759
John
Post by tapmrp1
I am using SQL 2000 with SP3a and MDAC 2.8 RTM on two sql servers with
Windows 2000 SP4. I linked a third sql server from both using same parametres
for the link server settings and runt the a qurey. But it runs ok on one sql
server and getting following error on another sql server all the time. I
need help to findout what could be the differnce?
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetNextRows returned
0x80004005: ].
Thanks
Loading...