RE: Connection via ODBC / QT3-Plugin

Hello Holger,

could you try with user and password in the case they have been
created (i.e. probably use TEST/TEST in your case)?

Regards
Alexander Schröder
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: Holger Schurig [mailto:hs4233@xxxxxxxxxxxxxxxxxxxx] 
> Sent: Monday, December 27, 2004 4:03 PM
> To: maxdb@xxxxxxxxxxxxxxx
> Subject: Connection via ODBC / QT3-Plugin
> 
> Two years ago I wrote the sapdb-qt3 database plugin. This 
> tool works by 
> using libsqlod.so directly, e.g. without unixODBC. Now I 
> tried now to do 
> this again with and found out that it cannot longer 
> connect. I'm wondering why.
> 
> 
> My connect operation looks like this:
> 
> ----------------------------
>     QString connQStr = "UID=" + user + 
>                        ";PWD=" + password + 
>                        ";SERVERNODE=" + host + 
>                        ";SERVERDB=" + db +
>                        ";TRACEFILENAME=test.trc";
>     qDebug("connQStr string is %s", connQStr.latin1());
>     SWORD       cb;
>     SQLCHAR connOut[255];
> 
>     r = SQLDriverConnect( d->hDbc,
>                             NULL,
>                             (SQLCHAR*)connQStr.local8Bit().data(),
>                             SQL_NTS,
>                             connOut,
>                             255,
>                             &cb,
>                             SQL_DRIVER_NOPROMPT);
> ----------------------------
> 
> So the connection string is
> 
> ----------------------------
> UID=test;PWD=test;SERVERNODE=mnz66;SERVERDB=TST;TRACEFILENAME=test.trc
> ----------------------------
> 
> 
> 
> The generated trace file looks like this:
> 
> ----------------------------
> PRODUCT : SAP DB C-PreComp Runtime
> VERSION : 7.4.3
> BUILD   : 032-121-068-842
> 
> DATASOURCE:
> SESSION   : 1;
> SQLMODE   : INTERN
> SERVERDB  : TST
> SERVERNODE: mnz66
> CONNECT "test              " IDENTIFIED BY :A   ISOLATION LEVEL 1
> SQLCODE:  -4008      Unknown user name/password combination
> SQLERRD(INDEX_5) : 1         SEC. FOR STATEMENT
> START  :  DATE :  2004-12-27    TIME :  0015:48:23
> END    :  DATE :  2004-12-27    TIME :  0015:48:24
> 
> SQCFINISH
> ----------------------------
> 
> (my DB server is 7.4.3.32)
> 
> 
> 
> However, I can connect to the database via python or dbmcli:
> 
> ----------------------------
> mnz66:/usr/src/sapdb-qt3/2-infos# dbmcli -d TST -u dba,dba 
> -uSQL test,test
> dbmcli on TST>sql_execute select * from dual
> OK
> END
> 'a'
> 
> ---
> ----------------------------
> 
> Any idea of what is wrong here?
> 
> 
> -- 
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    
> http://lists.mysql.com/maxdb?unsub=alexander.schroeder@xxxxxxx
> 
> 
> 

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