MYSQL to / from Progress

[Elliott B.]

We have been asigned a project required by our parent company to have
our sales people fill out a form before billing any order to our
customers.

Our main system runs a Progress db, that's where our billing, contract
and order information resides. For this, we thought that it would be
easy on the sales people to design a web form fill out all the
required information and send it to Progress db.

Our challenge has been that our web form will sit on a windows server
(win 2k3 server) and progress is on a SUN solaris server and we can't
find an ODBC from windows to solaris and viceversa for progress
without installing a full copy of the db to the windows server. The
ideal situation is to write directly to our progress db, easy hum?

For the lack of a odbc like that, we thought that we could have mysql
in between and be the medium between our web interface and progress db
but again we can't find odbc drivers or don't know how to have these 2
beasts talk between them. MySQL is running under RH. Has anybody
done something similar? Our other alternative is to ftp a text file
back and forth with all the updates but we would like to avoid that,
just a preference thing.

Thanks for the input.

Elliott

[steve]

"Elliott B." wrote:

We have been asigned a project required by our parent company to have our sales people fill out a form before billing any order to our
customers.

Our main system runs a Progress db, that’s where our billing,
contract
and order information resides. For this, we thought that it would be easy on the sales people to design a web form fill out all the
required information and send it to Progress db.

Our challenge has been that our web form will sit on a windows server (win 2k3 server) and progress is on a SUN solaris server and we
can’t
find an ODBC from windows to solaris and viceversa for progress
without installing a full copy of the db to the windows server. The ideal situation is to write directly to our progress db, easy hum?

For the lack of a odbc like that, we thought that we could have mysql in between and be the medium between our web interface and progress db but again we can’t find odbc drivers or don’t know how to
have these 2
beasts talk between them. MySQL is running under RH. Has anybody
done something similar? Our other alternative is to ftp a text file back and forth with all the updates but we would like to avoid that, just a preference thing.

Thanks for the input.

Elliott

Elliott, it is a tough problem you are trying to solve. May I suggest
that you cross post your request to the progress newsgroup as well.
Someone there may be able to help you. Personally I would avoid the
batch stuff with ftp. If nothing else works, from php you could open
a telnet or ftp sesison, per user page (not batch), and read/write
stuff in real time.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Progre...ict140446.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=472991