VJ
|
| Posted: 11/18/2002, 4:28 PM |
|
Hi,
I need to convert my application from Access using ASP to Oracle database since
our servers do not support Access. Is there a procedure that needs to be followed?
I hope someone has already done this before and found the solution. Any help
will be greatly appreciated. Thanks.
VJ
|
|
|
 |
Tom
|
| Posted: 11/26/2002, 10:26 AM |
|
It is easy to port our Access DB to Oracle. Just use the export function from MS Access.
**** Make sure that you first upper case all of your table names and field names and eliminate any spaces or special characters and you haven't used any reserved words.
Oracle can handle mixed case but it is NOT its native mode and everyone will hate you if you do use mixed case. You have to put in a lot of "" if you use mixed case.
Then just create an ODBC driver to connect to your oracle database.
|
|
|
|
|
