Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection string for DB2
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Connection string for DB2
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Database:
DB2
Miscellaneous
Thread ID:
01231012
Message ID:
01231012
Views:
77
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
Map
View

Click here to load this message in the networking platform