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.
How to get data from progress database using ODBC stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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]
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]
RANGA RAO
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: