RE: Client Access Express

[jerickson@xxxxxxx]

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.