System.data.odbc, instant client, and asp.net: which files do I need?
679703Jan 13 2009 — edited Jan 15 2009Hello, this is my first post on these forums, after searching all day for a solution.
I have an existing asp.net website, which uses System.data.odbc to connect to a remote oracle db. I do all of my development on the local asp development server, but using this remote db. Traditionally, on each computer that I've wanted to develop on, I've had to install the full Oracle Client. Then, I heard about the instant client. I've tried installing it, but still can't get things to work.
However, I found this post: http://www.thewayofcoding.com/2008/02/c-net-programming-tip-connecting-to-an-oracle-database/ which seemed to hold some promise for me, but brought up some questions.
Is there a way to package parts of the instantclient/odbc with my website, so I don't need to do any installation of any oracle client on the development computer? I'm going to try what is recommended on that blog post, but he doesn't mention anything about odbc, which is what I need... and I'm unsure of which files I would need to copy into my bin folder.
Thanks!