How to Dreamweaver CS4 connection to Oracle 10g Database..??

[kayode83]

Hey Good People,

OK. so am faced with a bit of a problem. I have created a website using DW CS4 and also a Database using Oracle 10g. i would like to have a form on the website allowing the information inserted via the webpage to be sent to the database. I tested the ODBC connection and the result was successful however, when I create the ASP page, and try to select table i want to use i do not see the tables i have created in the database. Instead i get along list of other tables, i have no idea where they came from..it looks like some kind of sample tables or something of the sort. i would really appreciate any assistance i can get. If i need to explain any aspect of this any further please feel free to let me know. I will be glad to do my best to explain whatever need to me clarified. Thanking you in advance for your time and assistance.

Regards

[bregent]

I don't use Oracle but based on my experience with other enterprise DBMS's there are several possibilities.

* The list of tables you see is from the default database which is not the database you created your user tables in.

* The list of table is for the table owner that you logged in with, and not the user that create the user tables.

[kayode83]

thanks for your response. I have a feeling it is a list of default tables but the strange thing is, when i log in to SQL Plus i see the tables i have created. Using these same credentials to set up the connection and in DW, i somehow get a different result. this is what baffles me. i have gone through the process many times and get the same result everytime.