By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,162 Members | 1,061 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,162 IT Pros & Developers. It's quick & easy.

Problem on querying Access link table in ASP page

P: 1
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:

Expand|Select|Wrap|Line Numbers
  1. dim adConTbl
  2. set adConTbl=server.createobject("adodb.Connection")
  3.  
  4. adConTbl.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Transferfiles\FADB.mdb;Persist Security Info=False;"
  5.  
  6. set rst=server.createobject("adodb.recordset")
  7.  
  8.     with rst
  9.         if .State <> 0 then .Close 
  10.         vSql="select * from users"
  11.  
  12.         'Response.Write vSql
  13.         'Response.End 
  14.         .Open vSql,adconTbl
Please help
Jan 10 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.