How to connect to Oracle DB using VBScript & ADO?? 1

[qajussi]

Hi!

Can you help me?

How to connect to Oracle DB using VBScript & ADO??
I have oracle 9i database and connect to the database and do some record extraction using the vbs/ado.

Can you show me some sample code?

Thank you millions in advance.

Philip

 

[Turkbear]

Hi,
Here is one way, using a DSN-less method:

<%
' Create and establish data connection
Set objDC = Server.CreateObject("ADODB.Connection")
objDC.ConnectionTimeout = 15
objDC.CommandTimeout = 30
'Code to connect to Oracle 
 objDC.Open "Provider=MSDAORA.1;Password=secret;User ID=usr;Data Source=yourtnsnames.ora entry;Persist Security Info=TRUE"
%>

Hope it helps..

 

[qajussi]

Thank you very much.
I see how you did it.

That works..