Solved

Online Database mdb reading

Posted on 2001-08-22
6
274 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 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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

760 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now