You're a good looking blog, what's your owner's name?

Richard Jonas's blog about .NET, web development and agile methodologies.

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}

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home