Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sql & Access
- Thread starter Saama5
- Start date
To my knowledge, there's no SQL command for what you want to do. You need to use DTS (distributed transaction service). Check out the Books OnLine (Index tab, type in DTS) and faq183-962 by Terry Broadbent. His FAQs are excellent sources for information.
-SQLBill
-SQLBill
- Thread starter
- #3
I tried to use
Insert into Opendatasource('Microsoft.......)
select * from #tbl1
it is working well from inside sql query analyzer
but when I try to execute script with isql then it gives error
Msg 7302, Level 16, State 1
Could not create an instance of OLE DB provider 'Microsoft.Jet.Oledb.4.0'
Any help!!
Insert into Opendatasource('Microsoft.......)
select * from #tbl1
it is working well from inside sql query analyzer
but when I try to execute script with isql then it gives error
Msg 7302, Level 16, State 1
Could not create an instance of OLE DB provider 'Microsoft.Jet.Oledb.4.0'
Any help!!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
