C # -- connect to access
String conn = "Data Source = 'fdc. mdb '; Jet oledb: Database Password = 123; provider = 'Microsoft. Jet. oledb.4.0'; user id = admin ";
Java -- connect to access
String strurl = "JDBC: ODBC: Driver = {Microsoft Access Driver (*. mdb)}; DBQ = student. mdb ";
Class. forname ("Sun. JDBC. ODBC. jdbcodbcdriver ");
Connection conn = drivermanager. getconnection (strurl );
Statement stmt = conn. createstatement ();
Resultset rs1_stmt.exe cutequery ("select * From mcp_swty_player ");
C # -- connect to excel
String conn = "provider = Microsoft. Jet. oledb.4.0; Data source=allinserinfo.xls; extended properties = Excel 8.0 ;";
C # -- connect to SQL Server
String conn = "Data Source = (local); initial catalog = barefootindex0425; user id = sa; Password = sa; Connect timeout = 180; enlist = true; pooling = true; max pool size = 300; min pool size = 5; connection lifetime = 200; packet size = 4096 ";