Hi to all,
My application is using oracle 11 g as database in an asp dot net project . this was basically a project in asp dot net with sql server as a database . but now this need oracle 11 g as database . I have complete the db work, but i m getting the connection problem in visual studio (2008) with oracle 11 g .
I know for this it need a driver oracle.data.access ,, i do nt know which version it need ?
I have this dll . but version of it may be earlier. thats why it is not working properly
i have 11 g installed on the server computer , and we can only use it only on browser , I have a global.asax as a file in my dot net project in which connection string is written but i m getting error , something like ora10cc .
first i do not know , which odac version i have to download i have a link for this ,
but which version exactly , this page is so confusing, for oracle 11 g, and visual studio 2008 which version will be perfect
and then where the dll will be there. after getting the setup, Is i need to install that setup?
one more confusion , where i have to install that odac , on my computer system . or on the server side system , I just need that dll file ,,
One more thing , Is there any error in my connection string ,,
my connection is as follows
"Persist Security Info=False; User ID= system; Initial Catalog=LabTrack;Server=Comp-34;Data Source=192.168.1.61\oracle11g;Password=abcd1234; DBA Privilege=normal;"
192.168.1.61 is ip addres of system, where my oracle 11 g is install ,
and comp-32 is my user name
labtrack is my db name
Is there any need of provider name ?
sumbody pls help me
i m getting problem in at from 3 days
If u can then contact me , on email@example.com , otherwise reply me here
thanks in advance
regards Nimish Goel
The file at the top of that link should work fine with Oracle 11g.
I would start trying to get the client to work outside of Visual Studio, first. That way you can localize your issues.
Once you get the Oracle client connected to the Oracle server, then uou can start working on Visual Studio.
As for where to install it, I'd say start with your computer. I'm not sure how you do your development, but that would probably be a good place to start.
You may want a different download for the web server as I assume you wouldn't need the special Visual Studio tools on it. But yes, it will need whichever Oracle provider you choose installed on it as well.
On the download page you link to, click one of the links. The next page will contain the actual downloads plus download/install instructions for each version. You can click on one of these install instruction links and see the system requirements of that version. The system requirements will tell you want versions of Oracle and Visual Studio it works with.