none
ODBC Connection Error RRS feed

  • Question

  • When I try and add a datasource to a Visual Basic App in VS2008 I get this error message:
    an error occurred while retrieving the information from the database: selecting objects of type 'Procedure' is not supported

    The database is a Progress 9.1C database using a Merant 3.70 driver which works fine with MySQL apps written in php programs.

    When I add the connection I scan see the data source names and able to get a successful test connection.

    Any advice, I'd really like to enter the .NET world !
    Sunday, April 5, 2009 2:08 PM

All replies

  • Hi Richard,

    I would suggest you enable tracing in the ODBC Administrator such that a ODBC trace of the calls being made by the Microsoft .Net Framework Provider for ODBC can be seen, as the failure is most probably due to a feature/metadata required by the Provider that is not supported in the ODBC Driver.

    Note that we at OpenLink Software also have ODBC Drivers available from Progress 9.1C you might want to try and are available for an evaluation download from:

    http://download.openlinksw.com

    With details on installation and configration available from:

    http://wikis.openlinksw.com/dataspace/owiki/wiki/UdaWikiWeb/InstallProgress92LiteWin32
    or
    http://wikis.openlinksw.com/dataspace/owiki/wiki/UdaWikiWeb/InstallProgress89LiteWin32

    Depending on which of the two available driver types we have you download.

    Note we also have an ADO.Net 3.5 Entity Framework Provider for our Virtuoso Universal Server product, which can act as a Virtual database engine for remote hetrogenous data sources including Progress and thus can  provide a solution you may want to consider also. Details on usage can be obtained from:

    http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtAdoNet35Provider
    http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtProgressEntityFrameworkUsage

    I hope this information helps, the first being to determine the cause of the failure with the current ODBC driver you are attempting to use ...

    Best Regards
    Hugh Williams
    Professional Services
    OpenLink Software
    Web: http://www.openlinksw.com
    Support: http://support.openlinksw.com
    Forums: http://boards.openlinksw.com/support
    Sunday, April 5, 2009 3:26 PM