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