I have created a DTS package that pulls data in from Oracle into SQL
Server. When I run it directly on the server (from Enterprise
Manager), it works fine. When I run it from Enterprise Manager on a
client machine that does not have the Oracle client software, it does
not run, giving me the error: "The Oracle client and networking
components were not found...". I was hoping I wouldn't need to have
the client software installed on a machine other than the server where
Sql Server is running. The problem here is that there are a number of
machines from where I would like to execute this DTS package that I do
not want to install/configure the Oracle client software. I don't
quite understand why the configuration of the client is important
here. In my mind, when I am using enterprise manager from a client
machine, I am using it sort of like a terminal services client to
connect to the server. I guess there is a lot more happening in the
background.
Thanks for any feedback,
Marcus 2 5059
Do you have the proper ODBC driver that you are using in the DTS on the
client machine? same as the one on your server.
"Marcus" <ho**********@h otmail.com> wrote in message
news:17******** *************** ***@posting.goo gle.com... I have created a DTS package that pulls data in from Oracle into SQL Server. When I run it directly on the server (from Enterprise Manager), it works fine. When I run it from Enterprise Manager on a client machine that does not have the Oracle client software, it does not run, giving me the error: "The Oracle client and networking components were not found...". I was hoping I wouldn't need to have the client software installed on a machine other than the server where Sql Server is running. The problem here is that there are a number of machines from where I would like to execute this DTS package that I do not want to install/configure the Oracle client software. I don't quite understand why the configuration of the client is important here. In my mind, when I am using enterprise manager from a client machine, I am using it sort of like a terminal services client to connect to the server. I guess there is a lot more happening in the background.
Thanks for any feedback, Marcus
Marcus wrote: I have created a DTS package that pulls data in from Oracle into SQL Server. When I run it directly on the server (from Enterprise Manager), it works fine. When I run it from Enterprise Manager on a client machine that does not have the Oracle client software, it does not run, giving me the error: "The Oracle client and networking components were not found...". I was hoping I wouldn't need to have the client software installed on a machine other than the server where Sql Server is running. The problem here is that there are a number of machines from where I would like to execute this DTS package that I do not want to install/configure the Oracle client software. I don't quite understand why the configuration of the client is important here. In my mind, when I am using enterprise manager from a client machine, I am using it sort of like a terminal services client to connect to the server. I guess there is a lot more happening in the background.
Thanks for any feedback, Marcus
The Oracle client is required. So is paying attention to the license
agreement.
--
Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp da******@x.wash ington.edu
(replace 'x' with a 'u' to reply) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: duffymo |
last post by:
I'm having a terrible time installing the Oracle 8.1.7 client on my
Windows 2000 version 5.0 SP 4 machine.
I did a search of this forum and found this:
http://groups.google.com/groups?q=8.1.7+client+install+failure&hl=en&lr=&ie=UTF-8&selm=fEhI6.27829%24aW5.355302%40dfw-read.news.verio.net&rnum=1
The problem is that this advice assumes that the s'ware exists on a
CD. I downloaded mine from technet.oracle.com. There IS no CD.
|
by: Gilles Cadorel |
last post by:
Sur un PC, nous avons installé plusieurs version d'Oracle Client.
Plusieurs logiciels tiers utilisant Oracle ne demandent pas lors de
leur installation, quelle version d'Oracle utiliser.
Ces logiciels fonctionnent correctement mais nous aimerions savoir à
coup sûr, quel Client Oracle est réellement utilisé.
Merci d'avance
|
by: John |
last post by:
Hi.
We had a PC that had Oracle Client 8.0.5 and 8.1.7 installed in Default_Home
(c:\orant) and Default_Home1 (c:\oracle).
A third party package, installed certain components of Oracle Client 9.0.2
in another Oracle Home which it called ora92 (c:\oracle\ora92).
Since we no longer need Clients 8.0.5 and 8.1.7, I decided to uninstall all
Oracle clients and install Oracle client 9.0.2. I used Oracle installer to
|
by: Tig |
last post by:
Hi all.
I have a need to connect to an Oracle 7.3.3.5 database. I have a user
who successfully connects to it with her Oracle 7.3 client. I have an
Oracle 9.2 client installed on my machine.
I had her send me her tnsnames.ora from her PC. The entry I wanted was
as follows (some letters replaced with xxx for security reasons):
|
by: Mike D |
last post by:
I want to connect to an oracle database from my client pc, OS is win2k or XP.
Can I connect to an oracle database without having the full oracle client
installed? If so what would be the minimum install on the client to get this
connection? Oracle version is 9i?
I found the .NET Managed Provider for Oracle and it looked like it still
needed the oracle client?
Mike
| |
by: CT |
last post by:
Hi,
This might seem like a basic question but I have some doubts, please
humour me.
I have a client-server application using java where each client on
each machine needs to directly communicate directly with the database.
Do I need a separate db2 connect on each such machine.
Please advice.
|
by: Arno Stienen |
last post by:
Perhaps I should be a bit more specific. When using this code to connect
to a remote XML-RPC server (C++, xmlrpc++0.7 library):
import xmlrpclib
server = xmlrpclib.Server("http://10.10.101.62:29500")
print server.Connection_Request("roberto")
the Python command line 'hangs' until I kill the server. Then, the
correct output is suddenly displayed:
|
by: dssengar |
last post by:
I am using the code:-
strCon = "Driver={Microsoft ODBC for Oracle}; " & "SERVER= abc; uid=abc;pwd=abc;"
Dim oCon As Object
Set oCon = New ADODB.Connection
Dim oRs As Object
Set oRs = New ADODB.Recordset
oCon.Open strCon
|
by: Demetris |
last post by:
Hi,
I would like to thank you first again for the replies.
Actually to clear some things out, I have an application called
Moody's Financial Analyst
which sits on Oracle (the server mentioned previously). This
applications of course needs the oracle client
to communicate with the server. When I connect to the machine (the
client) with administrative priviledges the applications runs fine.
When I connect on the machine as a power user,...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |