[dba-SQLServer] OpenRowset

I would take it you are right.  The file is just a (CSV) file.  It is on a
mapped drive.  What is this "linked server" and why do I need one to open a
file?   


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Monday, July 02, 2007 2:50 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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?  ;-)

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com