ODBC Error

338055
    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
      • 1. Re: ODBC Error
        JustinCave
        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
          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
            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
              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
                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
                  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
                    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
                      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
                        I can log in as ap perfectly well from SQL Plus and through JDeveloper.
                        • 10. Re: ODBC Error
                          chukwuma10
                          have you created that user you want to use and grant the necessary privileges to the user.
                          • 11. Re: ODBC Error
                            JustinCave
                            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
                              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
                                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
                                  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 上一个 下一个