Without DSN访问ISP的数据库拼盘

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

1.sql server

<%

cstr = "provider=sqloledb;server=<ip address>;database=<dbname>;"

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

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

conn.open cstr

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

%>

2.oracle

<%

cstr = "provider=oraoledb.oracle;server=<ip address>;data "

cstr = cst & "source=<dbname>;user id=<uid>;password=<pwd>"

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

conn.open cstr

%>

3. access

<%

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

cstr = cstr & server.mappath("/<pathtofile.mdb>")

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("/<pathtofile.mdb>")

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

conn.open cstr

%>