Problem on querying Access link table in ASP page

[pmehta]

I am able to acccess the link tables from ms access database to My SQL. I am able to access through asp.net but through classsic ASP i am getting the following error:

Microsoft JET Database Engine error '80004005'

ODBC--connection to 'MYSQLDB' failed.


Code:

dim adConTbl
set adConTbl=server.createobject("adodb.Connection")

adConTbl.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Transferfiles\FADB.mdb;Persist Security Info=False;"

set rst=server.createobject("adodb.recordset")

	with rst
		if .State <> 0 then .Close 
		vSql="select * from users"

		'Response.Write vSql
		'Response.End 
		.Open vSql,adconTbl

Please help