473,383 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Problem on querying Access link table in ASP page

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
0 1546

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

Similar topics

1
by: tabonni | last post by:
Hi All I connected MS Exchange Server to MS Access database using Access link table function. I can open the database table and see the fields and data inside the link table. However, the table...
1
by: JimJimJimJim | last post by:
Hi. I'm coming from a background of developing mdbs and am trying to migrate our databases to adps running atop MSDE 2000. However, I've encountered a problem while trying to do analogous things to...
4
by: Larry Rekow | last post by:
Using Access 2000, I have a linked table using specification named "Test Link Specification" When attempting to create data adapter in VS.Net, it first complains that it cannot retrieve the...
1
by: dwlawren | last post by:
I wrote a C# asp.net app. that uses MS Access as a backend. I forgot include in my design that the Link tables would break when I deployed the application to the "Live" server. The problem is:...
9
by: John Smith | last post by:
Hi, I have this problem. I have a page class in code behind called "WebForm1" and I have another class called "Class1". Now in Class1 I am creating ImageButton and I am adding event handler...
6
by: =?Utf-8?B?SmF5IFBvbmR5?= | last post by:
I am trying to access a Public property on a Master Page from a Base Page. On the content pages I have the MasterType Directive set up as follows: <%@ MasterType virtualpath="~/Master.master" %>...
0
by: eighthman11 | last post by:
Hello everyone, quick question. I have an Access application (Access 2003) which has link tables to a SQL server. When you do anything on the application that requires accessing data of a link...
1
by: Luting | last post by:
Hi everyone, I am working on a project using Access as the frontend of a Oracle database. I'd like to use the Dual table in Oracle so I made a link table in Access for the Dual. However, it...
3
by: Vee007 | last post by:
Following is my code: Dim objCatalog As ADOX.Catalog Dim objTableLink As ADOX.Table Dim objADOConnection As ADODB.Connection Try objADOConnection = New...
10
by: colintis | last post by:
Hi guys, Is there anyone who had and resolved a problem with linked tables? The database works normally while I do the work with Access 2003, but when my PC had upgrade to use Access 2007, I...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.