Client Access ODBC To AS400 4

[Skittle]

This isn't really an RPG question but its the best place I can think of to get help on this one. I didn't get any help from the ODBC forum.

I have a VB program that reads a file on the AS400 via ODBC
using a connection string:-

objConn02.Open "Provider=IBMDA400Data
Source=99.99.99.99;", "myuser", "mypassword"

The trouble is that if I have not started Client Access and
signed on to a normal emulation screen, I get an error on the attempt to connect:-

Run Time Error '-2147217843' (80040e4d)
[IBM][Client Access Express ODBC Driver (32-bit)]
Communication link failure .comm rc=8270 - CWBSY0270 - User profile will be disabled with next invalid password, password length = 0, prompt mode = never, system ip address = 99.99.99.99".

If I start Client Access it works fine.
Is there somthing I need to do with Client Access in addition to creating the ODBC link?

Dazed and confused

 

[as400pro]

Here is the direct link to the Client Access Express Toolkit.

http://www-1.ibm.com/servers/eserver/iseries/access/toolkit/

There are examples for using OLE DB in various programming languages, Lotusscript, Delphi, VB, C++, Powerbuilder...

T. Bishop

http://www.as400pro.com

 

[Skittle]

Thanks again everynoe.

If nothing else, I think the key thing I've learnt is to use the OLE DB Access provider. It seems to cover everything and is easier to use. I had dug up a couple of books that indicated API's were the way to go...they are of course out of date!

in the fire they go.

)


Dazed and confused