Home Forums SQL Server 2005 SQL Server 2005 General Discussion Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)". RE: 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)".