ASP在不同windows平台下连接ODBC DSN数据库的方法
一,测试用的ASP代码
<% Dim szSQL on error resume next Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "DSN=myodbc_dbX","","" if err<>0 then Response.Write "<P>Check that this is a System DSN and the name is spelled correctly.</P>" Response.write "<P>The error code was: " & err.number & " " & err.description else szSQL = "SELECT * From tableName" Set oRS = Server.CreateObject("ADODB.Recordset") oRS.Open szSQL, oConn, 3, 3 Response.Write "You have <B>" & oRS.RecordCount & "</B> records in your table" End if oRS.close oConn.close %>
二. windows2003 32位 平台
此过程比较简单, 先手动添加ODBC数据源, 比如新建一个ODBC,名为myodbc_dbX数据源,指向一个新建的ACCESS