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 -- 4 1974
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 --
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 --
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David Gray |
last post by:
Hello all,
Having problems connecting to an Oracle 9i database from within
SQL/Server 2000 using the Security/Linked Servers feature.
Server1 (SQL/Server)
-----------
Windows Server 2003, Standard edition
MS SQL/Server 2000
Oracle 9i Client kit (OLEDB & ODBC) & Enterprise management tools
|
by: Karen |
last post by:
SQL Server 2000 Ent, PowerBuilder 6.5 Ent, Window 2000 Pro
Hi,
My only experience is with Oracle,so please bear with me...
We have some new clients that require our pricing data be imported
into their Sql Server databases. The price lists are in Excel files,
which we recieve from numerous vendors on a quarterly basis.
|
by: Nelson Xu |
last post by:
Hi All
Does anyone knows how to pass an array from .net application to oracle stored procedure
Thank you in advance
Nelson
|
by: Andrea M. Segovia |
last post by:
Hello,
I am a newbie to Oracle databases....
We have a visualization front-end tool connected to an Oracle back-end
database on a Tru64 UNIX server. We also have clients with MS access
databases who would like to share their data using this visualization
tool but do not want to import their data into the Oracle server
back-end.
|
by: Andrew Arace |
last post by:
I scoured the groups for some hands on code to perform the menial task
of exporting table data from an Access 2000 database to Oracle
database (in this case, it was oracle 8i but i'm assuming this will
work for 9i and even 10g )
No one had what I needed, so I wrote it myself.
I Rule.
This code isn't going for efficiency, and isn't trying...
| |
by: lovkeshanand |
last post by:
Dear All,
I am using the oracle transparent gateway connectivity with sql server
using tg4msql,as far as
settings are concerned those were set and Connectivity is working Fine,
and getting the response
from that server.
here is description what I done as:-There is a View on Sqlserver which
is Join of 6 tables and have
|
by: egoldthwait |
last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a
Citrix farm. The issue: we have never converted an Access Db to Oracle
but can probably use Oracle's Workbench to assist with this. Also - the
citrix folks do not want us to keep the FE in Access as the queries and
other activities consume a lot of power. The users will be in...
|
by: Paul |
last post by:
Anyone know where I can find some good resources to help us choose between
SQL and Oracle ( Progress Openedge as well ) . Any comments on what you
would choose ?? We are creating a new Warehouse Management System which wil
manage our very large inventory.
Anyway comments suggestions welcome
Thanks
Paul
|
by: dreadnought8 |
last post by:
I've worked with mdbs, and with SQL Server to a lesser extent, with
Access as a front end, on commercial-strength systems for quite a
while, starting with A97.
The last 8 months or so, I've been working on Access 2000/2002 with
pass through queries and linked tables to an Oracle 10g backend
(ODBC).
Access seems (still) to beat everything...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |