Information générale
Titre:
Connection string for DB2
Versions des environnements
Hello experts,
Please advise how to suppress system screen, which pop-ups and requires type username and password during the connection from VFP to DB2 using SQLSTRINGCONNECT() command
STORE SQLSTRINGCONNECT("Driver={IBM DB2 ODBC DRIVER};Database=TESTDB1;Hostname=devblade13;Protocol=TCPIP;Port=50100;"+;
"UID=user;Password=secret",.T.) TO gnConnHandle
IF gnConnHandle <= 0
= MESSAGEBOX('Cannot make connection', 16, 'DB2 Connect Error')
ELSE
= MESSAGEBOX('Connection made', 48, 'DB2 Connect Message')
= SQLDISCONNECT(gnConnHandle)
ENDIF
I did not have this problem for Oracle and SqlServer RDBMSs.
*) STORE SQLSTRINGCONNECT("UID= system;PWD=oracle;DRIVER={Microsoft ODBC For Oracle}; SERVER=dsl11o9") TO gnConnHandle
**) STORE SQLSTRINGCONNECT("DRIVER={SQL SERVER};SERVER=devblade02;UID=sa;PWD=Lev1234") TO gnConnHandle ;
Might it be DB2 specific ?
Thank you very much
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement