Re: ODBC returns SQL error

I think you might be trying to go against an unkeyed or non-unique keyed
file.  The jet engine that all MS apps use for ODBC access demands that
the AS/400 file have a unique key.  If the file has a unique key field,
either recompile it as such or build a logical over it.  If it doesn't,
you could just add a field with some unique value and define it as the
unique key (either of the physical or a logical over it).  

Gary Feinstein wrote:
> 
> Is anyone familiar with this error I am recieving from an ODBC call from
> MS Excel?
> 
> SQL0104 - Token * was not valid.  Valid tokens: (<Identifier>).
> 
> I am not all that familiar with using ODBC and am trying to download a
> simple file to an Excel SS.  What could be causing this error?
> 
> Gary Feinstein
> AS/400 System Administrator
> Planet Hollywood International Inc.
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to "MIDRANGE-L@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 unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---