Online Database mdb reading

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
Sparrow1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
KokaConnect With a Mentor Commented:
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
 
Sparrow1Author Commented:
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
 
KokaCommented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Sparrow1Author Commented:
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
 
KokaCommented:
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
 
Sparrow1Author Commented:
Thanks for all the comments
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.