Re: ODBC

[lgoodbar@xxxxxxxxxxx (lg - Loyd Goodbar)]

On Fri, 26 Jun 1998 11:43:10 -0500, Gary Lehman <Gary_Lehman@mail.mchcp.org>
wrote:

>Hello,
>
>I was wondering if anyone knew anything about the Client Access 32 bit ODBC
>driver.  I can get it to work in Access but when I try to use it in Excel
>I'm getting an SQL0104 error - Token * was not valid. Valid tokens:
><IDENTIFIER>.  The help just says there is something wrong with the driver,
>but it's the most up to date driver that I know of.  Does anyone have any
>suggestions?
>
>
>Gary Lehman
>Programmer Analyst
>Missouri Consolidated Health Care Plan

On the AS/400, do you have the relational db directory entry?
ADD[WRK]RDBE (I believe). You put in the system name (as shown in DSPNETA) and
*LOCAL for directory if you're accessing a local /400 (not passed through). 

I only recently got Excel (97) set up with SQL access via ODBC. It takes a bit
of experimenting, both with CA's ODBC administrator, and with MS Query's Data
Sources.

Hope this helps..........
 - lg -

--  
"You can nail me, but not to a tree."
lgoodbar@tecinfo.com  ICQ#504581  http://www.tecinfo.com/~lgoodbar/
+---
| 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
+---