[dba-SQLServer] OpenRowset

Marty,

Been there, looked at that, no workee. 

Thanks anyway.


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
MartyConnelly
Sent: Sunday, July 01, 2007 4:45 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] OpenRowset

Database Engine Architect InfoCenter

http://msdn2.microsoft.com/en-us/library/ms175560/(SQL.90/).aspx
then to
About Bulk Import and Bulk Export Operations
http://msdn2.microsoft.com/en-us/library/ms187042.aspx


SQL Server 2005 Books Online
OPENROWSET (Transact-SQL)
Way at bottom text file import examples

http://msdn2.microsoft.com/en-us/library/ms190312.aspx

jwcolby wrote:

>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
>
>
>  
>

--
Marty Connelly
Victoria, B.C.
Canada

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