connecting to mysql databse in asp (without dsn)

pwd

Trying to adapt the openwiki configuration asp script to work for me. What values should I be putting in for the driver and the server? Does anyone have any example code excerpts for doing this by any chance? Do I need the full pathname to the database file on the server?

pwd

here's the bit of the asp doc that I need to change. "this page cannot be displayed" is shown when I've tried all sorts of values in the string. (these are the default sample values below only)

' OPENWIKI_DB = "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\data\openwiki\OpenWiki.mdb"
' OPENWIKI_DB = "Driver={SQL Server};server=mymachine;uid=openwiki;pwd=openwiki;database=OpenWiki"
' OPENWIKI_DB = "Driver={Microsoft ODBC for Oracle};Server=OW;Uid=laurens;Pwd=aphex2twin;"
' OPENWIKI_DB = "MySystemDSName"
OPENWIKI_DB = "MySQLOpenWiki"
' OPENWIKI_DB = "PostgreSQLOpenWiki"
'OPENWIKI_DB = "OpenWikiDist"

Seth Brundle

<%
Dim myConn, connection
set myConn = server.createobject("adodb.connection") 
connection = "Driver={Mysql}; Server=localhost; Database=test; UID=root; PWD=root" 
myConn.open(connection) 
%>

You may also need these after PWD=root

Port=3306; Option=0; Socket=; Stmt=;