473,624 Members | 2,346 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Oracle ODBC Drivers

I'm trying to connect to an Oracle db on our network, through either
SQL Server 2000 or Access 2000. Do I have to have Oracle client
software loaded on my machine in order to do this or can I just
download drivers alone?
Jul 19 '05 #1
1 3853

"Dave" <da**********@m sn.com> wrote in message
news:a2******** *************** ***@posting.goo gle.com...
I'm trying to connect to an Oracle db on our network, through either
SQL Server 2000 or Access 2000. Do I have to have Oracle client
software loaded on my machine in order to do this or can I just
download drivers alone?

You need the Oracle client software.
Jim
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
2349
by: Dan Ellis | last post by:
Hi, I've been down so many dead ends trying to get something working, so I'm really hoping someone can help out. I need to access an Oracle database running on a Windows server from Python running on Linux. I've tried building DCOracle2, but it seems that the 'oracle-installclient-basic' thing I downloaded from the Oracle site doesn't contain enough. I've tried various other approaches, such as mxODBC/iODBC, but without much luck. I'm...
1
2881
by: simianphile | last post by:
OK, I had a problem that I've now fixed but I can't really understand what was causing it in the first place. I have an intranet site that uses basic authentication to allow users to view and update information from an Oracle DB (ver 8.1.6 -- ancient, I know). Anyway, the site worked fine as long as the machine accessing the ASP page was running Win 2k but when an XP machine tried to view the page, the client got an error: Microsoft...
2
14314
by: Bill | last post by:
Does anybody know if it is possible to run two different instances (and potentially different releases) of Oracle client on one Windows 2000 PC? I'd like to do this so that I can have one that I know is stable, and a second to apply patches and test. I imagine if I install into 2 different directories the install will work, but are there any ramifications, such as with ODBC Data Sources & drivers, etc? After I am done with both...
0
2266
by: Spiggy Topes | last post by:
Hi I have a Visual Basic application that uses ADO to access an Oracle database. I have the latest 9.x ODBC drivers installed, and SQL*Plus tells me I'm looking at Oracle 8i release 8.1.7.4.1 through an Oracle client version 9.2.0.1.0. I'm assuming that these should be compatible... The application has, until now, been running on the MS ODBC drivers for Oracle, but we'd like to get away from using LONGs, and use the
1
4713
by: Cliff Cooley | last post by:
Can anybody suggest what may be causing the following problem ? I have an ASP script that opens a connection to an Oracle database using a DSN connection string, such as : Set dbConn= Server.CreateObject("ADODB.Connection") dbConn.Open "DSN=somedsn; UID=someuser; PWD=somepassword" With the ASP running on an IIS 5 server, using the Oracle 8 driver to connect to an Oracle 9 database, there are no connection problems, and
5
13206
by: jrefactors | last post by:
My machine is Windows XP with Oracle 9.2 Home; IIS and Oracle are in the same box. I have tried both Oracle OLEDB Provider and Microsoft ODBC For Oracle, but both not working. For Microsoft ODBC For Oracle approach, I added a data source in Oracle Data Source Administrator, in System DSN tab, I created a system data source named OracleDSN with Microsoft ODBC for Oracle.
2
1768
by: Miikka Hamalainen | last post by:
Hi, We have huge oracle database in my company. I would like to make some queies using access. I've been trying to connect access to this oracle db, but without any luck. Do I need to have some oracle drivers? We are using other program to get information from the db and we have acquired drivers for that program. Any help is appreciated.
13
7464
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem. Using the exact same code (copy and paste) into a Web app I get the following error "Error while trying to retrieve text for error ORA-01019". Security I thought, so I use Impersonation on the Web site, then the aspnet_wp.exe crashes with "The...
6
17625
by: BillCo | last post by:
I've reached the limit of my knowledge here and I'm starting to go mad - any help would be greatfully recieved!!!! I'm having a strange problem with making pass through queries to an oracle db with a permament connection string. - if i create the passthrough query by writing the sql into the sql builder window and selecting the connection details on opening the query then everything works fine
4
2148
by: reachravi | last post by:
Hi, In our ASP application, we are using a visual basic Dll file to perform database operations. We have a function in our Dll file for executing stored procedures. This function takes 3 input parameters from ASP
0
8233
marktang
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...
0
8170
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8675
Oralloy
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...
1
8334
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,...
0
8474
tracyyun
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...
0
7158
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4078
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4173
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1482
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.