使用DSN连接Access数据库，ODBC如何设置

[sihaomictuow]

各位大侠，我最近刚涉足ASP，想用DSN连接Access数据库。数据库文件.mdb就是本机的一个文件。用IIS做Web Server。连接代码如下：
Set Con = Server.CreateObject("ADODB.Connection")
Con.Open "DSN=ITCS936g115"
在ODBC中建立相应DSN，可是如果直接指向本机的mdb文件，数据库连接肯定不成功。所以请教大家ODBC端的DSN应该怎样设置，是否要用网络路径或其他什么方法的？请回答。

[GumPGZ]

控制面版,管理工具,数据源odbc,系统dsn
添加,选择Microsoft Access driver (*.mdb)
完成,在"数据源名称"中输入你自己定义的名字,随便,
这是你以后要使用的(入:mydb),然后点选择定位到哪个*.mdb文件即可

使用时这样即可Open打开的是数据源
Set Con = Server.CreateObject("ADODB.Connection")
Con.Open "mydb"

[sihaomictuow]

我就是这么做的，但是ODBC中DNS（例如名为mydb）选择的是本地路径如C:\abc.mdb，而连接数据库时使用的是主机名如http://localhost/*.asp，所以用代码
Set Con = Server.CreateObject("ADODB.Connection")
Con.Open "mydb"
连接数据库时好像不认我设置的DNS名，返回错误
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
请指教！

[buaawjh]

ODBC Driver for Access

For Standard Security:

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\somepath\mydb.mdb;" & _
"Uid=admin;" & _
"Pwd=;"If you are using a Workgroup (System database):

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\somepath\mydb.mdb;" & _
"SystemDB=c:\somepath\mydb.mdw;", _
"myUsername", "myPassword"If want to open up the MDB exclusively:

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\somepath\mydb.mdb;" & _
"Exclusive=1;" & _
"Uid=admin;" & _
"Pwd=;" If MDB is located on a Network Share:

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=\\myServer\myShare\myPath\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd=;"If MDB is located on a remote machine:- Or use an XML Web Service via SOAP Toolkit or ASP.NET
- Or upgrade to SQL Server and use an IP connection string
- Use an ADO URL with a remote ASP web page
- Or use a "MS Remote" or RDS connection string
If you don't know the path to the MDB (using ASP)

<% ' ASP server-side code
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Server.MapPath(".") & "\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd=;"
%>This assumes the MDB is in the same directory where the ASP page is running.
Also make sure this directory has Write permissions for the user account.


If you don't know the path to the MDB (using VB)

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & App.Path & "\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd=;"This assumes the MDB is in the same directory where the application is running.