OLE DB connection error
417788Apr 2 2004 — edited Apr 14 2004I am having a problem connecting to my Oracle
database via OLE DB. The error reported is
"Multiple-step OLE DB generated errors...."
and it gives me ZERO help to diagnose the problem.
The VB code is as follows (xxx.xxx... = IP address):
adoCn.ConnectionString = "Provider=MSDAORA" _
& ";Data Source=xxx.xxx.xxx.xxx" _
& ";Initial Catalog=PSYTEST" _
& ";User ID=SYSTEM" _
& ";Password=Ciao"
adoCn.Open
Any help will be appreciated, Tony.