Connect Linux Progress database on Linus to SQL Server

Zach Ahmed

New Member
Hi All,
I was able to connect Progress database on Window 10 to SQL Server by downloading the Progress OpenEdge 12.2 Drive and creating the ODBC driver. My question is, how can I connect Progress database on Linux to SQL Server ?

Will Progress OpenEdge 12.2 Drive allow me to connect to Progress data on Linux as well ?

thanks
Zach
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
Progress OpenEdge 12.2 Drive
Are you referring to the OpenEdge SQL drivers? These allow you to connect to an OpenEdge database (assuming appropriate configuration) from a SQL client. There is a version of the OpenEdge SQL drivers (called "SQL Client Access" on the Progress download site) for each platform: Win32, Win64, Linux, etc.
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
I'm not sure yet exactly what you're trying to do, or where SQL Server fits in.

Where is the OpenEdge database that you want to connect to via SQL? (i.e. what is the OS)
What is the client application you want to use to connect to this database?
What OS does the client run on?
 

Zach Ahmed

New Member
Hi Rob,
I want to be able to manipulate data Progress database which is on Linux using SSMS (SQL Server Management Studio) which is on Window server. This is allow me to use SSIS packages. I have been able to do exactly that, however, the Progress database is on Window and not on Linux.

So the question: is there an ODBC driver that will allow me to connect the Progress database on Linux to SQL Server on Window ?

I will take a look at "SQL Client Access" on the Progress download site per your suggestion to download Linux driver for Progress database.

thanks
Zach
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
The driver is for the use of the client, not the server. The client accesses the DB via TCP so the DB's OS doesn't matter to the client. Just specify the name or IP address of the Linux host rather than the Windows host when you set up your client connection (e.g. via a DSN) and you will be able to connect to your Linux DB.
 
Top