怎样不通过dsn调用access、txt数据库

[fiftystep]

我租用的虚拟空间想建立数据库，是否必须通过dsn调用。如果后者，请问怎样在isp商的服务器上远程建立dsn。多谢。

[King]

好象是不可能的事

[masterz]

You can use DSNless connection to open Database.
ConnString = "driver={Microsoft Access Driver (*.mdb)};dbq=c:\mydata.mdb"
set dbuser = server.createobject("ADODB.Connection")
dbuser.Open ConnString
Set rs= Server.CreateObject("ADODB.Recordset")
sSQL = "select * from mytable"
rs.open sSQL, dbuser, adOpenStatic, adlockpessimistic, adcmdtext

[TomTom]

ADOConnection1.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:\yourdate.mdb"