Nelson Teixeira
06-06-2005, 11:11 AM
**** 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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=