We are looking to take a database dump of a really old database from a Progress DB system we have running at our office, however we've come up against a brick wall trying to connect to the system using an ODBC driver from OpenLink.
here's a rundown of the setup.
We have a SCO Unix system running a Progress 9.1D database server (circa 15 - 20 years old), it has the SQL listener / system enabled and running on the server. if we login to the system locally using Putty we can use the Unix app that was written for the db to connect to the DB and retrieve/process data etc.
I appreciate this doesn't help to resolve a problem with an ODBC network connection but I figured I'd mention it to clarify that we can access the DB and query data.
We are trying to connect to the server using 2 machines (Win7 PRO and win 8.1 PRO), using the OpenLink Single tier ODBC driver for Progress 9.1D (32bit).
All of my attempts to access the database from the PC so far have given the following errors --
SQL State : S1000
[OpenLink][ODBC]Unable to allocate server handle
SQL State : 08004
[OpenLink][ODBC][Driver]Connection rejected by data source
I am using the following parameters when trying to connect.
session options : -d mdy
database options : -N tcp -H <hostname> -db <db location> -S 3030
table view : <blank>
Any help or advice would be appreciated on this problem for us as its really making us scratch our heads.