oledb connection string for 11g XE
900859Nov 17 2011 — edited Nov 17 2011I installed Oracle 11g XE and ODAC package and am trying to use C# OLEDB to create a database connection, however it does not work, i tried following connection strings, none of them worked:
(1) connectionString = "Provider=OraOLEDB.Oracle;Data Source=localhost:8080/apex/my_database_name;User ID=system;Password=xxxxx;"
(2) connectionString = "Provider=OraOLEDB.Oracle;Data Source=localhost:8080/apex/;User ID=system;Password=xxxxx;"
I can log into application express via http://127.0.0.1:8080/apex/f?p=4500:1000:7710556667646572 to create and modify tables without any problem.
Any ideas?
Thanks!