Hi,
I've recently installed Oracle 8i (8.1.7) and have been trying to connect with VFP 6 via the Oracle OLEDB Provider. Unfortunately there's been some problems that hopefully someone can help with.
My Oracle install is running fine and I can connect via ODBC with all of the default userids/passwords, but for some reason when I try to connect via OLEDB, I keep getting the following error:
"OLE IDispatch exception code 0 from OraOLEDB: ORA-01017:invalid username/password; logon denied"
my code is as follows:
oOraConn = CREATEOBJECT("ADODB.Connection")
oOraConn.ConnectionString = "Provider=OraOLEDB.Oracle; Data Source=lt01db.wulfsden.com; userid=system; password=manager;"
oOraConn.Open
Again, I have not had problems connecting via ODBC or with the SQL Plus for that matter. I'm just trying to experiment with ADO a bit...
Is there any extra configuration that must be done to allow OLEDB connections?
Thanks,
- Brian
VFP6 SP5, VFP8 SP1, VFP 9 SP 1 and Win XP SP 3 (unless otherwise specified)
www.wulfsden.com