locked
[ODBC Driver Manager] Driver does not support this function RRS feed

  • Question

  • HI every body

    In Win Server 2008 R2 , I tried to retrieve data from my ODBC Driver  by Report Builder , my connection test is successful , but after any retrieve data by SQL Statement I encounter with this Error :

    IM0001: [Microsoft] [ODBC Driver Manager] Driver does not support this function

    I use Win Server 2008 R2 , and my ODBC Driver installed on :

    %SystemRoot%\SysWOW64\odbcad32.exe

    Can anyone help me to solve this problem, its realy urgent for me ,

    PLEASE HELP ………………..

    Monday, September 8, 2014 8:31 AM

Answers

  • ODBC Driver name is PMSDK (32 bit) and installed by Primavera software

    I use SQL Report Builder to connect the driver and try SQL Statement in it


    Report Builder may be executing an ODBC function to retrieve meta data, and that function is not supported by the PMSDK driver.  Are you using the latest version of the PMSDK driver?  You might try turning on ODBC tracing to find out the problem function. 


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    • Proposed as answer by Elvis Long Wednesday, September 17, 2014 9:45 AM
    • Marked as answer by Elvis Long Thursday, September 18, 2014 2:55 AM
    Monday, September 8, 2014 11:59 AM

All replies

  • Can you post your  SQL query ? maybe you are using some strange symbols.. or a different SQL expression than the standard... 

    Best regards..

    Monday, September 8, 2014 8:36 AM
  • hi Cristian Please Help

    my SQL query is so simple " SELECT * FROM TASK "

    I think it's maybe because of mismatch between 32 bit ODBC Driver and 64 Bit OS  or WADC


    Monday, September 8, 2014 8:58 AM
  • What software do you want to connect with that odbc driver? 

    Driver name? and version?

    Are you using code? i mean.. do you throw the sql query by code? or in any sql manager?


    Monday, September 8, 2014 10:45 AM
  • ODBC Driver name is PMSDK (32 bit) and installed by Primavera software

    I use SQL Report Builder to connect the driver and try SQL Statement in it


    Monday, September 8, 2014 11:00 AM
  • in this post I saw that there is problem between SysWOW64\odbcad32.exe and Win2008 R2

    http://social.technet.microsoft.com/Forums/windowsserver/en-US/0482482a-b6fc-4e75-ac5d-562c24f7b254/odbc-issue-on-win-2008-r2?forum=windowsserver2008r2general

    is that true ? and is there any hotfix or patch or any solution ??

    Monday, September 8, 2014 11:09 AM
  • ODBC Driver name is PMSDK (32 bit) and installed by Primavera software

    I use SQL Report Builder to connect the driver and try SQL Statement in it


    Report Builder may be executing an ODBC function to retrieve meta data, and that function is not supported by the PMSDK driver.  Are you using the latest version of the PMSDK driver?  You might try turning on ODBC tracing to find out the problem function. 


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    • Proposed as answer by Elvis Long Wednesday, September 17, 2014 9:45 AM
    • Marked as answer by Elvis Long Thursday, September 18, 2014 2:55 AM
    Monday, September 8, 2014 11:59 AM