none
Error code = 80004002 No such Interface Supported

    Question

  • Hello All,

    Iam  getting this  Error "No such Interface Supported"   when iam trying to access multiple clients remotely to SQL Server2008Ri.

    Error Message:

    Error code = 80004002 No such Interface Supported

    lpsStatement;provider=SQLNLI10;Server=Esxsql2008;Database=Sec;DataTypeCompatiabilty=80;MARS...SE_ON_COMMIT=OFF;

    * Iam able to connect one client and I can run the applliaction remotley.

    * Iam working  on VMware ESX Mahines.

    Any ideas on this problem ?

    • Changed type ArthurZMVP Thursday, January 03, 2013 7:32 PM revised to reflect the thread intedt
    • Moved by ArthurZMVP Thursday, January 03, 2013 7:32 PM Not related to SSIS (From:SQL Server Integration Services)
    Thursday, January 03, 2013 6:17 PM

Answers

  • lpsStatement;provider=SQLNLI10;Server=Esxsql2008;Database=Sec;DataTypeCompatiabilty=80;MARS...SE_ON_COMMIT=OFF;


    DataTypeCompatiabilty=80 OLE DB clients will connect using the SQL Server 2005 tabular data stream (TDS) version, rather than the TDS version. This means that for SQL Server 2008 and later data types, down-level conversion will be performed by the server, rather than by SQL Server Native Client. It also means that the features available on the connection will be limited to the SQL Server 2005 feature set. Attempts to use new datatypes or features are detected as early as possible on API calls and errors are returned to the calling application, rather than attempting to pass invalid requests to the server.

    Below is the reference article which might help.

    http://msdn.microsoft.com/en-us/library/ms131002.aspx


    -SQLHarry
    SQLHarry Blog

    Thursday, January 03, 2013 9:34 PM