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

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

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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply