Connectivity b/w Oracle and Visual Basic

[javabeanx]

This is a real newbies question please help me
All the necessary forms have been created in VB
All the tables created in Oracle(using SQL)
I'm trying to establish connectivity using ADO but whatever I do it says maybe not properly installed Please Please help me
The reasons could possibly be
I have both Oracle 7 and Oracle 8i
If this is the reason what should i uninstall
If not uninstall Is there any way to set the system so that only only one of them(7/8i) works properly

 

[sem]

You may set ORACLE_HOME environment variable.

 

[bookouri]

This is they way my connection works i ASP pages, hope it helps:


dim myconnection
dim rsnamelist
dim sqlstring
dim requestName
set myconnection = nothing
set myconnection = server.createobject("ADODB.connection&quot
myconnection.open "Provider=MSDAORA;Data Source=Live;" &_
"User ID=myid;Password=mypass;"


sqlstring = "select your select statement"

set rsnamelist = myconnection.execute(sqlstring)

then do a do loop and stuff your records into an html table