Last post Jun 20, 2011 07:48 AM by GoofyGiraffe
May 31, 2011 05:12 PM|GoofyGiraffe|LINK
I am trying to connect to Oracle 11g DB server via an SqlDataSource control.
I hit New Connection>Change > Change Data Source and then select Oracle Database.
Upon doing that I get the following Description on the right hand side:
"Use this selection to connect to Oracle 7.3, 8i or 9i using the .NET Framework Data Provider for Oracle."
What do I do to connect to an Oracle 11g ?
I tried using the 'Oracle (OLE DB)' while entering the TNS Service Name in the 'Server Name' box, but got the "ORA-06413:Connection Not Open" error message.
Also tried using the 'Oracle Database(OracleClient)' , but enetering the TNS Service Name in the 'Server Name' box got me the following error message :
"ORA-12154: TNS:could not resolve the connect identifier specified".
Maybe this is to do with the lack of support for Oracle 11g on my Visual Studio 2008 or maybe it is something else.
Anyone knows how do you get the Visual Studio 2008 to support Oracle 11g and Oracle 10g ?
My Visual Studio 2008 is a 32bit installation on a 64bit Windows 7.
My Visual Studio 2008 version numbers are :
Microsoft Visual Studio 2008
Version 9.0.21022.8 RTM
Microsoft .NET Framework
Version 3.5 SP1
Installed Edition: Professional
Microsoft Visual Basic 2008 91605-270-9658527-60105
Microsoft Visual Basic 2008
Microsoft Visual C# 2008 91605-270-9658527-60105
Microsoft Visual C# 2008
Microsoft Visual C++ 2008 91605-270-9658527-60105
Microsoft Visual C++ 2008
Microsoft Visual Studio 2008 Tools for Office 91605-270-9658527-60105
Microsoft Visual Studio 2008 Tools for Office
Microsoft Visual Web Developer 2008 91605-270-9658527-60105
Microsoft Visual Web Developer 2008
Crystal Reports AAJ60-G0MSA4K-68000CF
Crystal Reports Basic for Visual Studio 2008
May 31, 2011 06:01 PM|kedarrkulkarni|LINK
u can same connection to connect to 11g.
i have a .Net 2.0 (Vs 2005) application... wherein, oracle backend was upgraded to 11g and my application works without any change required..
make sure that you can connect to Oracle 11g database from any oracle query tool or
sqlplusw from same machine where u r usng visual studio.
the error message indicates some issue with tnsnames.ora file or other configuration file of oracle.... rather that Vs issue.
hope this helps...
May 31, 2011 07:39 PM|GoofyGiraffe|LINK
Thanks for your reply, but, I can connect to the DB server via SQLPLUS without a problem.
Using the same TNS Service Name with Visual Studio 2008 results in error messages I have described in the beginning.
I hope Visual Studio doesn't require a local DB Server.
Another thing, my local Oracle client is 10g , while Oracle Server is 11g.
On paper that should not be a problem but one never knows.
May 31, 2011 08:09 PM|kedarrkulkarni|LINK
just a thought...
u r local machine is 64 bit and vs is 32 bit.. so might be, they are referring diffrent client tnsnames...
check oracle folder if there is multiple client folders...
check this out.... i m too curious to know if any compatibility issues
Jun 01, 2011 07:19 AM|GoofyGiraffe|LINK
Here's what I found on the Internet :
Will install Oracle 11g client X64 and see wheather that fixes it.
Jun 20, 2011 07:48 AM|GoofyGiraffe|LINK
In the end , the only way to move on was to install Visual Studio 2008 on a 32bit platform.
Once I did that everything was working OK.
The generated code would then also run on 64 bit machines.