RE: Client Access ODBC

["Malchow, Grizzly" <GMalchow@xxxxxxxxxxxxxxxxxxxxx>]

Jim, 
Are you using an ODBC provider specified on the PC or is the provider
specified in the program? If it was specified in the program it might
look something like this:
With cn
    .ConnectionString = "DRIVER=Client Access ODBC Driver (32-bit);
SYSTEM=S1040895; DBQ=XXXX; UID=xxxxxxxxxx; PWD=xxxxxxxxxx;"
    .ConnectionTimeout = 5      
    .CursorLocation = adUseServer
    .Open
End With

Otherwise you can look at the odbc datasources in the control panel

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Franz
Sent: Thursday, May 19, 2005 1:33 PM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Client Access ODBC 

Was having problem on single pc using VB to get records from iSeries
(v5r3)
Was at v4r5 CA so we upgraded to latest & applied svc pack 
(it did before & still has odbc part of CA)
Now in starting vb pgm, Runtime error 3706 "Provider Cannot be Found.."
So I thought - new CA, maybe needs to reinstall vb pgm.
Reinstall (no errors).
Same runtime error. 
Any ideas?  Win XP Pro Svc pack 1
Other pc's in same shop not having problem.
jim
-- 

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.