RE: Client Access Express

["Phil" <sublime78ska@xxxxxxxxx>]

Any details?

My first thought is to check the naming convention you're using versus the
naming convention defined in the ODBC config.  Normally sql looks like
'SELECT * FROM LIBRARY.FILE' but on the as/400 it could be 'SELECT * FROM
LIBRARY/FILE'.  Make sure what you're using is what is defined in the ODBC
config.

Phil

> -----Original Message-----
> From: midrange-l-admin@midrange.com
> [mailto:midrange-l-admin@midrange.com]On Behalf Of Brown, Camille
> Sent: Friday, August 31, 2001 7:29 PM
> To: midrange-l@midrange.com
> Subject: Client Access Express
>
>
> I'm sure this must be a simple solution, and my hair is really
> turning gray
> as I try to solve the problem so thought I would turn to you all for some
> assistance.  I am running V4R5 Client Access Express, latest service pack.
> Whenever I open Excel (Office 2000) and try to do an ODBC
> connection, I can
> go through the entire query, but when I try to finish, I get an
> SQL error -
> SQL0104.
>
> Thanks,
>
> Camille Brown
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L)
> mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com