| 发表于：2008-01-02 20:59:551楼 得分:0 |
ibm db2
ole db, oledbconnection （.net) from ms
tcp/ip:
"provider=db2oledb;network transport library=tcpip;network address=xxx.xxx.xxx.xxx;initial catalog=myctlg;package collection=mypkgcol;default schema=schema;user id=myuser;password=mypw"
appc:
"provider=db2oledb;appc local lu alias=myalias;appc remote lu alias=myremote;initial catalog=myctlg;package collection=mypkgcol;default schema=schema;user id=myuser;password=mypw"
ibm's ole db provider （shipped with ibm db2 udb v7 or above)
tcp/ip:
provider=ibmdadb2;database=sample;hostname=db2host;protocol=tcpip;port=50000;uid=myusername;pwd=mypwd;
odbc
standard:
"driver={ibm db2 odbc driver};database=mydbname;hostname=myservername;port=myportnum;protocol=tcpip; uid=myusername; pwd=mypwd"
access连接字符串：
<%
dim conndim connstrdb="data/data.mdb" '数据库文件位置
on error resume next
connstr="provider=microsoft.jet.oledb.4.0;data source=" & server.mappath（db)set conn=server.createobject（"adodb.connection")if err thenerr.clearelseconn.open connstrend if
%>
sql连接字符串：
<%
response.buffer=true
on error resume next
name=request.cookies（"name")
connstring="driver={sql server};server=.;database=ebweb2005;uid=sa;pwd="
set nn=server.createobject（"adodb.connection")
set mm=server.createobject（"adodb.recordset")
nn.open connstring
%>
java连接常见数据库的连接字符串
1. mysql（http://www.mysql.com)mm.mysql-2.0.2-bin.jar ;
class.forname（ "org.gjt.mm.mysql.driver" );
cn = drivermanager.getconnection（ "jdbc:mysql://mydbcomputernameorip:3306/mydatabasename", susr, spwd );
2. postgresql（http://www.de.postgresql.org)pgjdbc2.jar ;
class.forname（ "org.postgresql.driver" );
cn = drivermanager.getconnection（ "jdbc:postgresql://mydbcomputernameorip/mydatabasename", susr, spwd );
3. oracle（http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip ;
class.forname（ "oracle.jdbc.driver.oracledriver" );
cn = drivermanager.getconnection（ "jdbc:oracle:thin:@mydbcomputernameorip:1521:orcl", susr, spwd );
4. sybase（http://jtds.sourceforge.net)jconn2.jar ;
class.forname（ "com.sybase.jdbc2.jdbc.sybdriver" );
cn = drivermanager.getconnection（ "jdbc:sybase:tds:mydbcomputernameorip:2638", susr, spwd );
// （default-username/password: "dba"/"sql")
5. microsoft sqlserver（http://jtds.sourceforge.net) ;
class.forname（ "net.sourceforge.jtds.jdbc.driver" );
cn = drivermanager.getconnection（ "jdbc:jtds:sqlserver://mydbcomputernameorip:1433/master", susr, spwd );
6. microsoft sqlserver（http://www.microsoft.com) ;
class.forname（ "com.microsoft.jdbc.sqlserver.sqlserverdriver" );
cn = drivermanager.getconnection（ "jdbc:microsoft:sqlserver://mydbcomputernameorip:1433;databasename=master", susr, spwd );
7. odbc
class.forname（ "sun.jdbc.odbc.jdbcodbcdriver" );
connection cn = drivermanager.getconnection（ "jdbc:odbc:" + sdsn, susr, spwd );
8.db2
class.forname（"com.ibm.db2.jdbc.net.db2driver");
string url="jdbc:db2://192.9.200.108:6789/sample"
cn = drivermanager.getconnection（ url, susr, spwd ); | | |
|
