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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-27 : 11:30:43
|
Michael writes "I want to import data from Oracle 7.3.4 to SQL Server 7
What is the best way? DTS or Linked servers
If I try linked servers
--Step 1
EXEC sp_addlinkedserver
@server = 'Botswana', --Linked server name
@srvproduct = 'Oracle', --Product name
@provider = 'MSDAORA.1', --You must also specify a provider name here apart from conn string
--@provstr = 'Provider=MSDAORA.1;User ID=terabot;Data Source=africa-af01;password=terabot;Persist Security Info=False',
@datasrc = 'Africa-Af01'
--Step 2
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'Botswana',
@useself = false,
@locallogin = 'labm-sql01',
@rmtuser = 'terabot',
@rmtpassword = 'terabot'
EXEC sp_addlinkedsrvlogin 'Botswana', true
--Step 3
EXEC sp_tables_ex 'Botswana'
And I constantly get an error:
Server: Msg 7302, Level 16, State 1, Procedure sp_tables_ex, Line 20
Could not create an instance of OLE DB provider 'MSDAORA.1'.
According to our oracle DBA's the database is set up correctly to handle linked servers
Any help would be appreciated
Michael" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-03-13 : 23:28:34
|
| Hey spyder - was there an answer here?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-13 : 23:40:29
|
Spyder,is making us know that is is back  -------------------------------------------------------------- |
|
|
|
|
|
|
|
|
Linked Servers