ibm connect direct

Recently re-installed Windows7 64-bit, and installed the oracle10g64 bit, found that PB even Oracle frequent error. The last night was settled. The development environment, in addition to the database service, installs 32-bit Oracle clients, because PB is 32-bit.Add a system-level environment variable:Tns_admin D:\oracle\product\10.2.0\client_1\NETWORK\ADMINThe client is installed by default, and the first one in path is D:\oracle\product\10.2.0\client_1\bin;If PB is still unable to

Label: PackageCn.zno.jdbc.jdbc; Importjava.sql.Connection;ImportJava.sql.DriverManager;Importjava.sql.SQLException; Public classMain { Public Static voidMain (string[] args) {String driver= "Oracle.jdbc.OracleDriver";//Driver class full path nameString url = "Jdbc:oracle:thin:@//myhost:1521/myservicename";//URLString username = "Scott";//User nameString password = "Tiger";//Password//First step: Load driver Try{class.forname (driver); } Catch(ClassNotFoundException e) {e.printstacktrac

usingOracle.ManagedDataAccess.Client;2 3 Public Static stringconnectoracle ()4 {5 Try6 {7 stringConnString ="Data source= (description= (address= (protocol=tcp) (host=130.147.246.144) (port=1521)) (Connect_data= (SERVICE_ (NAME=ECMS))); Persist Security info=true; User Id=system; PASSWORD=SERVICE01;";8OracleConnection con =NewOracleConnection (connstring);9 Ten con. Open (); One return string. Empty; A

) 1234567891011121314151617 usingOracle.ManagedDataAccess.Client;publicstatic stringConnectOracle(){try{stringconnString ="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.147.246.144)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ECMS)));Persist Security Info=True;User ID=system;Password=Service01;";OracleConnection con =newOracleConnection(connString);con.Open();returnstring.Empty;}catch(Exception ex){returnex.ToString();}} 　　It is so simple!!! Addit

) 1234567891011121314151617 using Oracle.ManagedDataAccess.Client;publicstaticstringConnectOracle(){try{stringconnString ="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.147.246.144)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ECMS)));Persist Security Info=True;User ID=system;Password=Service01;";OracleConnection con =newOracleConnection(connString);con.Open();returnstring.Empty;}catch(Exception ex){returnex.ToString();}} 　　It is so simple!!! Addit

connection string)? 1234567891011121314151617 using Oracle.ManagedDataAccess.Client;public static string ConnectOracle(){try{string connString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=130.147.246.144)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ECMS)));Persist Security Info=True;User ID=system;Password=Service01;";OracleConnection con = new OracleConnection(connString);con.Open(); return string.Empty;}catch (Exception ex){return ex.ToString();}}

Key codeIpropertyset Ppropertyset =NewPropertysetclass (); Ppropertyset.setproperty ("SERVER", SDE. ipadress); ppropertyset.setproperty ( "INSTANCE","sde:oracle11g$//" + SDE. Ipadress +"/" + SDE.Instance); Ppropertyset.setproperty ("USER", SDE.User); Ppropertyset.setproperty ("PASSWORD", SDE.Password);Ppropertyset.setproperty ("Authentication_mode", "DBMS"); Ppropertyset.setproperty ("VERSION", "SDE". DEFAULT ");The code that is marked bold is the key codeArcengine

Original address: http://www.cnblogs.com/gguozhenqian/p/4262813.htmlThere is a feature in the project need to get data from an Oracle database, this thought is very simple thing, the original SqlClient changed to OracleClient call, the result is far from the simple. There are a lot of needs to install Oracle client, just the project is very urgent, the company also has no Oracle environment, can make me nasty. This aspect of the Internet search, too many articles, but also to test, choose, are a

Database connections: Direct-connect and disconnectedusing System.Data using System.sqlclientConnection creating a connection to the database: 1, server 2, authentication 3, specifying the database"." On behalf of native or (local), database is the name of the databases, if using Windows authentication with integrated Security = true;New"server =.;D atabase = Stu;uid = sa; PWD = 123";Conn. Open ();Command//

;public static string connectoracle () {try {s Tring connstring = "Data source= (description= (address= (protocol=tcp) (host=130.147.246.144) (port=1521)) (CONNECT_ Data= (SERVICE_NAME=ECMS)); Persist Security info=true; User Id=system; password=service01; "; OracleConnection con = new OracleConnection (connstring); Con. Open (); return string. Empty; } catch (Exception ex) {return ex. ToString (); }} is so sim

Operation Steps:1, DLL download and reference (this DLL is actually oracle for C # specifically provided, in its official can also download to the Oracle website): Oracle.ManagedDataAccess.zipAfter downloading, place the Oracle.ManagedDataAccess.dll in your project and then reference2. Call (connstring change to its own connection string)Using Oracle.ManagedDataAccess.Client; public static string Connectoracle () { try { string connstring = "Data sourc