How to get data from progress database using ODBC stage

rangas999 · Post by **rangas999** » Mon Apr 18, 2011 8:23 am

Dear All,

I need to get data from PROGRESS DATABASE ,also known as OPEN EDGE

database.

I am using ODBC stage in datastage 7.5.1 version

But problem is how to add DSN in system control panel..

which DRIVER we have to select from following, for progress database..

controlpanel--->adminstartive tools--->datasourceodbs-->systemDSN-->ADD--?

plz suggest steps. how to get data from PROGRESS using ODBC stage.

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 18, 2011 3:10 pm

You claim to have an ODBC driver for Progress. Use (Add) that. If you haven't got one, get one.

rangas999 · Post by **rangas999** » Tue Apr 19, 2011 12:20 am

Hi ray,

Thanks for your replay

can't we get data directly by giving

DatabaseName
LogonID
Password

in ODBC stage .by giving the column name in column filed of ODBC stage

in 7.5.1

without adding DSN in sytem control panel..

and i was given above credentials and tried to get data by givening col

name in filed,

But job got aborted ..it throwing following error

main_program: [DataDirect][ODBC lib] Function sequence error
main_program: Could not check all operators because of previous error(s)

JOB design

ODBC STAGE-------->DATASET [7.5.1]

chulett · Post by **chulett** » Tue Apr 19, 2011 12:47 am

Have you or have you not purchased ODBC drivers for Progress? If not, you'll need to do so to proceed. You being your company, of course.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 19, 2011 1:01 am

You must have a DSN. Not a User DSN.

Therefore you must have an ODBC driver.