Linking SQL7 to Oracle 2

[rchalker]

How can I link SQl7 to Oracle using T-SQL? I keep getting a 7399 error message.

 

[DougP]

Uh do you have any T-SQL to show us... DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[tlbroadbent]

You can add a linked server in SQL 7 using the sp_addlinkedserver stored procedure.

EXEC sp_addlinkedserver
@server = 'Servername',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'MyServer'

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[zhongd]

Problem import data from Oracle using scheduled DTS package.
I used OLEDB Oracle provide to run a scheduled DTS job, got an error saying the Oracle client is needed.
I then used the ODBC Oracle driver, I got the job running forever and never ends.
Using either of these I was able to run the DTS package right away but not as a scheduled job.
Please help and thanks!

 

[tlbroadbent]

zhongd,

Please post your question in a new thread. New questions should always be posted in a new thread unless very closely related to the subject of the existing thread. Your question is only loosely related to the thread. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.