SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



OLE DB provider "MSDASQL" refencede Expand / Collapse
Author
Message
Posted Wednesday, February 04, 2009 12:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 05, 2009 8:21 PM
Points: 3, Visits: 35
i want to select data from csv file , use following command

select *
from OpenRowset('MSDASQL',
'Driver={Microsoft Text Driver (*.csv)};
DBQ=C:\myFolder\',
'select * from myFile')

but it giving following error message

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

how i add referece of MSDASQL ?
how i solve this problem ?

Thanks in advance
Post #649567
Posted Thursday, February 05, 2009 8:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 03, 2009 10:37 AM
Points: 271, Visits: 442

Did you try creating a Linked Server?

Post #650954
Posted Wednesday, December 23, 2009 12:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 23, 2009 12:00 PM
Points: 1, Visits: 9
I'm having a simular issue, it started today.

Up until now this worked fine:

INSERT INTO SDSMTI_STAGING_METRICS_TRANSACTIONS
select * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt *.csv)}DefaultDir=E:\Uploads','select * from [InvoiceFeed_20091221.csv]')

Now I get:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".
Post #838722
« Prev Topic | Next Topic »


Permissions Expand / Collapse