General information
Title:
Connection string for DB2
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only