怎样做数据库连接？

[Computer_lover]

在asp中怎样做与oracle数据库连接？？？

[TCMY]

set ConnectionObject = Server.CreateObject("ADODB.Connection") '建立连接对象
connstr="Provider=MSDAORA.1;Password=pwd;User ID=test;Data Source=web;Persist Security Info=True" '数据库连接字串
ConnectionObject.Open connstr
'其中test 为 用户名 pwd为密码 web 为用oracle的net8配置的网络服务名

set DateConnect=Server.CreateObject("ADODB.Recordset")
SQLString="select * from table_test"
DateConnect.Open SQLString,ConnectionObject,1

[孟子E章]

OLE DB Provider for Oracle (from Microsoft)

oConn.Open "Provider=msdaora;" & _
"Data Source=OracleServer.world;" & _
"User Id=;" & _
"Password=;"


OLE DB Provider for Oracle (from Oracle)

For Standard Security

oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=;" & _
"Password=;"

For a Trusted Connection

oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=;" & _
"Password=;"
[B]Or

oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"OSAuthent=1;"

[wanghp79]

给个例子你：

Set objDBconn=Server.CreateObject("ADODB.connection")
objdbconn.open " Provider=SQLOLEDB;server=202.113.82.9;database=bbs;UID=sa;pwd=TSLib2003"

[wanghp79]

对不起我发错了

[Struggling]

strsql="DBQ="+Server.MapPath("*.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=Server.CreateObject("ADODB.Connection")
conn.open strsql
set rs=Server.CreateObject("ADODB.RecordSet")
rs.Source="select * from table where ...."
rs.open rs.source,conn,1,1

[lmix]

我想要关于informix的,怎么好象很好人用啊?