Error in MSDASQL - by sqlbotdotnet

Status : 

  External<br /><br />
		This item may be valid but belongs to an external system out of the direct control of this product team.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


0
0
Sign in
to vote
ID 302560 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/4/2007 8:09:04 AM
Access Restriction Public

Description

The error raises since working with linked server whose provider is MSDASQL and Driver={Microsoft Text Driver (*.txt; *.csv)};
Sign in to post a comment.
Posted by Microsoft on 1/27/2008 at 11:35 PM
Dear Customer,

The problem you reported lies with the ODBC text driver (not msdasql) that has an issue with the column aliases. The driver accepts the aliases if the ‘AS’ key word is used.

As you observed, this fails:

SELECT * FROM OPENQUERY(test_text,
'SELECT `Tbl1002`.`TEST TEST TEST` `Col1004` FROM `d:\temp`\`aaa.txt` `Tbl1002`')

However, this succeeds:

SELECT * FROM OPENQUERY(test_text,
'SELECT `Tbl1002`.`TEST TEST TEST` AS `Col1004` FROM `d:\temp`\`aaa.txt` `Tbl1002`')

We will close this bug and re-assign the issue to the appropriate team in the Windows group to see if they can get the provider to support the aliases without the AS keyword (provider ships with Windows not SQL).

Thanks again for reporting this issue. Please don't hesitate to follow-up with me if you have additional questions.

Regards,

Joachim Hammer

Program Manager
SQL Server
Posted by Microsoft on 10/22/2007 at 9:36 AM
Thanks for your feedback. MSDASQL ships as part of Windows not SQL. We will take a quick look at the bug to validate that the scenario is supported, if yes, then I will move the bug to Windows.