VB application for ORACLE DB

[foox]

I am new in VB and I want your help to develope a small application.

I want to connect to an ORACLE DB and then
execute a simple SELECT statement in a table.

If my statement is true (return data) then display a message in a pop up window.

regards
Chris

[preeti]

Hi,

This is simple, but what version of vb are you using? In vb5.0 you would use RDO, but in vb6.0 you could also use ADO. It would be up to you which way you choose.

Using RDO: http://msdn.microsoft.com/library/devprods/vs6/vbasic/rdo98/rdobjrdoconnection.htm

This is documentation of you will connect to your oracle database. The driver that you would use instead of SQL Server, would be "{Microsoft ODBC for Oracle}"

Using ADO:
http://msdn.microsoft.com/library/sdkdoc/dasdk/mdao95wu.htm

This is an example using ADO. It's almost the same thing as RDO with slight differences.

Hope this helps,

Preeti

Preeti