Microsoft KB Archive/175317

= PRB: SQL Errors When Using Alias Name with Extended Characters =

Article ID: 175317

Article Last Modified on 5/2/2006

-

APPLIES TO


 * 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.



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.

<div class="references_section">