Home Dashboard Directory Help
Search

Error in MSDASQL by sqlbotdotnet


Status: 

Closed
 as External Help for as External


0
0
Sign in
to vote
Type: Bug
ID: 302560
Opened: 10/4/2007 8:09:04 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

The error raises since working with linked server whose provider is MSDASQL and Driver={Microsoft Text Driver (*.txt; *.csv)};
Details
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.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
aaa.txt (restricted) 10/4/2007 -