Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

• elham_azizi_62

  SSCertifiable

  Points: 5095

  More actions

  September 27, 2011 at 12:42 am

  #390480

  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?

• yubo1

  SSChasing Mays

  Points: 612

  More actions

  September 27, 2011 at 1:03 am

  #1386948

  firstly ,make sure you have the full control permission of this folder

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  May 11, 2012 at 5:10 am

  #1486197

  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

• prabhu.st

  SSCrazy

  Points: 2583

  More actions

  August 20, 2014 at 12:23 am

  #1739470

  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