I connect to a progress database (10.1c version)
We installed the odbc driver and connect to Progress via SSIS to import data into SQL
this is how I use it in SQL 2005
in a ssis package connection manager pane > right click> new connection
in "Add SSIS Connection manager" window select type "ODBC"
in "Configure ODBC connection Manager" > select New
in "Connection Manager" select your installed ODBC driver enter the login/pwd info >test connection
Alternatively in the "connection manager" window you can "use connection string"
this will be something like this
Dsn="WhatyoucalledtheDSN"={Progress OpenEdge 10.1C Driver};uid=administrator;host="yourservername";db="yourprogressdbname";port="yourProgressportnumber"
hopefully this may help you
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day