Member Avatar for arul jeba

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.

  • 3 Contributors
  • 4 Replies
  • 137 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for Jx_Man

>>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

Edited by Jx_Man because: n/a
Member Avatar for debasisdas

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.

Member Avatar for Jx_Man

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.