SQL7 to ORACLE 7.3 via ODBC - Advice Needed

SQL7 to ORACLE 7.3 via ODBC - Advice Needed

Post by Lajos G. Gut » Fri, 25 Aug 2000 10:11:34



After finally getting the MSSQL server to see the other boxes on the network
I have
been trying to setup the DTS services to connect to an ORACLE 7.3 Server via
ODBC.

The DTS Wizard gives me the following error message:

"The Oracle client and networking components were not found.  These
components
are supplied by Oracle Corporation and are part o the Oracle Version 7.3
client
software installation.  You will be unable to use this driver until these
components have
been installed."

My question is what Oracle client software??  I found some Oracle
applications but do not
know specifically which to setup:

Oracle Client Configuration 3.2.2.1.0
Oracle Client Software Agent 3.2.2.1.0
Oracle Installer
Oracle 7 32bit ODBC Driver

Any help would be appreciated....

Lajos

 
 
 

SQL7 to ORACLE 7.3 via ODBC - Advice Needed

Post by <Contac.. » Sat, 26 Aug 2000 04:00:00


You need Oracle 73 drivers installed on your system and you will be fine.
Oracle has an article base that can help you at their site.  Once you
install them you can go into your control panel, odbc data source and set up
an odbc connection to the oracle tables it should work great.

Hope this helps,
Streamliners



Quote:> After finally getting the MSSQL server to see the other boxes on the
network
> I have
> been trying to setup the DTS services to connect to an ORACLE 7.3 Server
via
> ODBC.

> The DTS Wizard gives me the following error message:

> "The Oracle client and networking components were not found.  These
> components
> are supplied by Oracle Corporation and are part o the Oracle Version 7.3
> client
> software installation.  You will be unable to use this driver until these
> components have
> been installed."

> My question is what Oracle client software??  I found some Oracle
> applications but do not
> know specifically which to setup:

> Oracle Client Configuration 3.2.2.1.0
> Oracle Client Software Agent 3.2.2.1.0
> Oracle Installer
> Oracle 7 32bit ODBC Driver

> Any help would be appreciated....

> Lajos


 
 
 

SQL7 to ORACLE 7.3 via ODBC - Advice Needed

Post by Lajos G. Gut » Sat, 26 Aug 2000 04:00:00


Thanks for the advice, I have gotten as far as loading the ODBC driver and
setting
up the datasource however I cannot seem to install or get a working version
of SQL*NET 2.3 for
Windows 2000.

Where exactly do I find the article base??

Lajos


> You need Oracle 73 drivers installed on your system and you will be fine.
> Oracle has an article base that can help you at their site.  Once you
> install them you can go into your control panel, odbc data source and set
up
> an odbc connection to the oracle tables it should work great.

> Hope this helps,
> Streamliners



> > After finally getting the MSSQL server to see the other boxes on the
> network
> > I have
> > been trying to setup the DTS services to connect to an ORACLE 7.3 Server
> via
> > ODBC.

> > The DTS Wizard gives me the following error message:

> > "The Oracle client and networking components were not found.  These
> > components
> > are supplied by Oracle Corporation and are part o the Oracle Version 7.3
> > client
> > software installation.  You will be unable to use this driver until
these
> > components have
> > been installed."

> > My question is what Oracle client software??  I found some Oracle
> > applications but do not
> > know specifically which to setup:

> > Oracle Client Configuration 3.2.2.1.0
> > Oracle Client Software Agent 3.2.2.1.0
> > Oracle Installer
> > Oracle 7 32bit ODBC Driver

> > Any help would be appreciated....

> > Lajos

 
 
 

SQL7 to ORACLE 7.3 via ODBC - Advice Needed

Post by <Contac.. » Sun, 27 Aug 2000 04:00:00


Go to : http://technet.oracle.com/software/

This will take you to the download page, click on the combo box to the right
and choose Oracle ODBC Drivers.  This will give you all your drivers I think
you will need.  However, there is not a specific one listed for win2000.
Try using the one for windows or windowsNT.

Hope this helps.
Streamliners



> Thanks for the advice, I have gotten as far as loading the ODBC driver and
> setting
> up the datasource however I cannot seem to install or get a working
version
> of SQL*NET 2.3 for
> Windows 2000.

