sqlcxt crash

[Nelson Teixeira]

**** 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:

-L C:/Oracle/Ora81/precomp/lib -lorasql8

when I tried to acess Oracle 7.3 I used :

-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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

[Jesper Madsen]

You might have different byte alignment than the Oracle library.. It has
bitten me a couple of times...
--
Jesper Madsen, SAXoTECH

"The truth of the matter is that you always know the right thing to do. The
hard part is doing it"
- General H. Norman Schwartzoff
"Nelson Teixeira" <nt***@hotmail.com> wrote in message
news:ik********************************@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:

-L C:/Oracle/Ora81/precomp/lib -lorasql8

when I tried to acess Oracle 7.3 I used :

-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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=