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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with linked server

Status
Not open for further replies.
JaimeDiego

JaimeDiego

Programmer
Jun 26, 2003
1
ES
I´m using a linked server on SQL Server 7 to execute a query in a SQL Anyhwere 5.0 (Sybase) database. I use an OLE DB Provider for ODBC. The sp_addlinkedserver procedure seems to work right BUT when I execute the query (just a 'drop table XXX') I get the following error
"Could not create an instance of OLE DB provider 'MSDASQL.1'"

What's happening? Any solutions?
 
Status
Not open for further replies.

Similar threads

Komal0735
  • Locked
  • Question
how to perform partial cube processing without losing data - SSAS, SSIS
Replies
0
Views
502
Komal0735
Komal0735
tcstl1
  • Locked
  • Question
Migrating SSAS to new server
Replies
0
Views
473
tcstl1
tcstl1
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
433
juanvg1972
juanvg1972
RRinTetons
  • Locked
  • Question
Move cube to a new location on the same server
Replies
1
Views
534
blom0344
blom0344
vcebedo
  • Locked
  • Question
How to add Server Admin from different Location
Replies
1
Views
448
Alan0568
Alan0568

Part and Inventory Search

Sponsor

Back
Top