I have a vb 6.0 project which uses access as a database. but i need only oracle as database. Will anybody pls tell me how to change it to oracle database. Does it requires the Complete change in the code of the project or only a little changes. i am a begginer so pls help me.

>>Does it requires the Complete change in the code of the project or only a little changes
maybe yes, but it's not a big problem if you have working a lot with other DBMS..

see this thread :
One
Two
Three

see this site :
One
Two
Three
Four

Pdf Files

database changes
----------------

1. Migrate table/views and data to Oracle.

VB changes--assuming you are on ADO
-----------------------------------
1. Change connection string.
2. May need to take care of data types to make it compatible with Oracle.

you're welcome..
and don't forget to mark this thread as solved.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.