ODBC New version: "Driver = {Microsoft ODBC for Oracle}; Server = OracleServer.world; Uid = Username; Pwd = asdasd;" Old version: "Driver = {Microsoft ODBC Driver for Oracle}; ConnectString = 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 #: using System.Data.OracleClient; OracleConnection oOracleConn = new OracleConnection (); oOracleConn.ConnectionString =" my connectionstring " Oracleconn.open (); VB.NET: IIMPORTS System.Data.OracleClientdim Oracleconn AS ORACLECONNECTION = New ORA cleConnection () oOracleConn.ConnectionString = "my connectionstring" oOracleConn.Open () Data Shape MS Data Shape: "Provider = MSDataShape.1; Persist Security Info = False; Data Provider = MSDAORA; Data Source = orac; user id = username; Password = mypw example 1: Namespace Oracle {////
