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

Click here to load this message in the networking platform