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