RE: Client Access Express

[Andy Youens <Andy@xxxxxxxxxxxxxxxx>]

Camille

Have you set you relational database entries for the local system on the
AS/400 - WRKRDBDIRE ?

This has to have an entry for the local system, i.e..



         Relational          Remote

 Option  Database            Location                  Text



         JANS400             *LOCAL                    Jans400 Relational
Database

Regards

Andy Youens
FormaServe Systems

T: 01908 319566
F: 01908 316000
M: 07770 380276
E: mailto:Andy@FormaServe.Co.Uk <mailto:Andy@FormaServe.Co.Uk>
W: www.FormaServe.Co.Uk <http://www.FormaServe.Co.Uk>



-----Original Message-----
From: jerickson@800.com [mailto:jerickson@800.com]
Sent: 04 September 2001 16:19
To: midrange-l@midrange.com
Subject: RE: Client Access Express


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
This sounds vaguely familiar,.. I think it might be a problem with MSQuery
when encountering a field name with a special character, e.g. $, if you can
rename the field in the query, it should work.

HTH,

Regards,
Jon A. Erickson
Sr. Programmer Analyst
800.COM Inc.
1516 NW Thurman St
Portland, OR  97209-2517

Direct: 503.944.3613
Fax: 503.943.9313
Web: http://www.800.com


-----Original Message-----
From: Brown, Camille [mailto:CBrown@che400.state.sc.us]
Sent: Friday, August 31, 2001 4: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.
_______________________________________________
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.
This message contains confidential information and is intended solely for
the named addressee.
If you are not the named addressee you should not distribute, copy or take
any action in relevance to the contents of this email.
FormaServe Systems does not accept liability for any errors or omissions in
the contents of this message or attached documents or for any damage
suffered by your computer system caused by any errors or viruses contained
in the email or any attached documents.