Connecting to an Oracle Database Programmatically Visual Studio NET ?
Hi
i need help. Iam searching now for a week about a solution, tutorial, help or hint.
Iam new into Oracle. I got lot of experience with MySQL but i dunno how i can connect via Visual Studio NET or c++ to the Oracle database and about what i should take care.
Anyone can help with a code or Tutarial..
Many thx in advance
Indian
Have you tried using the Server Explorer
The Server Explorer
Your starting point for developing database applications with VB.NET is the Server Explorer. This
toolbox is your gateway to the databases on your system or network, and you can use it to locate and
retrieve the tables you’re interested in. Place the pointer over the Server Explorer tab to expand the
corresponding toolbox, which looks something like the one shown in Figure 20.5. The two main
objects in the Server Explorer are Data Connections and the Servers object. Under the Data Connections
branch, you will see the connections to databases you’re programming against. Under the
Servers branch, you will see the database servers you can access from your computer and various
objects they expose.
Or have you tried setting up a System DSN ODBC Data Source in your control panel, so then you can just reference that name in your program.
Also included with Oracle if install on a machine that you have access to is C++,VC++, JDBC,ODBC, and other device drivers(*.dll's) and header files that you can use to access the database. Found in sub folders of OraHOME directory, using named com,plsql,oci,odbc,jdbc, etc... and other folders also.