Erosu recommended mysql & asp <% DIM dbtype'dbtype = "mssql" link MSSQL database DBTYPE = "mysql" link mysql database 'dbtype = "access" "link Access database
DIM STRCONN '## DSN'StrConn = "DSN = my_dsn_name"' strconn = "dsn = mysql_dsn"
'## MS Access 2000 Using Virtual Path'STRCONN = "Provider = Microsoft.jet.Oledb.4.0; Data Source =" & Server.mAppath ("/ SSGbook / SSGbook.mdb")
'## ms access 2000'strconn = "provider = microsoft.jet.Oledb.4.0; data source = e: /site/asp/ssgbook/ssgbook.mdb"
'## ms access 2000'strconn = "driver = {Microsoft Access Driver (* .mdb)}; dbq =" & Server.mappath ("ssgbook.mdb")
'## link MS SQL Server 2000 & 7'strConn = "Driver = {SQL Server}; server = server_name; uid = uid; pwd = pwd; database = dbname"
'## link mysql database' strconn = "driver = mysql; server = server_name; uid = uid; pwd = pwd; database = db_name" strconn = "driver = {mysql odbc 3.51 driver}; server = free520.vicp.net; UID = Olym; PWD = 123123; Database = Olym-Tech "
DIM DBSET DB = Server.createObject ("AdoDb.Connection") DB.Open = STRCONN
SQL = "Select * from agent" set = db.execute (sql) do while not rs.eof response.write rs ("name") rs.movenext loop
%>
