🚀 go-pugleaf

Bert,
> Ik krijg die error als ik een dataconnectie wil maken in Microsoft
> Visual Interdev
Hopelijk helpen volgende voorbeelden je op de juiste weg. Kijk vooral
naar
UID=user;PWD=password
-------------------------------------------------------------------
Dim cnn As Object
Set cnn = CreateObject("ADODB.Connection")
 
'ODBC with DSN
 cnn.Open "DSN=dsn;UID=user;PWD=password"
 cnn.Open "DSN=dsn", "user", "password"
 
'ODBC DSNless
 cnn.Open "DRIVER=iSeries Access ODBC
driver;SYSTEM=system;UID=user;PWD=password"
 cnn.Open "DRIVER=iSeries Access ODBC driver;SYSTEM=system", "user",
"password"
 
'OLEDB
 cnn.Open "Provider=IBMDA400;Data Source=system;UID=user;PWD=password"
 cnn.Open "Provider=IBMDA400;Data Source=system", "user", "password"
 
'ODBC without user
 cnn.Open "DSN=dsn;prompt=2"
 
... in this last example, if you don't include the prompt=2, at the
first log-in you may
well get this error (this will depend on a multitude of other settings
in Navigator and/or
the DSN):
 
[IBM][iSeries Access ODBC Driver]Communications link failure. comm
rc=8015 - CWBSY1006 -
User ID is invalid, Password length = 0, Prompt Mode = Never, System
IP Address =
xxx.xxx.xxx.xxx
---------------------------------------------------------------
Volledige post >> http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=b4o2qvgs4cg9570ug2k5i5oa1dn0cd0lji%404ax.com&rnum=6&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26q%3Dibm%2Bclient%2Baccess%2Bodbc%2Bdsn


Sukses,

Kris De Decker
______________ 
ps: cruciale bedrijfsinformatie in een overzichtelijk formaat >>
http://www.jerboa.be/blog/Articles/Nytro/infosheets.html