Hello everyone, I've got an application usingo ADO to connect to an 8i
I used this connection method I used MS OleDb for Oracle
dim cnn as new ADODB.connection
.provider = "MSDAORA.1"
.connectionstring= username & "/" & passwd & "@" servicename
I servicename is the same service name (a kind like
"myservice.oracleservername") I used to build a service denomination (a kind
like "johndoe.ora81") into Oracle Client configuration.
The result was an error Ora-12514 "unable to find service name".
I tried to use as servicename the service denomination (johndoe) I built
into Oracle client but the result was the same.
Finally I installed ODBC Oracle driver and setted a user DNS to "myDNS" and
the using this it worked out:
myConnectionstring= "PROVIDER= MSDAORA.1; DNS=myDNS"
.open myConnectionstring, username, passwd
So here're my questions:
1)why first solution (on a book too is referenced as I made) did'nt worked?
2)OLEDB for oracle is dipendent from ODBC connection only? Can't I a way to
use directly OLEDB connected to Oracle Client without passing thru ODBC?
Thanks in advance, bye Giovanni.