471,092 Members | 1,561 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

MYSQL to / from Progress

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
Jul 20 '05 #1
1 2005
"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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Richard Gabriel | last post: by
reply views Thread by Philip Stoev | last post: by
1 post views Thread by Elliott B. | last post: by
29 posts views Thread by smorrey | last post: by
10 posts views Thread by Caffeneide | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.