使用ACCESS的经典ASP连接 [英] Classic ASP connectivity with ACCESS

问题描述

请提供示例，将经典asp与MS ACCESS连接起来


很紧急

预先感谢

Please provide, with example, connecting classic asp with MS ACCESS


It''s quite urgent

Advance Thanks

推荐答案

谢谢您的提问.

Thank you for your question.

Dim strConn
strConn= "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\DatabaseFolder\AccessDatabase.mdb;DefaultDir=YourDefaultDir;UID=YourUserID;PWD=YourPassword;"

Dim oConnection
Set oConnection = Server.CreateObject("ADODB.Connection")

oConnection.Open strConn

Dim recordSet
set recordSet= Server.CreateObject("ADODB.RecordSet")

recordSet.Open "SELECT * FROM TableA ", oConnection, adOpenForwardOnly, adLockOptimistic

谢谢，
Mamun

Thanks,
Mamun

我尝试过这个，
但是如果我不支持DSN连接.........
Plz Ne 1帮我..........:confused:

I tried out with this,
but wht if i wnt DSN connection.........
Plz Ne 1 help me..........:confused:

这篇关于使用ACCESS的经典ASP连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！