By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

Accessing Oracle Tables From Within SQL Server 2000

P: n/a
We are running SQL Server 2000 SP3. We have linked servers in use that
we use to access Oracle tables.

Recently the claim has been made that you can access Oracle tables from
within SQL Server without using a Linked Server. I searched Books
Online using keywords: linked, remote, and Oracle and did not find
anything.

A search of the newsgroup archives found only entries related to using
Linked Servers.

Is there any such method as claimed? I do not think there is, but I
need to find some support for my position or else learn something new.

Thank you
-- Mark D Powell --

Mar 24 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Is there any such method as claimed? I do not think there is, but I
Me neither.
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
need to find some support for my position or else learn something new.

Thank you
-- Mark D Powell --

Mar 24 '06 #2

P: n/a
Hi Mark

Check into OpenRowSet. I haven't done it with Oracle but I have with AS/400
DB2 files.

I could run a SQL Select Statement on the DB2 file and then insert the data
into a SQL Server table in a SQL Stored Proc.
--

-Dick Christoph
"Mark D Powell" <Ma*********@eds.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...
We are running SQL Server 2000 SP3. We have linked servers in use that
we use to access Oracle tables.

Recently the claim has been made that you can access Oracle tables from
within SQL Server without using a Linked Server. I searched Books
Online using keywords: linked, remote, and Oracle and did not find
anything.

A search of the newsgroup archives found only entries related to using
Linked Servers.

Is there any such method as claimed? I do not think there is, but I
need to find some support for my position or else learn something new.

Thank you
-- Mark D Powell --

Mar 24 '06 #3

P: n/a
Dick, I think you misread my post. We can select, insert, etc... to
Oracle tables from SQL Server databases. We use a Linked Database to
do it. The question is, is there any other MS provided method to
access Oracle from within a SQL Server database without using a Linked
Server? I do not think there is.

-- Mark D Powell --

Mar 26 '06 #4

P: n/a
Depends on how you read the question. if you mean connecting without an
OLEDB connection I think the answer is "no", but else Dicks' post is
correct.

OPENROWSET: you can use to connect to external data without a linked
server, the connection properties are embedded in the OPENROWSET
call(See BOL). Having said this, the command has more limitations than
linked servers.The only advantage is using it for ad hoc connections.
And even that you can simulate by adding linked servers at runtime. I
would use Linked servers with e.g. OPENQUERY over OPENROWSET anytime.

DM Unseen

Mar 27 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.