Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection string for DB2
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Connection string for DB2
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Database:
DB2
Divers
Thread ID:
01231012
Message ID:
01231012
Vues:
76
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
Fil
Voir

Click here to load this message in the networking platform