Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can i connect oracle with c, vb and java applications

Status
Not open for further replies.

amir4oracle

Programmer
Nov 3, 2004
46
CA
How can i connect oracle with c, vb and java applications
 
For C you'ld use either PRO*C or the Oracle call Interface (OCI).

For VB you'ld normally use ODBC or Oracle Object for Ole (oo4o)

For Java use the JDBC thin client
 
HI
FOLLOWING EXAMPLE SHOWS CONNECTING TO ORACLE FROM VB USING ODBC AND OLEDB BOTH

Set cn = New ADODB.Connection

========== ODBC =================
ConString = "Driver={Microsoft ODBC for Oracle};Server=HQTEST;Uid=dgpadc;Pwd=dgpa;"

cn.open constring

======== OLEDB ======================

ConString = "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"


cn.Open ConString

hth
GAZAL
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top