|
|
|
Forum 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
|
|
|
|
|
SSC 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?
|
|
|
|
|
Forum 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)".
|
|
|
|
