Nov 12, 2004 #1 amir4oracle Programmer Joined Nov 3, 2004 Messages 46 Location CA How can i connect oracle with c, vb and java applications
Nov 15, 2004 #2 taupirho Programmer Joined Jun 25, 2002 Messages 680 Location GB 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 Upvote 0 Downvote
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
Jan 11, 2005 #3 gazal Programmer Joined Apr 30, 2003 Messages 212 Location OM 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 Upvote 0 Downvote
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