Re(2): OS/400 ODBC Setup

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

RPG400-L@midrange.com writes:
>I don't think you actually have to do anything on the AS/400 to set up
>ODBC (although
>I could be misremembering).

Actually, I think you need to make sure you have a Relational Database
Directory Entry with a Remote Location of *LOCAL -- then you use that name
when you set up the data source on your PC.

You can check this with the WRKRDBDIRE command -- if you don't see an
entry, you can create one right there:
"1"
<system name>
*LOCAL

hth

ps: Midrange Computing put a pretty good video out several years ago on
the whole process. It's not too hard, but it's nice to have everything
spelled out.


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.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
+---