PRB: SQL Errors When Using Alias Name with Extended Characters

ID: Q175317

The information in this article applies to:

Microsoft Visual Database Tools, version 1.0
Microsoft Visual InterDev, version 6.0

SYMPTOMS

The following error occurs when using a query with aliased fields whose alias name contains extended characters:

ODBC error: 37000: [INTERSOLV][ODBC SQL server driver][SQL server]
Incorrect syntax near [ASCII 145]u[ASCII 146]

This issue applies to developers using extended character sets with a Sybase data server backend.

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

Connect to Sybase backend.

Open a new query.

Enter the following SQL code:


      Select au_id as _ber
      From authors

Verify the SQL code. The code Verifies okay.

Run the SQL code.

The error message that was described above appears.

REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site:

http://support.microsoft.com/support/vinterdev/

Additional query words:

Keywords : kberrmsg kbVisDBTools kbVisID kbVisID600 kbGrpASP kbOBDC
Version : WINDOWS:1.0,6.0
Platform : WINDOWS
Issue type : kbprb