RE: OS/400 ODBC Setup

["Richard Jackson" <richardjackson@xxxxxxxxxxxxxxxxxx>]

You must start host servers in order to make sure that the ODBC server is
started.  STRHOSTSRV *ALL works.

You can verify that ODBC is working by using Excel or Access.  You must
start the ODBC administrator applet on your PC (ODBCAD32) and add a data
source.  The only tricky thing that I can think of is the naming must be set
correctly depending on the application - Excel and Access will want SQL
naming and other stuff will want system naming.  Start with SQL naming.  Set
the data source to translate or you might see gibberish - depending on how
you define gibberish.

After the data source is created, go into Excel.  Click on data, get
external data, create a new query.  Then scroll through the database list to
see your ODBC data source name.  I try to name a data source the same as the
library that it points to - makes it easier for me to find.  If you see the
data source, that is good.  After selecting the data source, you see tables
in the database - you are done.  It works.

Access is similar except I think that there is a special open on the file
menu.  Someone else will fill that in.

Both of these are just to verify that it is working.  If you already know
how to do that, make sure that host servers are started and it will work.

Question for the guru's, does client Access file transfer use ODBC?  I never
looked.    If it did, that would make a nice test to see if ODBC is working.

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

-|-----Original Message-----
-|From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
-|Behalf Of Jim Langston
-|Sent: Thursday, October 05, 2000 11:51 AM
-|To: RPG400-L@midrange.com
-|Subject: Re: OS/400 ODBC Setup
-|
-|
-|I don't think you actually have to do anything on the AS/400 to
-|set up ODBC (although
-|I could be misremembering).  The information you give to the ODBC
-|driver for the AS/400
-|includes the information necessary to get to the file.  IP of the
-|AS/400 basically.
-|Then when used the user needs to sign on with a valid user name
-|and password.  Then
-|though SQL commands the AS/400 knows what file(s) the user wants.
-|
-|Regards,
-|
-|Jim Langston
-|
-|I thought I was wrong once, but I was mistaken.
-|
-|Ted Barry wrote:
-|>
-|> I think I've asked the question before, but it's come back to
-|the surface.
-|> How do I (or do I need to) setup ODBC on the 400?  Any help would be
-|> greatly appreciated.
-|>
-|> Thanks,
-|>
-|> Ted J. Barry
-|+---
-|| This is the RPG/400 Mailing List!
-|| To submit a new message, send your mail to RPG400-L@midrange.com.
-|| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
-|| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
-|| Questions should be directed to the list owner/operator:
-|david@midrange.com
-|+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---