none
Connect SQL Server to an external Progress database via ODBC/Linked Server

    Question

  • Hi,

    What driver do I need to connect SQL via a linked server to a Progress database?  This is so we can export data from an application called CCure which monitors building access.

    I downloaded the DataDirect driver pack from datadirect.com but none of them work as the SQL ODBC connection wants a numerical port number but the Progress database uses (from what I can see) a port number of CFSRV.

    I have seen online that some people use an old Merant driver but when googling for that I always get pointed to DataDirect which looks like it has superseeded Merant now?

    Any ideas? Thanks.

    Monday, July 01, 2013 3:51 PM

Answers

  • Hi MJ2012,

    To check whether we can create linked server to your Progress database, please check the valid providers on the following link. If the database is not supported, we will need to read data from that database, insert data into SQL Server by writing code manually. Additionally, please provide your database provider name here for analysis.

    sp_addlinkedserver (Transact-SQL)
    http://msdn.microsoft.com/en-us/library/ms190479.aspx

    Allen Li
    TechNet Community Support

    Wednesday, July 03, 2013 6:41 AM
    Moderator