sqlcxt crash

From: Nelson Teixeira <nt777_at_hotmail.com>
Date: Mon, 06 Jun 2005 15:53:44 -0300
Message-ID: <qt49a11etuhk4hraqitei7t7t22nm0h326_at_4ax.com>

• Post for FREE via your newsreader at post.usenet.com ****

Hello all,

        I am trying to solve this one for the last two weeks, can someone give me a hand ?

        I am trranslating an old c++ code for AIX that accesses Oracle 7.3, to Windows/GCC/wxWidgets. The former program was build using Pro*C embbeded SQL and custom made XClasses. I used Pro*C to precompile it, and after I resolved the (many) compilation and linking problems it didn´t connect to database. So I created a smalll embedded SQL test program that just connects to the database with this code:

    EXEC SQL INCLUDE SQLCA;
    EXEC SQL BEGIN DECLARE SECTION;

        static char user[] = "username";
        static char password[]   = "password";
        static char database[]   = "db_name";

    EXEC SQL END DECLARE SECTION;     EXEC SQL CONNECT :user IDENTIFIED BY :password AT :database;

That code is translated by Pro*C in (among other things) a call to the sqlcxt function that (correct me if I´m wrong) effectively connects to the database.

I have tried this against a Personal Oracle 8.1.6 running in the same machine as the program and worked perfectly. When I tried to use my real server (7.3 version) it crashed in the call to sqlcxt.

To connect to the local Oracle 8.1.6 I was linking the program with the following libraries:

[Quoted] -L C:/Oracle/Ora81/precomp/lib -lorasql8

when I tried to acess Oracle 7.3 I used :

[Quoted] -L C:/ORANT/BIN -lSQLLib18

In my first attempt I had both 7.3 client and 8.1.6 personal installed in my machine. Thinking it could be a version conflict problem I uninstalled both Personal Oracle and 7.3 Client and reinstalled 7.3 Client. This didn´t work. It was still crashing in the sqlcxt call.

I have also tested all the pointers passed as parameters to the sqlcxt function to verify no NULLs where present, yet all pointers have valid addresses.

So now I´m out of ideas. Somebody has any idea of what´s going on ?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
  -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
  

Received on Mon Jun 06 2005 - 20:53:44 CEST