RE: SQL Question...

[Kurt Goolsbee <K.goolsbee@xxxxxxxxxxxxx>]

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