RE: Microsoft Access and ODBC

[Pete Hall <pbhall@xxxxxxxxxx>]

At 12:18 05/31/2000 , Jerry Kinderman wrote:
> > Has anyone encountered any problems using Microsoft Access via ODBC on the
> > AS/400?  I have configured the file DSN (via Client Access) to point to an
> > AS/400 database file which was created via Query.  Everything seems to
> > work
> > fine when attempting to display the new table in Access (after all other
> > steps are successful), I receive an error on the Microsoft Access side
> > that
> > indicates that the file cannot be viewed.  Now I am aware that Microsoft
> > Access (and most other Windows/DOS applications) really like to have their
> > files accessed via a drive letter (e.g., c:\) and ODBC does not follow
> > this
> > model.  If anyone has any suggestions regarding this (including, "Call
> > Microsoft") I would appreciate it.
> >
> > Jerry Kinderman
> > Lodi, California

Jerry,

Just for grins, check the windows registry 
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/3.5/Engines/ODBC for the 
QueryTimeout value. This is a long integer, and can be set to x'FFFFFFFF'. 
This has caused me some grief in the past. I believe it defaults to 60 
seconds, and the error message that's returned is not helpful. When we dug 
through the server joblog though, it referenced the query timeout.


Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---