DATabase connectivity of oracle 8i+ VB6

[Anon]

hi friends,
can someone please help me out with the database conneectivity using a DSn or without a DSN..for oracle 8i and VB form ..i need the ADO connectivity..
in past i have used Vb with access ..but i wud like to know what changes are needed to carry out this type of a dbase conn in my project...
anyhelp would be appreciated
thanx in advance
byee
neena

[Anon]

hi neena,
<%@ language="VBscript" %>
<%
conn="driver={drivername};server=212.636.636.9;UID=;PWD=;databse=;option=";

Set aconn=Server.CreateObject("ADODB.Connection")
aconn.Open conn

query="Select * From ...."

Set rs=aconn.Execute(query)

%>
neena,
I think this will work with any kind of DB I mean even remote database of different type like SQL,ORACLE,MySQL ..provide you specify the correct driver and this is a DSN less connection..

By the way if you are working on the same server and the DB server is already integrated with it then you need not mention all of them

just create a server object

conn=Server.CreateObject("ADODB.Connection");
conn.open(DSN=;UID=;PWD=)

I hope that will help you..if you are working on remote databases see that the DB Server has set the privelege to access from remote servers by default this permission is not given unless you ask for it..

Good Luck!.
[e-mail]
s.r.k.reddy