Using SQL Server 2008 R2 to query Progress OpenEdge10.2

Status
Not open for further replies.
M

mark1234

Guest
We just acquired a company that has some apps running on Progress. We're a Microsoft shop and need to query the data from SQL Server (in the short term). We have the following ODBC drivers installed on SQL Server, but they don't show up when I try to add a link server, or as a provider under linked servers:

32-bit

kHhm4.png


64-bit

d2aAY.png


When I go to Linked Servers, I see this. I've never done anything with providers, so not sure if I need to add something.

CEIV9.jpg


The IT Guy there connects in VB.net using a connection string like this, but never got SQL to connect:

Driver={Progress OpenEdge 10.2B Driver};uid=USERNAME;host=HOSTNAME;db=DBNAME;port=2701;pwd=!PASSWORD


I tried using this as a connection string, but no luck.

Anyone know how to do this?

Thanks

Mark

Continue reading...
 
Status
Not open for further replies.
Top