|
Use WRKRDBDIRE to make sure you do not have another *LOCAL database defined, you can only have one. This solution solved that exact problem with EXCEL for me without an IPL. Shadrach Scott sscott@hiu.edu -----Original Message----- From: Gary Lehman [mailto:gary_lehman@mail.mchcp.org] Sent: Friday, June 26, 1998 3:43 PM To: MIDRANGE-L@midrange.com Subject: Re: CA400 ODBC error in EXCEL Nick, I did that command before I went into Excel and it still didn't work. I'm not supposed to IPL am I? Nicholas J. Magerl wrote: > 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 > +--- +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.