How to connect to Oracle Database with VC2005

Hot Topic

User Selected Database Path
Enter button sensitivity in Console Apps (C# Express)
Question about UTF7 getChars and getBytes?
How to dynamically Create huge grid of editable textboxes at runtime..Help..
trouble using delegate in WndProc
devenv.exe in 2005 ignores project's Output Path
VS 2005, enable in-method code folding
While Loops and Keyboard Events
Changing Permissons of FTP'ed File
Computer LDAP path

Visual C#

Problem with IDataReader method GetValues
Searching a byte array for a pattern of bytes
variable problem
Shortcut
How to Pass (from any index of) Array in function
#msntb_toolbar_full_name#
Opening certain files with C#
C# and MFC
Trouble when creating directory
using System.Diagnostics

How to connect to Oracle Database with VC2005

Hi:

Can somebody throw some light on how to make an oracle database connection with VC2005. The only options available are for MS Access and MS SQL server in the data connection wizard.

Thanks,
Jyoti


Answer this question

How to connect to Oracle Database with VC2005

  • Kevin Kwan

    Thanks very much for the response.

    Actually I was looking for connecting to remote Oracle databases through Visual C# express edition (beta 2)and I found out from other forums that its not possible for express edition.  Please let me know if you know of other possibilities.

    Thanks,
    Jyotiswarup

  • Michael Hansen

    Jyotiswarup, check your .Net framework directory (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215) for the System.Data.OracleClient.dll.  It should be there.  If it is, just add it as a reference in your project and then System.Data.OracleClient should be "recognized".



  • NeilMaclean

    Hi dkocur2(sorry, dont know ur name):

    I have checked whatever u specified and the reference is also there. But still it does not connect.

    I even tried to use system.data.oracleclient for 'web developer express edition' for connecting to databases to update/insert, it does not seem to work. gives this error: ORA-01036: illegal variable name/number

    It works for select statements though.....Maybe I need to buy the standard edition to make it work.
    Thoughts.....any help would be appreciated.

    Thanks,
    Jyotiswarup

  • rzddr

    I need to connect to oracle database and the wizard does not allow that. Even the code does not recognize System.Data.OracleClient. I found out the other editions have this functionality.
    Thanks.

  • BrunoR2

    I assume you mean C# since you posted in that forum; here is an article from MSDN that describes connections to Oracle.

    http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon/html/vbtskCreatingConnectionToOracleDatabase.asp

    Is this what you were looking for

    Chad

  • Kryor

    Seems to me it's working if your getting an ORA-01036 error.  You're issue may have more to do with Oracle than with what version of VS you have.  Google "ORA-01036" and you might find what's causing it.



  • LFDIII

    I haven't had the opportunity to try the Express products, but while I imagine there may not be an option in the wizard to connect; what are the barriers to writing the code to connect inline   What functionality is the wizard not providing that you need to complete this task
  • How to connect to Oracle Database with VC2005
Answer this question