Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Online Database mdb reading

Posted on 2001-08-22
6
Medium Priority
?
281 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 400 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

721 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