I had the DSN connection in my code. Now I am uploading my files. Here I have to make connection string for the connection. Following error is occuring:

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

I have written following code for it.

set adoConn = Server.CreateObject("ADODB.Connection")
set rsCategories = Server.CreateObject("ADODB.Recordset")

adoConn.Open "Driver={mySQL}; Server=205.178.146.77; Stmt= 'SELECT count(b.id) as artCount, a.id, b.categoryid, a.categoryname FROM wbs_categories a, wbs_articles b WHERE a.id=b.categoryid AND b.active=1 Group By a.id ORDER BY CategoryName'; Database=test_wz; Uid=dbtest_user; Pwd=3Db63Us9;"

rsCategories.ActiveConnection = adoConn

Can anybody help me for it?