Post reply

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

  • June 28, 2008 at 1:20 am

    #381434

    hi Friends

    i m getting following error msg on my production server

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

    while creating sp which contain

    code

    select productid,productkeyword,brand,Manufacturer,manfid,upc,price,saleprice,variablecommission,@advid,@commission from OpenRowset('MSDASQL',

    'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\perfeed','select * from catalog.txt')

    this sp is executing properly on my local machine

    my production server have jet driver 4.0 and i m using sql2005

    i m login remotely to my server

    and i ready run

    sp_configure 'Ad Hoc Distributed Queries', 1

    reconfigure

    still getting this problem

    any solution

  • July 25, 2008 at 5:34 am

    #848312

    Note that "C:\perfeed" refers to a folder located on the C: drive at the server.

    Does that folder exist at the server? Does the file exist in that folder? Does the SQL Server service account have appropriate permissions in that folder? How are you connecting to the server (i.e. which authentication mode are you using)?

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com

  • June 11, 2011 at 10:28 pm

    #1337435

    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)".

  • June 11, 2011 at 10:31 pm

    #1337436

    hi dear friends,

    please provide me the solution while i'm trying to select openrowset

    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)".

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

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