JB0331
asked on
connecting to database using Microsoft ODBC for Oracle
I am trying to connect to an oracle DB from Crystal Reports using Microsoft ODBC for Oracle
When trying now the following error shows up:
The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.
You are unable to use this driver until these components have been installed.
I already have Oracle Client 8.1.6 workstation 2k installed on my PC.
What DLL or files are needed for this to work? I was told I needed to connect using Microsoft ODBC for Oracle.
Thanks
JB
When trying now the following error shows up:
The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.
You are unable to use this driver until these components have been installed.
I already have Oracle Client 8.1.6 workstation 2k installed on my PC.
What DLL or files are needed for this to work? I was told I needed to connect using Microsoft ODBC for Oracle.
Thanks
JB
Try these steps to config
1) use oracle network manager to set properly ip address, port number, oracle sid to point to your database server correctly. You will need to provide a service name. Make sure to run test to make sure the connection is correct.
2) use ODBC configuration tool in control panel / admin tool. You need to provide service name as the server name, oracle username, etc.
3) use the data source name you defined in crystal report... you should be fine.
Good luck
1) use oracle network manager to set properly ip address, port number, oracle sid to point to your database server correctly. You will need to provide a service name. Make sure to run test to make sure the connection is correct.
2) use ODBC configuration tool in control panel / admin tool. You need to provide service name as the server name, oracle username, etc.
3) use the data source name you defined in crystal report... you should be fine.
Good luck
install oracle client runtime; this will install sql*net components.
good luck,
daniels@asix.com
good luck,
daniels@asix.com
whoops, didn't see that thread, you've already done the client install.
sorry,
daniels
sorry,
daniels
the problem is that microsoft is 7.3 compatible and requires sqlnet 2.3 ... this is not part of the oracle8i client! - so to get microsoft ones working you need to install a 7.3 client ... or better, switch to use the Oracle ODBC driver instead (816 client should have installed a oracle816 odbc driver!)
Please note that 816 is not anymore supported - you should at elast switch to 817! .. there is also a seperate 817 ODBC download available on OTN (follow the Download section).
Cheers, Stefan
Please note that 816 is not anymore supported - you should at elast switch to 817! .. there is also a seperate 817 ODBC download available on OTN (follow the Download section).
Cheers, Stefan
ASKER
OK...I loaded Oracle Designer 6i which included SQLnet 2.3 from the OTN web site.
This cleared up the error I was receiving above but now I have another error.
ODBC error:[Oracle][ODBC][Ora] ORA - 12514: Message 12514 not found;product = RDBMS80;facility=ORA
I checked the TNSNAMES.ORA file and the server name is in there.
Thanks,
JB
This cleared up the error I was receiving above but now I have another error.
ODBC error:[Oracle][ODBC][Ora] ORA - 12514: Message 12514 not found;product = RDBMS80;facility=ORA
I checked the TNSNAMES.ORA file and the server name is in there.
Thanks,
JB
set designer as your active oracle home (there is a tool to set this home in your designer install directory : {des6i}\BIN\OHSEL.EXE).
odbc will pickup the file in {des6i}\network(or net80)\admin\tnsnames.ora
then go to command line and use TNSPING.EXE ORACLESID ({des6i}\BIN\tnsping.exe) to check if you really have it properly configured.
often happens that you use default domain names (like ".world") but when copying the tnsnames file to another location (like your new net23 path) you forget to also copy the sqlnet.ora file When using domain names ensure that your SQLNET.ORA which contains a NAMES.DEFAULT_DOMAIN value.
Cheers, Stefan
odbc will pickup the file in {des6i}\network(or net80)\admin\tnsnames.ora
then go to command line and use TNSPING.EXE ORACLESID ({des6i}\BIN\tnsping.exe) to check if you really have it properly configured.
often happens that you use default domain names (like ".world") but when copying the tnsnames file to another location (like your new net23 path) you forget to also copy the sqlnet.ora file When using domain names ensure that your SQLNET.ORA which contains a NAMES.DEFAULT_DOMAIN value.
Cheers, Stefan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Uninstalled and started from scratch using the above method and it worked!
Thank you,
JB
Thank you,
JB
Try this:
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/MDAC/2.71/ManifestUSA.asp
maybe you can try to use Crystal report ODBC driver for Oracle.