urgent - connecting to oracle db using vba
Posted on 2005-03-24
I am doing excel macro programming and I want to connect to oracle database using vba, I am easily able to connect to the access db but im not able to connect to the oracle db, its giving me runtime error with my below given code.
what are the things that i need to connect to the oracle db?
what reference should i give?
where will i find the datasource name?
could anyone please help......thanks
Dim strConn As String
Dim cn As New ADODB.Connection
Set cn = New ADODB.Connection
Set rsOra = New ADODB.Recordset
strConn = "Provider=MSDAORA.1;DataSource=?????;UserID=a_test;Password=t2004;Persist "
Security = False
cn.ConnectionString = strConn