how to establish ODBC connection

Posted by aaravindhantj on 06-May-2014 06:55

sir

what are the steps to establish ODBC connection and if we only use different front end then only we have to establish ODBC or though we use progress itself we have to establish ODBC just explain.

thank u sir

OpenEdge RDBMS - Forum

All Replies

Posted by Youssif Shanshiry on 06-May-2014 18:27

1.  Install the SQL Client Access at the client machine which can be downloaded from progress download center.

2.  Start the database on the database server.

3.  Define a DSN on the client machine for the database.

4.  Use the ODBC client of your choice to connect to the database.

Posted by Stephanie Seney on 07-May-2014 08:23

Youssif,
 
I'm assuming that in order to use ODBC you have to have the progress dataserver lic, correct?  Or does having just Enterprise DB & 4GL lic - work - allowing ODBC connectivitiy?
 
Where in the download center is the SQL client access found?
 
What is a DSN?
 
Sorry for the "dumb" questions, but I'm not familiar with the terminology. 
 
Steph

[collapse] From: Youssif Shanshiry [mailto:bounce-yshanshi@community.progress.com]
Sent: Tuesday, May 06, 2014 7:28 PM
To: TU.OE.RDBMS@community.progress.com
Subject: RE: how to establish ODBC connection

Reply by Youssif Shanshiry

1.  Install the SQL Client Access at the client machine which can be downloaded from progress download center.

2.  Start the database on the database server.

3.  Define a DSN on the client machine for the database.

4.  Use the ODBC client of your choice to connect to the database.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by Paul Koufalis on 07-May-2014 08:34

You only need a DataServer product if you want a Progress 4GL program to access a non-Progress database in a somewhat transparent fashion.  Accessing the Progress database from a SQL client is supported natively via the SQL-92 compliant _sqlsrv2 server executable.

The "SQL Client Access" is right smack in the middle of the page on the download site.  You can't miss it - just poke around a bit.  It is NOT in the same place as your other licenses.

A DSN is an ODBC data source definition.  Control Panel - ODBC Administrator - system DSN - new.

Posted by Muhammad Akbar on 07-May-2014 08:41

If you would like to connect to OpenEdge Database using ODBC you need to install SQL Client Access license which is available in Progress Software Electronic Software Download (ESD, http://www.progress.com/esd) .  If you have a valid openedge license it is free for download from ESD.
 
The DataServer license is for when you would like to access 3rd party databases such as Oracle, MS SQL Server, Sybase and DB2 using ABL language.   
 
The DSN stands for Data Source Name.  You create it in different Platform.  For Windows, C:\windows\system32\odbcad32.exe (64-bit ODBC interface for 64-bit Windows or for Windows 32 bit for 32-bit ODBC interface).  For 32-bit ODBC interface on 64-bit Windows, he exe located in C:\windows\sysWow64\odbcad32.exe.
 
You can create system DSN or user DSN based on your business needs.  ODBC is setup using Database port and host name also using ODBC user.
 
HTH,
 
Muhammad Akbar
Progress Software
 
 
 
[collapse]
From: sseney [mailto:bounce-sseney@community.progress.com]
Sent: Wednesday, May 07, 2014 9:24 AM
To: TU.OE.RDBMS@community.progress.com
Subject: RE: how to establish ODBC connection
 
Reply by sseney
Youssif,
 
I'm assuming that in order to use ODBC you have to have the progress dataserver lic, correct?  Or does having just Enterprise DB & 4GL lic - work - allowing ODBC connectivitiy?
 
Where in the download center is the SQL client access found?
 
What is a DSN?
 
Sorry for the "dumb" questions, but I'm not familiar with the terminology. 
 
Steph
 
[collapse]
From: Youssif Shanshiry [mailto:bounce-yshanshi@community.progress.com]
Sent: Tuesday, May 06, 2014 7:28 PM
To: TU.OE.RDBMS@community.progress.com
Subject: RE: how to establish ODBC connection
Reply by Youssif Shanshiry

1.  Install the SQL Client Access at the client machine which can be downloaded from progress download center.

2.  Start the database on the database server.

3.  Define a DSN on the client machine for the database.

4.  Use the ODBC client of your choice to connect to the database.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse][/collapse]

Posted by Stephanie Seney on 07-May-2014 08:46

Paul,
 
Thanks for the answers.  This is great, as we do have a SQL system that we might want to build some "checks" against our progress DBs before they move forward with a process on that external system.
 
Steph

[collapse] From: Paul Koufalis [mailto:bounce-pkoufalis@community.progress.com]
Sent: Wednesday, May 07, 2014 9:35 AM
To: TU.OE.RDBMS@community.progress.com
Subject: RE: how to establish ODBC connection

Reply by Paul Koufalis

You only need a DataServer product if you want a Progress 4GL program to access a non-Progress database in a somewhat transparent fashion.  Accessing the Progress database from a SQL client is supported natively via the SQL-92 compliant _sqlsrv2 server executable.

The "SQL Client Access" is right smack in the middle of the page on the download site.  You can't miss it - just poke around a bit.  It is NOT in the same place as your other licenses.

A DSN is an ODBC data source definition.  Control Panel - ODBC Administrator - system DSN - new.

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

This thread is closed