1 2 Previous Next 20 Replies Latest reply on Nov 8, 2005 12:50 PM by 466436

    ODBC Error

    338055
    338055 Dec 31, 2003 10:19 PM
      Hello,

      I'm getting an error when trying to set up an ODBC data source. I just installed the ODBC driver 9.2.0.54. When I test the connection, I first get an error that says:

      The procedure entry point lxhlcmod could not be located in the dynamic link library oranls9.dll.

      Then I get the same error again. The next message box says:

      Unable to connect
      SQLState=IM004
      [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

      I would be most appreciative of any light someone could shed on this!

      Thank you, and happy new year,

      Owen Gibbins
      • 2875 Views
      • Tags:
        • 1. Re: ODBC Error
          JustinCave
          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
            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
              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
                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
                  338055 Jan 2, 2004 6:51 PM (in response to chukwuma10)
                  I think you did not configure your Data source (ODBC)
                  using the the ODBC Data source Administartor Panel.
                  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.
                  Did you add the Oracle ODBC driver using the File DNS
                  tab. If well confogured, it will work.
                  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.
                  I tried it just now as a File DSN but that didn't work either.
                  • 6. Re: ODBC Error
                    JustinCave
                    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
                      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
                        338055 Jan 2, 2004 10:49 PM (in response to JustinCave)
                        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
                        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)

                        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
                          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
                            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
                              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
                                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
                                or on a remote machine? What error message do you
                                get when your logins fail?
                                Everything is local.
                                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
                                  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
                                    338055 Jan 3, 2004 12:16 AM (in response to JustinCave)
                                    Can you type "tnsping ORCL" at the command-line and
                                    see if that works?
                                    No luck. It says TNS-03505: Failed to resolve name

                                    1 2 Previous Next