Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Online Database mdb reading

Posted on 2001-08-22
6
Medium Priority
?
282 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
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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

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.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

971 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