动态连接数据库时，如何使用当前目录的dsn文件（asp）(50分)

W

wy0311

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-02-10

• #1

strDSN = "FILEDSN=C:/123/odbc.dsn"
Set rsCustomers = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM data"
rsCustomers.Open strSQL, strDSN
怎样把 strDSN = "FILEDSN=C:/123/odbc.dsn" 中的绝对路径改成相对路径？

 

Z

zhongs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-02-11

• #2

strDSN="FILEDSN="+ Server.MapPath(".") + "/odbc.dsn"

 

W

wy0311

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-02-11

• #3

谢谢，我已经搞定了。

 

W

wy0311

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-02-11

• #4

接受答案了.