Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection string for DB2
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Database:
DB2
Divers
Thread ID:
01231012
Message ID:
01231274
Vues:
14
Thank you Sergey,
now it works


>It should be 'pwd' not 'password'
>
>...+ "Uid=user;Pwd=secret",...
>
>>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
>
>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform