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

  • 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