Re: Microsoft Access and ODBC

["Shadrach Scott" <shadrachscott@xxxxxxxxxxxxx>]

With MS Access you need to use either System or User DSN. The ODBC manual
suggests System.

Shadrach Scott

----- Original Message -----
From: "Jerome Kinderman" <msplus@pacbell.net>
To: <MIDRANGE-L@midrange.com>
Sent: Wednesday, May 31, 2000 5:53 PM
Subject: RE: Microsoft Access and ODBC


> I am using Access 2000.  I created a File DSN using Client Access's Data
> Source Administration.  I am able to select the file I want to link to on
> the AS400 as well as view and select the key fields in those files.  The
> error is on the Microsoft Access side: "Reserved Error (-7778); there is
no
> message for this error"  and "Access cannot open the table in datasheet
> view."  Nor can it open it in any other view.  I attempted to create a
form
> to view the data there, but I receive the same error.  Any help would be
> appreciated.
>
> Jerry Kinderman
> Lodi, California
>
> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Bale, Dan
> Sent: Wednesday, May 31, 2000 10:19 AM
> To: 'MIDRANGE-L@midrange.com'
> Subject: RE: Microsoft Access and ODBC
>
>
> What specific error message are you getting?  What version of Access are
you
> using?  Which ODBC?
>
> I am unclear on where the error is popping up.  Are you getting an AS/400
> signon window?  Are you seeing a list of file names available from your
> library list to be imported?
>
> We were getting an error where we would select the AS/400 file and click
> Import; after about 5-10 seconds, an error window would appear, something
> about a "file unavailable" or somesuch, even though the file was not at
all
> allocated on the AS/400.  Our fix was to reinstall Access.
>
> I highly doubt that the drive letter issue is a problem.
>
> hth,
> Dan Bale
>
> > -----Original Message-----
> > From: Jerome Kinderman [SMTP:msplus@pacbell.net]
> > Sent: Wednesday, May 31, 2000 11:44 AM
> > To: MIDRANGE-L@midrange.com
> > Subject: Microsoft Access and ODBC
> >
> > 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
> +---
> | 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
> +---
>
> +---
> | 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
> +---
>

+---
| 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
+---