M
Muhammad Akbar
Guest
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 3 rd 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 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 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 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 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.
Continue reading...
Continue reading...