[dba-SQLServer] OpenRowset

John,

 From the linked server "null" returned, I would guess
that you did not have a linked server defined for
the file you are looking for.

Robert

At 12:00 PM 7/2/2007, you wrote:
>Date: Sun, 1 Jul 2007 14:37:50 -0400
>From: "jwcolby" <jwcolby at colbyconsulting.com>
>Subject: [dba-SQLServer] OpenRowset
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <20070701183759.0C4D0BC6C at smtp-auth.no-ip.com>
>Content-Type: text/plain;       charset="us-ascii"
>
>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?  ;-)