Re: connecting to mysql via ODBC from asp.net

2002-09-29 Thread Ivan Paul
ops, sorry jay, i forgot this... do you install mysql in your web server? if you install it on your web server, so i think you should install the odbc driver for mysql in your web server... and after that u can use your asp script to make connection to your mysql database have a nice try :-

Re: connecting to mysql via ODBC from asp.net

2002-09-29 Thread Ivan Paul
dear jay fields, pls try this, hope this can help u... dim objconn, objrs set objconn = server.createobject("adodb.connection") set objrs = server.createobject("adodb.recordset") objconn.connectionstring="server=192.168.0.1;driver=MySQL;db=[database_name] ;uid=[user_name];pwd=[user_passwo