> Where exactly do I find the article base??

> Lajos



> > You need Oracle 73 drivers installed on your system and you will be
fine.
> > Oracle has an article base that can help you at their site.  Once you
> > install them you can go into your control panel, odbc data source and
set
> up
> > an odbc connection to the oracle tables it should work great.

> > Hope this helps,
> > Streamliners



> > > After finally getting the MSSQL server to see the other boxes on the
> > network
> > > I have
> > > been trying to setup the DTS services to connect to an ORACLE 7.3
Server
> > via
> > > ODBC.

> > > The DTS Wizard gives me the following error message:

> > > "The Oracle client and networking components were not found.  These
> > > components
> > > are supplied by Oracle Corporation and are part o the Oracle Version
7.3
> > > client
> > > software installation.  You will be unable to use this driver until
> these
> > > components have
> > > been installed."

> > > My question is what Oracle client software??  I found some Oracle
> > > applications but do not
> > > know specifically which to setup:

> > > Oracle Client Configuration 3.2.2.1.0
> > > Oracle Client Software Agent 3.2.2.1.0
> > > Oracle Installer
> > > Oracle 7 32bit ODBC Driver

> > > Any help would be appreciated....

> > > Lajos

 
 
 

SQL7 to ORACLE 7.3 via ODBC - Advice Needed

Post by Peter Clar » Sat, 09 Sep 2000 16:15:02


The quickest way to resolve this problem is to use the Oracle installation
CD and just add the client to your SQL machine.

That will put all of the necessary software on your machine.

Peter



Quote:> After finally getting the MSSQL server to see the other boxes on the
network
> I have
> been trying to setup the DTS services to connect to an ORACLE 7.3 Server
via
> ODBC.

> The DTS Wizard gives me the following error message:

> "The Oracle client and networking components were not found.  These
> components
> are supplied by Oracle Corporation and are part o the Oracle Version 7.3
> client
> software installation.  You will be unable to use this driver until these
> components have
> been installed."

> My question is what Oracle client software??  I found some Oracle
> applications but do not
> know specifically which to setup:

> Oracle Client Configuration 3.2.2.1.0
> Oracle Client Software Agent 3.2.2.1.0
> Oracle Installer
> Oracle 7 32bit ODBC Driver

> Any help would be appreciated....

> Lajos

 
 
 

1. I need help connecting Personal Oracle 7.3 to Delphi 3 via ODBC

I know this has been hashed out here before, and I've read all the
messages, but I have no hair left to pull out.

If I'm going to sell my supervisor on using Delphi (we already use
Oracle), I'm going to have to give him a demo.  I only have the
standard edition of Delphi 3, but (according to the box) I should be
able to connect via ODBC.  Good enough for a demo.

I've tried everything.  I keep getting the error message:  "General
SQL error [Microsoft][ODBC driver manager] Information type out of
range."   BDE Error 13059 [$33][$3]

I installed Personal Oracle 7.3 with all the options and the
directories are on my path.  I installed Delphi 3 with all the
options.  I have the ODBC drivers installed correctly (at least as far
as I know).  I can connect to it with an ODBC test program that comes
with Oracle.  I've used the BDE to add the configuration and the
alias.

But when I try to connect to it with Database Explorer, I keep getting
the above message after I enter my userid and password.

I would greatly appreciate any assistance.  Thanks in advance.

2. HELP@

3. Opening Oracle 7.3 database via ODBC in VB4

4. IMPORT EPS FILES

5. Connection Oracle 7.3 via ODBC

6. !JOBS! JOBS! JOBS! JOBS! JOBS! JOBS!

7. Cannot Connect To ORACLE 7.3 via ODBC and CDataBase

8. pgsql-server/doc/src/sgml Makefile array.sgml ...

9. Help: Connection to Oracle 7.3 via ODBC/JET/DAO

10. connection ASP - Oracle 7.3 via ODBC?

11. Opening Oracle 7.3 database via ODBC (16bits) with VB4 16-bits development environnement

12. Oracle 7.3 Time Field to SQL 7.0 via ODBC

13. need advice on Conversion from Ver 6.o to 7.3