how to connect oracle database with ADO Data control 6.0

[nasirVB]

I am trying to develop a database management system with oracle. But i dont know coding for the same. I have been using MS Access as database. But i want o switch the database to Oracle. Please help me out.

Nasir Ahmed

[tifoso]

You have to do some work ;-) search for the proper connect string and use that
to get onto your oracle DB, if u get issues post your code and help will come your way

[debasisdas]

The process is same .

Only thing is that u need to change the connection string.

To do this best way is

1.open notepad.
2.save the file with .UDL extension.
3.then open the file and just follow certain steps (which is so easy).
4. close the file.
5.right click and open with notepad.
6.copy after the first line

u get the connection string for oracle.

[Dököll]

Visual studio also helps in indenting your SQL via your local system. As metioned here, it's fairly easy to load Oracle in...

If nothing works for ya, set your eyes on these links:

http://www.aspfree.com/c/a/VB.NET/Displaying-an-Oracle-10G-XE-Table-with-Visual-Basic-6/3/

Microsoft example:

http://support.microsoft.com/kb/176936