RE: SQL Question...

["Richard Jackson" <richardjackson@xxxxxxxxxxxxxxxxxx>]

Which part is the grin for?

Oh, like maybe the IBM Client Access ODBC drivers won't work for an MS
Access target?  Probably true.  I can use access odbc drivers to talk to an
access database on my PC machine and that is what I was thinking.  So, what
does that mean for the AS/400 ODBC client support?  Only to another AS/400?
That would be sort of pointless.

Richard Jackson
mailto:richardjackson@richardjackson.net
www.richardjacksonltd.com
Voice: 1 (303) 808-8058
Fax:   1 (303) 663-4325

-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Kurt Goolsbee
Sent: Tuesday, July 18, 2000 5:46 PM
To: MIDRANGE-L@midrange.com
Subject: RE: SQL Question...


Actually this will not work.  Access is not a C/S database.  You would need
MS Access 2000 for OS/400 :-)

> -----Original Message-----
> From: Richard Jackson [SMTP:richardjackson@richardjackson.net]
> Sent: Tuesday, July 18, 2000 3:33 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      RE: SQL Question...
>
> There was reputed to be a version of OS/400 that allowed the AS/400 to act
> as an ODBC client - not a server, a client.  If you can find that, then
> you
> can use the 400 to connect to a client machine containing the .mdb using
> ODBC.
>
> If you put the .mdb into the IFS, what application on your AS/400 knows
> how
> to read an mdb?  Nothing that I know of.
>
> Richard Jackson
> mailto:richardjackson@richardjackson.net
> www.richardjacksonltd.com
> Voice: 1 (303) 808-8058
> Fax:   1 (303) 663-4325
>
> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Hatzenbeler, Tim
> Sent: Tuesday, July 18, 2000 12:57 PM
> To: 'MIDRANGE-L@midrange.com'
> Subject: SQL Question...
>
>
> I'm trying to read a microsoft Access Database... And I was wondering if I
> can do it from the AS/400 via SQL?
>
> So my question is this, if I place the access database on the IFS, can I
> run
> SQL on the as/400 and read the database?  And if so, how would I point to
> it?
>
> TIA, tim
>
>
> +---
> | 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
+---

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