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


Add to briefcase

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)". Expand / Collapse
Author
Message
Posted Tuesday, September 27, 2011 12:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 4:25 AM
Points: 143, Visits: 653
hello all.
I use this script for export query result to existing dbf file :
insert into openrowset ('MSDASQL','Driver=Microsoft Visual FoxPro Driver; SourceType=DBF; SourceDB=c:\Temp','select * from dskwor00')
select * from test

but get error:
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 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".
I use windows server 2008 and sql server 2008.what Do I do for solve this error?
Post #1181516
Posted Tuesday, September 27, 2011 1:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 8, 2012 4:17 AM
Points: 26, Visits: 53
firstly ,make sure you have the full control permission of this folder
Post #1181519
Posted Friday, May 11, 2012 5:10 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 8, 2014 3:25 AM
Points: 2,283, Visits: 781
elham_azizi_62 (9/27/2011)
hello all.
I use this script for export query result to existing dbf file :
insert into openrowset ('MSDASQL','Driver=Microsoft Visual FoxPro Driver; SourceType=DBF; SourceDB=c:\Temp','select * from dskwor00')
select * from test

but get error:
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 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".
I use windows server 2008 and sql server 2008.what Do I do for solve this error?



have a look at this link - basically the drivers are not pre-installed on 64 bit windows

http://blogs.msdn.com/b/sqlforum/archive/2010/12/20/faq-why-cannot-64-bit-msdasql-access-a-csv-text-file.aspx


MVDBA
Post #1298461
Posted Wednesday, August 20, 2014 12:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 12:19 PM
Points: 86, Visits: 220
may be this link would helpful for you


http://stackoverflow.com/questions/16986756/cannot-initialize-the-data-source-object-of-ole-db-provider-microsoft-ace-oledb
Post #1605293
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse