Knowledge Base

PRB: SQL Errors When Using Alias Name with Extended Characters

Article ID: 175317

Article Last Modified on 5/2/2006

Microsoft Visual Database Tools
Microsoft Visual InterDev 6.0 Standard Edition

This article was previously published under Q175317

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/search/default.aspx?qu=vinterdev

Keywords: kberrmsg kbprb KB175317