RE: MaxDB problems working in ORACLE mode with embedded SQL in C/C++ programs (details)

Hi,

Please try the following connect statement:

EXEC SQL CONNECT qecdba IDENTIFIED BY qecdba AT session1 USING
"localhost-quorumec";

In this case username, password, and session name are handled case
insensitive, that means they are uppered and then used for connect to
the database.

If you want a case sensitive handling of username, password, and session
name, you have to write

EXEC SQL CONNECT "qecdba" IDENTIFIED BY "qecdba" AT "session1" USING
"localhost-quorumec";

In this case username, password, and session name are used in lower case
to connect to the database.

Regards,

Thomas Simenec
SAP Labs Berlin

-----Original Message-----
From: Elbertus Lochtenberg [mailto:barry@xxxxxxxxxxxxx] 
Sent: Mittwoch, 29. Dezember 2004 10:29
To: maxdb@xxxxxxxxxxxxxxx
Subject: MaxDB problems working in ORACLE mode with embedded SQL in
C/C++ programs (details)

Dear Reader,
 
At the following the installation and implementation procedure details 
 
Instalation details MaxDB:
 
Unix server:                              HP-UX
Download MaxDB:                    xdb-all-hpux-64bit-hppa-7_5_00_19.tgz
Installation user:                       root
Development account user :       qec
Installation directory:                 /exportacion/Maxdb
 
Database creation with webdbm:
 
Database server:                       localhost
Name :                                     quorumec
DBM user:                                qecdbm
DBM user password:                 qecdbm
DBA user:                                qecdba
DBA user password:                 qecdba
Initialize parameters with default values
OLTP
Data volume DATA0001 size      10000
Log volume LOG001 size           6000
 
Connecting to the database instance with the DBA user:
 
webdbm:                      OK
websql:                        OK
loadercli:                      OK
dbmcli:                         OK
sqlcli:                           OK
Test program run-time:   errror  -709 (CONNECT failed, check SERVERDB)
 
Some embedded SQL connect statement tried in the test program:
 
EXEC SQL CONNECT 'qecdba' IDENTIFIED BY 'qecdba'
           AT 'sesion1' USING 'quorumec';
 
EXEC SQL CONNECT 'qecdba' IDENTIFIED BY 'qecdba'
           AT 'sesion1' USING 'localhost-quorumec';
 
Pre-compiler options:
 
Source file:                   Prueba.cpc 
cpc -H nocheck -E cansi -S oracle -c Prueba
 
Run time creation instruccions and link libraries used:
 
cc Prueba.c +DD64 -I$HOME/include -I$SMPATH/exits 
-L/explotacion/Maxdb/sdb/programs/sdk/7500/incl
-L/explotacion/Maxdb/sdb/programs/sdk/7500/lib/lib64 
-lpcrl -lsqlca -L/usr/lib/pa20_64 -lc 
-o Prueba
 
Special configuratios for ORACLE connection:
 
Parameter file              NO
Configuration file            NO
Environment variables:
 
The only environment variables that I adapt are LD-LIBRARY_PATH, LPATH y
PATH for the location of link libraries en executables of the proper
MaxDB product.
 
Best Regards,
 
Elbertus Lochtenberg
Project Manager
Teleserver S.A.
Mobile: +34628270643
E-mail: barry@xxxxxxxxxxxxx

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx