So Dev

Accessing Oracle database with Microsoft Data Access Application Block

(Haven't been updating my blog for so long!!!)

After being fustrated for more than 6 hours yesterday, I finally figured out how to access Oracle database under .Net Framework 1.1 using Microsoft Application. Here's some tidbits:

- After you created a new App.config file using Enterprise Library Configuration, save it at the root directory of your Visual Studio .Net project, and MAKE SURE you add the App.config in your project. That way the VS.Net will automatically generate a proper .config file in your bin folder based on your App.config. I got stuck at this exact spot for more than several hours.

- Use the following command as the post-build event command line:
copy "$(ProjectDir)*.config" "$(TargetDir)"

- For the connectionstring setting, simply mimic the fields in the plain old ADO.Net conenction string for Oracle.

posted by Deecay @ 1:10 PM