This content has been marked as final.
Show 20 replies
-
1. Re: ODBC Error
JustinCave Dec 31, 2003 10:57 PM (in response to 338055)What version of the Oracle client do you have installed?
Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC -
2. Re: ODBC Error
chukwuma10 Jan 1, 2004 6:42 AM (in response to 338055)I think you did not configure your Data source (ODBC) using the the ODBC Data source Administartor Panel. Did you add the Oracle ODBC driver using the File DNS tab. If well confogured, it will work. -
3. Re: ODBC Error
403551 Jan 2, 2004 4:38 PM (in response to 338055)Oracle Objects for OLE Contents / Search /
Contents
Introducing Oracle Objects for OLE
Overview of Oracle Objects for OLE
About the OO4O Automation Server
About Oracle Data Control
About Oracle Objects for OLE C++ Class Library
New Features of Oracle Objects for OLE
Tips and Techniques for Performance Tuning
Requirements
Required Setups
OO4O Redistributable Files
Demonstration Schema and Code Examples
Getting Started with the OO4O Automation Server
Basics of Client Applications
Accessing the OO4O Automation Server
Connecting to the Oracle Database
Detection of Lost Connections
Automation Objects
PL/SQL Support
Executing Commands
Asynchronous Processing
XML Data Interchange
Initializing Oracle LOBs, Objects, and Collections
Large Objects (LOBs)
Oracle Object Datatypes
Oracle Collections
Advanced Queueing Interfaces
Database Schema Objects
Application Failover Notifications
Database Events
Using OO4O with Automation Clients
Overview
With Visual Basic
With Excel
With Active Server Pages (ASP)
Oracle Data Control with Visual Basic
Oracle Data Control with MS VC++
OO4O Code Wizard for Stored Procedures
About the Code Wizard
Supported Datatypes
Using the OO4O Code Wizard
Code Wizard Examples
OO4O Automation Server Reference
Objects
Methods
Properties
Oracle Data Control Reference
Events
Methods
Properties
Troubleshooting
Error Handling
Troubleshooting
http://download-west.oracle.com/docs/cd/B10501_01/win.920/a95895/toc.htm
In general way the information above can help you.
Joel P�rez -
4. Re: ODBC Error
338055 Jan 2, 2004 6:47 PM (in response to JustinCave)Enterprise Manager is version 9.2.0.1.0
Is this the same as the client version? I couldn't find anywhere else that gave a version number.
Thanks,
Owen -
5. Re: ODBC Error
338055 Jan 2, 2004 6:51 PM (in response to chukwuma10)I think you did not configure your Data source (ODBC)
I didn't know there was any other way of doing it. So yes, I did configure the data source using the ODBC Data Source Administrator panel.
using the the ODBC Data source Administartor Panel.
Did you add the Oracle ODBC driver using the File DNS
No, I did it as a System DSN. It used to work... just recently I have started getting these error messages. I have installed Application Server and a newer version of JDeveloper since the last time the ODBC worked.
tab. If well confogured, it will work.
I tried it just now as a File DSN but that didn't work either. -
6. Re: ODBC Error
JustinCave Jan 2, 2004 7:03 PM (in response to 338055)I assume that you installed the application server into a different Oracle Home than the Oracle client. If you go to the Oracle Home Administrator, try selecting the home of your Oracle client. Let me know if that fixes things.
Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC -
7. Re: ODBC Error
chukwuma10 Jan 2, 2004 7:04 PM (in response to 338055)Have you tested you JDeveloper connection to your database to see if the connection is ok without the ODBC. If it does then reconfig your ODBC. -
8. Re: ODBC Error
338055 Jan 2, 2004 10:49 PM (in response to JustinCave)I assume that you installed the application server
Well, that helped a lot, but now there is another problem. I don't get the bizarre error any more, but I can't login as a regular user. I tried the following logins: (ap is the user I want to use for the login)
into a different Oracle Home than the Oracle client.
If you go to the Oracle Home Administrator, try
selecting the home of your Oracle client. Let me
know if that fixes things.
Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
service name=(blank) user=ap -> doesn't work
service name=orcl user=ap -> doesn't work
service name=(blank) user=system -> works
service name=orcl user=system -> doesn't work
I can make do with logging in as system as this is just a development machine. But if anyone can shed some light on this, that would be great!
Thanks for everyone's suggestions and comments so far.
Owen -
9. Re: ODBC Error
338055 Jan 2, 2004 10:53 PM (in response to 338055)I can log in as ap perfectly well from SQL Plus and through JDeveloper. -
10. Re: ODBC Error
chukwuma10 Jan 2, 2004 10:57 PM (in response to 338055)have you created that user you want to use and grant the necessary privileges to the user. -
11. Re: ODBC Error
JustinCave Jan 2, 2004 11:05 PM (in response to 338055)Are you logging in to a database on the local machine or on a remote machine? What error message do you get when your logins fail?
Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC -
12. Re: ODBC Error
338055 Jan 2, 2004 11:28 PM (in response to JustinCave)The user is created and has privileges, which is how I can use it in SQL Plus, etc.
Are you logging in to a database on the local machine
Everything is local.
or on a remote machine? What error message do you
get when your logins fail?
When I use the service name ORCL with user as either system or ap, I get a ORA-12154: TNS:could not resolve service name.
When I use a blank service name and user ap, I get ORA-01017: invalud username/password; logon denied
I don't know why ORCL would not be recognized. It works (and seems to be required) when I logon in SQL Plus. This is the entry in tnsnames.ora: (I renamed every other instance of tnsnames.ora that I found on the system.)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = grapevin-pnanmy)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL.WORKGROUP)
)
)
Thank you,
Owen -
13. Re: ODBC Error
JustinCave Jan 2, 2004 11:44 PM (in response to 338055)Can you type "tnsping ORCL" at the command-line and see if that works?
Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC -
14. Re: ODBC Error
338055 Jan 3, 2004 12:16 AM (in response to JustinCave)Can you type "tnsping ORCL" at the command-line and
No luck. It says TNS-03505: Failed to resolve name
see if that works?