Re: ODBC to AS/400 using Visual Basic 4.0

["Chris Devous" <cdevous@xxxxxxxxxxx>]

Don,

You're trying to use RDO?  Can you connect using your DSN from another
application like Access?  If so, you're dealing with malformed syntax.  If not, 
your
data source may be configured incorrectly.

If I may make a recomendation:  Upgrade to VB.NET, or VB6 if you can find it, 
get
the latest version of MDAC, and use activex data objects (ADO).  (I'm assuming
you're on some version of Client Access Express, which comes with it's own data
provider for ADO).  It's much easier, and you can treat any recordset 
essentially the
same regardless of the RDBMS behind it (although there are minor differences in
supported features from provider to provider).

--Chris

> From: "Fisher, Don" <Dfisher@roomstoreeast.com>
> To: "'midrange-l@midrange.com'" <midrange-l@midrange.com>
> Subject: ODBC to AS/400 using Visual Basic 4.0
> Date: Thu, 12 Sep 2002 14:40:19 -0400
> Reply-To: midrange-l@midrange.com
>
> I am attempting to establish an ODBC connection to the AS/400 (V4R1)
> from Visual Basic 4.0.  Trouble is, I'm getting a strange message in
> the QZDASOINIT job, "MSYSCONF in RMTESTDATA type *FILE not found.".
> Naturally the file I'm attempting to open is not MSYSCONF.  I believe
> this has something to do with why my openrecordset operation is
> failing.  Anyone have any ideas? Thanks.
>
> Donald R. Fisher, III
> Project Manager
> The Roomstore Furniture Company
> (804) 784-7600 extension 2124
> DFisher@roomstoreeast.com
>
>