ODBC Connection to AdaSage

ODBC Connection to AdaSage

[jhb]

To anyone who can help me out -

I am a software program manager for a medium sized Department of the Army
development effort. I need to interface to a system that runs an AdaSage
back end. My problem is that I am going to produce a data export to a floppy
disk, then have to merge the data into the receiving system. This system
does not have an interface utility to allow it to read and process my file.
I will need to manipulate the AdaSage database tables directly.

My plan is to develop a self contained executable file that will be copied
to the host machine from the export disk that comes from my system. This
exectuable will directly access and manipulate the AdaSage tables and fields
that it needs on the host machine, then clean up after itself and turn off.

What I am wondering is if there is some existing utility that will do this
for me or is there some programming API that will allow me to custom code
such an application ?

Please help if you can, I am running out of time and ideas.

Feel free to send responses directly to my email: jhb@stanleyassoc.com

Thanks in advance for your help.

Jim Brabston

Re: ODBC Connection to AdaSage

[Bryan Shayne]

Why not write a small interface in AdaSage to export or do what ever you want
from the database?  BTW, the Corps of Engineers (Waterways Experiment Station)
used to be big users of adasage.

jhb wrote:

> To anyone who can help me out -
>
> I am a software program manager for a medium sized Department of the Army
> development effort. I need to interface to a system that runs an AdaSage
> back end. My problem is that I am going to produce a data export to a floppy
> disk, then have to merge the data into the receiving system. This system
> does not have an interface utility to allow it to read and process my file.
> I will need to manipulate the AdaSage database tables directly.
>
> My plan is to develop a self contained executable file that will be copied
> to the host machine from the export disk that comes from my system. This
> exectuable will directly access and manipulate the AdaSage tables and fields
> that it needs on the host machine, then clean up after itself and turn off.
>
> What I am wondering is if there is some existing utility that will do this
> for me or is there some programming API that will allow me to custom code
> such an application ?
>
> Please help if you can, I am running out of time and ideas.
>
> Feel free to send responses directly to my email: jhb@stanleyassoc.com
>
> Thanks in advance for your help.
>
> Jim Brabston