Sea Unregue

C

chanjayamin

New Member
PHP to retrive data from Progress 9.1c (runtime license)

For one of my project I need some help accessing data from Progress 9.1c database (runtime license) using PHP and export it to a flat text file (Windows XP). Application manipulates data in the progress 9.1c (runtime license) database and I need to access these data by some way.
Does anyone know any solution to this problem? Is it possible to retrive data from a Progress database (runtime lincese) without connecting to the database?
Thank you in advance for your time and help.
 
No it is not possible to extract data from te database without connecting it :-)

You can however use sql to extract data from the database and then deal with it in PHP which ever way you like. (including making a flat file).

I think it is more then important to upgrade your Progress version. 9.1C is beyond old.

Regards,

Casper
 
I can only second Casper in stating that Progress 9.1c is 10+ years old software which is unsupported and - from my experience especially when it comes to SQL92 access - buggy. Bottom line: You don't want to do this with Progress 9.1c.

The only way to connect a non-Progress client to a Progress database is via ODBC/JDBC. For that the Progress client runtime products contain the ODBC/JDBC drivers you can use. There are other one from other vendors with which I don't have any experience - so YMMV.

To make this happen, as the Progress database is not an SQL database in the first place, you need to set up the database to accept SQL92 client connections and you need to make use of SQL security in the Progress database.

At this point I am not into the gory details of it all.

Heavy Regards, RealHeavyDude.
 
Re: PHP to retrive data from Progress 9.1c (runtime license)

chanjayamin said:
Does anyone know any solution to this problem? Is it possible to retrive data from a Progress database (runtime lincese) without connecting to the database?
Click to expand...

There really isn't any database run-time product available so you probably have some sort of RDBMS server license (enterprise or workgroup) and some Progress based application that connects to that database which is using the client run-time or client networking if the application is client-server.

As others have said you have the option to connect using ODBC and you have to do a bit of setup upfront, like setting the database to start an additional SQL broker beside the regular 4GL one and you need to define the SQL security in order to be able to connect to the database. You need to add users using Progress Data Administration, to get some access you need to activate the 'sysprogress' user which can be used to grant privileges to other SQL users you define (is the only one with DBA privileges so you need to start with it).

I do think that version 9.1C still supports only SQL89 and the first version that was worth trying to use with ODBC/JDBC was 9.1D, if you have simple SQL queries like `select * from table` then you can get along with it... however the (in)famous SQL-WIDTH property might bite you and you might need to update that if you have character fields that exceeds the value set for this property.

If this is only one time action then you better get the dba to dump you the tables you need in flat files and do with them what you please, if this is not the case then I think you might use the PHP adapter of ganimede (http://sourceforge.net/projects/ganimede)... the only issue there is that the project comes with source-code and you need the development license to compile it, I think I still have an xcode version somewhere so if you are interested I can look it up on my old disks.

Marian
 
I do think that version 9.1C still supports only SQL89 and the first version that was worth trying to use with ODBC/JDBC was 9.1D
Click to expand...

SQL92 was there with 9.0a - but Progress almost completely overhauled the SQL92 engine somewhere between 9.1c and 9.1d releases. But that overhaul took place under the covers so that users should only notice better performance and stability. As far as I can tell the job they've done was good in the V9 release's respect - but still is far from what OpenEdge has to offer.


Heavy Regards, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top