ooRexx & Access
Three Lefts
front-end applications for Access databases?
I found several links to Rexx/SQL tools:
http://rexxsql.sourceforge.net/
http://sourceforge.net/projects/rexxsql/
http://www.mikusa.com/rexx-mysql/
http://sourceforge.net/projects/rexx-mysql/
It also looks like Mark Hessling has done some work in this area:
http://www.slac.stanford.edu/cgi-wrap/getdoc/rexx94-009.pdf
Can someone suggest what I should do to get started? The sourceforge
download page
http://sourceforge.net/project/showfiles.php?group_id=30840&package_id=22881
has about 10-12 options:
RexxSQL-2.5.tar.gz
rxsql25_db2_w32.zip
rxsql25_lite_os2.zip
rxsql25_lite_w32.zip
rxsql25_my_os2.zip
rxsql25_my_w32.zip
rxsql25_odbc_w32.zip
rxsql25_ora_w32.zip
rxsql25_saw_w32.zip
rxsql25_src.zip
I am guessing I want one of the "W32" file:
rxsql25_db2_w32.zip
rxsql25_lite_w32.zip
rxsql25_my_w32.zip
rxsql25_odbc_w32.zip
rxsql25_ora_w32.zip
rxsql25_saw_w32.zip
But which one?
Is there anything else I should be looking at?
Mark Miesfeld
> I have Windows XP, Office 2007, and ooRexx. Can I use ooRexx to write
> front-end applications for Access databases?
>
> I found several links to Rexx/SQL tools:
With ooRexx another options is to use the OLEObject that comes with
ooRexx. There are sample programs with ooRexx showing how to use
OLEObject in general and a sample program that shows how to use
OLEObject with Access.
On the SourceForge project for ooRexx in one of the support requests
there is also some example code of how to interact with Access using
OLEObject. That is at:
https://sourceforge.net/tracker/index.php?func=detail&aid=1729683&group_id=119701&atid=684731
Or you can just go to SourceForge, to the ooRexx project -> Tracker ->
Support Requests -> #1729683
I haven't done a whole using Access through OLEObject and have never
really used RexxSQL. So, I don't know which is the better approach.
But, it looks like Access has a very good OLE / COM interface. You
should be able to do anything you want in Access using ooRexx and
OLEObject.
--
Mark Miesfeld
Robert AH Prins
news:fm2ad45sbu7copbra...@4ax.com...
>I have Windows XP, Office 2007, and ooRexx. Can I use ooRexx to write
> front-end applications for Access databases?
>
> I found several links to Rexx/SQL tools:
>
> http://rexxsql.sourceforge.net/
> http://sourceforge.net/projects/rexxsql/
> http://www.mikusa.com/rexx-mysql/
> http://sourceforge.net/projects/rexx-mysql/
>
> It also looks like Mark Hessling has done some work in this area:
>
> http://www.slac.stanford.edu/cgi-wrap/getdoc/rexx94-009.pdf
>
> Can someone suggest what I should do to get started? The sourceforge
> download page
>
>
> http://sourceforge.net/project/showfiles.php?group_id=30840&package_id=22881
>
> has about 10-12 options:
<snip>
>
> Is there anything else I should be looking at?
Click on the 'notes' link, and you'll see this
Files in this release:
----------------------
RexxSQL-2.5.tar.gz - source
rxsql25_src.zip - source
rxsql25_db2_w32.zip - Native DB2 Windows binaries
rxsql25_lite_w32.zip - Native SQLite3 Windows binaries
rxsql25_my_w32.zip - Native MySQL 5.x Windows binaries
rxsql25_odbc_w32.zip - ODBC (SQL Server, Access, etc) Windows binaries
rxsql25_ora_w32.zip - Native Oracle WIndows binaries
rxsql25_saw_w32.zip - Native SQLAnywhere (ASA) Windows binaries
rxsql25_lite_os2.zip - Native SQLite3 OS/2 binaries
rxsql25_my_os2.zip - Native MySQL OS/2 binaries
--
Robert AH Prins
robert dot ah dot prins on gmail
Michael Lueck
> I am guessing I want one of the "W32" file:
>
This one, then set up an ODBC connection to the access database.
Also, their is a wrapper class library for RexxSQL called ORexxSQL. I have used that several times. If you get going in this direction (specifically ORexxSQL) I can provide you with two updated class
files. One fix I learned of via the RexxSQL bug report system at sf.net, and the other one was a problem I encountered.
Once I figured out the proper methods to be able to do repeated SQL calls without having to end the Rexx program I was developing, then this class library became very productive to work with.
As mentioned, there is another way to get to Access totally separate from using RexxSQL. I have not tried that.
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/