Solved

Online Database mdb reading

Posted on 2001-08-22
6
279 Views
Last Modified: 2008-02-20
I am trying to put a form which can search for records which meet the criteria (such as by Occupation, or first name, or last name etc). The database where all this information is stores is an Access 2000 mdb file.

Questions:
Is Microsoft's ASP the only way to access the tables of data within an mdb file.
Does this restrict me to running IIS.
It is possible to get ChiliASP to run on an Apache Web Server,
What are the pros/cons of this approach?

The objective of this question-thread is to find out the different ways to access an mdb file on a webserver adn what people really think of the different possible implementations of a web-database access program.

Thanks, Sparrow1
0
Comment
Question by:Sparrow1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 3

Accepted Solution

by:
Koka earned 100 total points
ID: 6414659
I do not know anything about ChiliASP, but I'm almost sure you can use anything that can access ODBC data sources (e.g. JSP through JDBC-ODBC bridge - and sure there will be something in ChiliASP too). However, imho, if you are looking for
>different possible implementations of a web-database access
you'd better go for some multiplatform database server (like Oracle, or MySQL).
0
 

Author Comment

by:Sparrow1
ID: 6414712
My Office is working with a database which has been developed in Access 2000. and we want to put a part of it on our webpage to enable people to search for the contact information of people. I think that I would prefer to stick with an Access mdb file as the datafile for the online - format (as opposed to having to support 2 different formats (like Access + MySQL etc)).

How hard is it / what changes are done in order to convert (conversion necessary?) from plain mdb to a ODBC data source?
0
 
LVL 3

Expert Comment

by:Koka
ID: 6414887
You need no conversion at all. Just open Control Panel - Administrative Tools - ODBC data sources and click Add. Yould be prompted for driver (Choose MS Access) etc - pretty simple staff.

The real job to do is to build the ChiliASP pages that access Database via that ODBS data source.
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

Author Comment

by:Sparrow1
ID: 6414922
Once I have linked an ODBC Data source to my mdb file, can I use CGI, ASP, etc to access the data. What are advantages / disadvantages of each.

Do I understand this correctly: If I don't create an ODBC Source connection to the mdb, I can still access it with ASP, but once I connect to an ODBC, anything can be used to connect to it?
0
 
LVL 3

Expert Comment

by:Koka
ID: 6414957
Even if you access MDB wo creating DSN, you are using the same Access ODBC driver (recall the connection string you use there). I think of DNS just to be a ready-made saved connection string with some saved options. Sure you can construct connection string and set the same options from the code but anyway you will be using ODBC driver. So maybe I did not put it right
>can access ODBC  data sources
should read
>can open connection using ODBC driver

0
 

Author Comment

by:Sparrow1
ID: 6418562
Thanks for all the comments
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question