Re: CA400 ODBC error in EXCEL

["Nicholas J. Magerl" <nmagerl@xxxxxxxxxxxx>]

I had the same problem early on.  Per the ODBC User's Guide pg. C-6, run
the following command:  ADDRDBIRE RDB(SYSNAME) RMTLOCNAME(*LOCAL)
where SYSNAME is the name of your system's default local location name (as
specified by the DSPNETA command)

Good Luck
Nick

At 01:39 PM 6/26/98 -0500, you wrote:
>I apologize for lack of subject.  Here is the question again:
>
>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
>+---
>| 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
+---