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:
Post a Comment