oracle中without,Without DSN访问ISP的数据库拼盘

除非你用远程登录软件logon isp的服务器，否则你是没有办法通过dsn连接数据库。下面介绍几种连接方法，让你超越与你的isp之间的空间距离，让你连接数据库变得简单:

1.sql server

cstr = "provider=sqloledb;server=;database=;"

cstr = cstr & "network=dbmssocn;uid=;pwd="

set conn = server.createobject("adodb.connection")

conn.open cstr

利用network=dbmssocn方式连接可以避免管理命名引起的错误

%>

2.oracle

cstr = "provider=oraoledb.oracle;server=;data "

cstr = cst & "source=;user id=;password="

set conn = server.createobject("adodb.connection")

conn.open cstr

%>

3. access

cstr = "driver={microsoft access driver (*.mdb)};dbq="

cstr = cstr & server.mappath("/")

set conn = server.createobject("adodb.connection")

conn.open cstr

%>

4.如果你安装了jet 4.0,用这种方法连接效果更好.

cstr = "provider=microsoft.jet.oledb.4.0;data source="

cstr = cstr & server.mappath("/")

set conn = server.createobject("adodb.connection")

conn.open cstr

%>