I tried the single line connection code like this
cn.Open "Provider=MSDAORA.1;Data Source=Personal Oracle7;User Id=SCOTT;Password=TIGER;"
but am getting error message like this
"Runtime error - 2147467259(80004005)
ORA-12154-TNS:Could not resolve service name"
I am using Personal Oracle 7.3.4
I think the error is in Data Source string
Please help me
thanks