Oracle and FrontPage 2003

[Nyghtchyld0577]

Here is my problem. I'm developing a webpage for work with FrontPage 2003 (it's what we have and told not to use anything else). I have created the pages and trying to get the page to send data to a Oracle DB. I have verified the names of everything. talked with our Oracle DBA's and they said eveything looks right in oracle to accept the data. When I publish the site everything is fine up until the point of actually submitting the information to the database. The page says everything went fine, but is unable to get a results page. When I went and queried the information on the DB it shows nothing is listed. I would be glad if anyone would be able to help me. I am also willing to send the page and information to the person that helps me. Thanks

[kazecoder]

While I am not too familiar with Oracle I do have an idea for you...

If you are using a html form for input try passing those values to a secondary page and display them before putting them into the database. That will tell you if the data is valid or not.

[Nyghtchyld0577]

I will work on that tomorrow once I have the webserver up at work and can try to post to the actual DB server if it does not work. Thanks for the help.

[Nyghtchyld0577]

Ok the information is going across correctly. But it is not populating. Any other ideas

[iamlost]

It has been a long time so the following may be out of date.

Saving the .asp file with the correct extension was critical - renaming it as html/htm used to give an empty data field without generating an error message.

Write your SQL on the DBMS you are using. Remember that Oracle and Microsoft use differing query language/grammar/puntuation that can be frustrating.

There was more but I only used Frontpage years ago for a short time and my memory is going. Try a search for Frontpage 2003 + Oracle + database or similar. As I recall I got little help fron the MS documentation/help back when. Good luck.