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 |
|
frant101
Starting Member
12 Posts |
 Posted - 2009-12-08 : 06:04:55
|
| Hi All,I am getting the following error :Executed as user: CROMDOMAIN\Administrator. OLE DB provider 'MSDASQL' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.This happens when the below code as a step in a scheduled jobINSERT INTO stock_update SELECT code, desc1, desc2, qty, cost, loc FROM OPENQUERY(PGSQL1,'SELECT code, desc1, desc2, qty, cost, loc FROM blebyd.mansys')GOAs you can see it is using a linked server and if i take this code and run it in query analyzer then the code will sometimes work and other times it will fail with the above error.Any help on this would be really appricated, im using sql server 2000 sp4ThanksFrant101 |
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2009-12-09 : 02:15:00
|
| Hi You may try like this.INSERT INTO stock_update(code, desc1, desc2, qty, cost, loc) SELECT code, desc1, desc2, qty, cost, loc FROM PGSQL1.blebyd.mansysI am also using linked server in sql server 2000 for the last 1 and half years in this way working smooth.Regards,Sathieshkumar. R |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
|
|
|
|
|
|
|
Linked Server 7399 error