Hi,
I am VB Programmer and this is procedure I use with Oracle connection

cn.Open "Provider=MSDAORA.1;User ID=xx;Password=xx;Data Source=xx"
cn.Close
If cn.State = 1 Then cn.Close
cn.Open "Provider=MSDASQL.1;DSN=GoldSmith;Password=xx"

But it takes atleast 5 to 10 seconds to open a connection.Please help to
spped up my connection

Thanks