Tuesday, October 11

Connecting to oracle database

I was trying to connect to an Oracle 8i database using Ole DB from Visual Studio .net

I could read the system tables, but I could not see the user tables to select from them. The connection string was Provider=OraOLEDB.Oracle.1;Password={password};Persist Security Info=True;User ID={user};Data Source={datasource}

I eventually fixed this by changing the Connection String to specify Provider=MSDAORA;Password={password};Persist Security Info=True;User ID={user};Data Source={datasource}

No comments: