Matt Russell
New Member
Hello,
We are using a Progress v9.1B database and 4GL app, developed by a third-party. My only experience with Progress is by using this app - I've been raised on SQL. Unfortunalty, the entire firm is made possible by this app, so I've got a bit of learning to do.
What we need to do is run a number of Crystal Reports over the underlying Progress database. How this is done at the moment is nothing short of ridiculous (Dump the contents of a table using a function of the app into TSV files, Format TSV files, load TSV files into MS Access, format tables, run Crystal via ODBC to Access), mainly because no-one knows Progress well enough to do it any different.
What makes sense is to be able to drill straight into the Progress database via ODBC with Crystal, and report off the live data. The big questions are :
1 - Can it be done?
2 - How?
I've so far downloaded and installed the Merant DataDirect SequeLink server for Progress (which, despite their assurances, doesn't support 9.1B), as well as the SequeLink server for ODBC Sockets, both to no avail. I'd rather NOT use these, since these are slightly overkill for what we need (as well as being very expensive).
I've since discovered the wonders of the Progress Client Networking, which I installed this morning, and now have an ODBC driver. This is great - it lets me create an ODBC link to the database, and all is well. I fire up Crystal, and open the ODBC link, I can see all the tables, and I can add fields from those tables into my report.
However, as soon as I try and browse the data (refresh the report, etc), I get ODBC Error -20217 (which I believe to be Access Denied, or similar??).
On the 2/9/01, Nick Williamson posted to this board regarding ODBC, v9.1, and a user called "sysprogress", which he believed to be a kind of SQL92 DBA account, to allow reading of the data. Do I need to add this user? If so, how? (Keeping in mind I have no idea what I'm doing...)
Any help would be muchly appreciated, I've been workig on this for a while, and feel that I'm quite close. The third party who have supplied the Progress DB and app have been, shall we say, less than helpfull in this regard.
Thankyou all for your time and patience!
-Matt Russell
IT Development
Shine Roche McGowan Solicitors
Queensland, Australia.
We are using a Progress v9.1B database and 4GL app, developed by a third-party. My only experience with Progress is by using this app - I've been raised on SQL. Unfortunalty, the entire firm is made possible by this app, so I've got a bit of learning to do.
What we need to do is run a number of Crystal Reports over the underlying Progress database. How this is done at the moment is nothing short of ridiculous (Dump the contents of a table using a function of the app into TSV files, Format TSV files, load TSV files into MS Access, format tables, run Crystal via ODBC to Access), mainly because no-one knows Progress well enough to do it any different.
What makes sense is to be able to drill straight into the Progress database via ODBC with Crystal, and report off the live data. The big questions are :
1 - Can it be done?
2 - How?
I've so far downloaded and installed the Merant DataDirect SequeLink server for Progress (which, despite their assurances, doesn't support 9.1B), as well as the SequeLink server for ODBC Sockets, both to no avail. I'd rather NOT use these, since these are slightly overkill for what we need (as well as being very expensive).
I've since discovered the wonders of the Progress Client Networking, which I installed this morning, and now have an ODBC driver. This is great - it lets me create an ODBC link to the database, and all is well. I fire up Crystal, and open the ODBC link, I can see all the tables, and I can add fields from those tables into my report.
However, as soon as I try and browse the data (refresh the report, etc), I get ODBC Error -20217 (which I believe to be Access Denied, or similar??).
On the 2/9/01, Nick Williamson posted to this board regarding ODBC, v9.1, and a user called "sysprogress", which he believed to be a kind of SQL92 DBA account, to allow reading of the data. Do I need to add this user? If so, how? (Keeping in mind I have no idea what I'm doing...)
Any help would be muchly appreciated, I've been workig on this for a while, and feel that I'm quite close. The third party who have supplied the Progress DB and app have been, shall we say, less than helpfull in this regard.
Thankyou all for your time and patience!
-Matt Russell
IT Development
Shine Roche McGowan Solicitors
Queensland, Australia.