Oracle Database Connection

xiaoxiao2021-03-06 39

ODBC

New version: "driver = {microsoft odbc for oracle}; server = oracleserver.world; uid = username; pwd = asdasd;"

Old Version: "Driver = {Microsoft ODBC Driver for Oracle}; connectionString = Oracleserver.World; UID = myusername; PWD = mypassword;"

OLEDB, OLEDBCONNECTION (.NET)

Standard security: "Provider = msdaora; Data Source = MyOracleDB; User Id = UserName; Password = asdasd;" This one's from Microsoft, the following are from OracleStandard Security: "Provider = OraOLEDB.Oracle; Data Source = MyOracleDB; User Id = UserName; Password = asdasd; "

Trusted Connection: "provider = oraoledb.oracle; data source = myoracledb; osauthent = 1;"

OracleConnection (.NET)

Standard: "Data Source = Oracle8i; Integrated Security = YES"; this One Works Only with Oracle 8i Release 3 or LaterDeclare The OracleConnection:

C #: use system.data.racleClient; OracleConnection OracleConn = New OracleConnection (); oracleconn.connectionstring = "my connectionstring"; oracleconn.open ();

VB.NET: IIMPORTS System.Data.OracleClientDim Oracleconn As OracleConnection = New OracleConnection () Oracleconn.Connectionstring = "My Connectionstring" oracleconn.open ()

Data Shape

MS Data Shape: "Provider = MSDataShape.1; Persist Security Info = False; Data Provider = MSDara; Data Source = ORAC; User ID = UserName; Password = MYPW"

Example 1: Namespace Oracle {///

/// WebForm1 summary description. /// public class WebForm1: System.Web.UI.Page {protected System.Web.UI.WebControls.DataGrid DataGrid1; private DataSet myDataSet = new DataSet (); private void Page_Load (object sender, System.EventArgs e) {// Place the user code here to initialize the page string connString = "provider = oraoledb.racle; data source = jtest; user ID = system; password = manager;"; OLEDBConnection conn = new oledbconnection; string; string; string; string; string strcom = "select * from system.LG_TASK_TABLE"; conn.Open (); OleDbDataAdapter mycommand = new OleDbDataAdapter (strcom, conn); mycommand.Fill (myDataSet, "system.LG_TASK_TABLE"); DataGrid1.DataSource = myDataSet.Tables [ " System.lg_task_table "]. Default1.DATABIND (); conn.close ();

转载请注明原文地址:https://www.9cbs.com/read-76136.html

9cbs

New Post(0)