Connecting SQL Linked Server to Third Party Progress

[midrb]

I am in dire need of assistance. We have a third party vendor that has a progress database. We would like to use SQL Linked Server to connect to the database. I have setup a DSN and can link tables via Access2003. I now would like to use Linked Server to do the same thing. For my DSN I am using the Datadirect 4.10 32-Big Progress SQL92 V9.1E driver.

From the vendor I do have the userid, password, IP address and database name.

What are the parameters I need in order to setup the Linked Server?

Thanks

MIDRB

 

[BCM]

midrb -
1) From the Windows ODBC configuration manager can you perform a successful Test Connect to the Progress database? This is the first step towards linking the servers.

2) Use the Enterprise Manager to create the Linked Server.
General Tab
Server Type: Other Data Source
Provider Name: Microsoft OLE DB Provider for ODBC drivers
Product Name: MSDASQL
Data Source: <name of the ODBC DSN you created>

Security Tab
Click on 'Be made using this security context:'
Remote login: <the userid to the Progress database>
With password: <the password for this userid>


That is all you need.