[dba-SQLServer] OpenRowset

Guys,

I am trying to do the following, straight in a query window in SQL Server
2005:

SELECT * FROM
OpenRowset('MSDASQL','Driver={Microsoft Text Driver (*.txt;
*.csv)};DefaultDir=C:\aTestFTP\;','select * from Infutor1.txt') 

I get the following error:

OLE DB provider "MSDASQL" for linked server "(null)" returned message
"[Microsoft][ODBC Text Driver] '(unknown)' is not a valid path.  Make sure
that the path name is spelled correctly and that you are connected to the
server on which the file resides.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for
linked server "(null)".

So what did I do wrong this time?  ;-)

John W. Colby
Colby Consulting
www.ColbyConsulting.com