Microsoft Query

[Nick McDaniel - nick]

I receive message SQL0104 when changing a column heading
in Microsoft Query while using the Client Access ODBC
driver to connet to an iSeries 400 server. I have been
informed by IBM that this is a problem with Microsoft's
Query in that it incorrectly quotes the new Column Heading
name before sending it to the ODBC Driver . Is anyone
aware of a update or solution?

Thanks

Nick

 

[Guest]

Thanks everyone, I just located the following Microsoft
Knowledge Base Article 298955, I followed the procedures
below, and the SQL0104 error went away.

1. Quit all Office programs..
2. Click Start, and then click Run.
3. In the Open box, type regedit, and then click OK.
4. Locate, and then click to select the following
registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0
\query\options
5. After you select the key that is specified in step 4,
point to New on the Edit menu, and then click DWORD Value.
6. Type AllowAlias, and then press ENTER.
7. Right-click AllowAlias, and then click Modify.
8. In the Value data box, type 2, and then click OK.
9. On the File menu, click Exit to quit Registry Editor.