none
Linked Server in different version of ODBC driver

    Question

  • I have a ODBC 2.0 driver for a proprietary database. When I changed the driver to 3.0, I receive -

    Msg 7355, Level 16, State 1, Line 1

    The OLE DB provider "MSDASQL" for linked server "DG" supplied inconsistent metadata for a column. The name was changed at execution time.

    DG4ODBC from Oracle works fine with the driver so is the ODBC tool that Microsoft provides.

    Tuesday, July 29, 2014 2:43 PM

All replies

  • Yes, there should be compatible version for connecting ODBC version.

    Just verify the ODBC version is up to date. if not you have download and register on server machine.


    This posting is provided "AS IS" with no warranties and confers no rights! Always test ANY suggestion in a test environment before implementing! http://sesaitech.blogspot.in/

    Tuesday, July 29, 2014 2:46 PM
  • Hi,

    • Odbc32.dll - ODBC Driver Manager
    • Odbc32gt.dll - ODBC Driver Generic Thunking
    • Odbcad32.exe - ODBC Administrator
    • Odbcconf.dll - ODBC Driver Configuration Program
    • Odbcconf.exe - ODBC Driver Configuration Program
    • Odbcconf.rsp - ODBC Driver Configuration File
    • Odbccp32.cpl - ODBC Control Panel
    • Odbccp32.dll - ODBC Installer
    • Odbccr32.dll - ODBC Cursor Library
    • Odbccu32.dll - ODBC Cursor Library
    • Odbcint.dll - ODBC Resources

    the above libraries are supporting...

    Please go through this link "http://support.microsoft.com/kb/313008/en-us"


    This posting is provided "AS IS" with no warranties and confers no rights! Always test ANY suggestion in a test environment before implementing! http://sesaitech.blogspot.in/

    Tuesday, July 29, 2014 2:48 PM