Connecting to a website

  • Thread starter Thread starter spikeybloke
  • Start date Start date
S

spikeybloke

I want to connect a database to a website... but I dont have a clue how
and would like to know more about whats involved.

I know a DSN has to be set up. I've been to various sites where and
they supply code to connect the database, showing the path on the drive
the database is held.

Where does this code go? When is the database loaded? Is it when the
website is loaded, or is it when theuser enters search criteria and
hits the search/go button.

I am going to have VBA forms with buttons on, to browse each individual
record. How is this put on a website? are they saved as .html?

A lot of this is quite basic, but It's starting to fry my head. As I
said, I've found various sites which tell me diferent things.

I'm using Access 2000 and Dreamweaver MX.

Any help/tips/pointers would be greatly appreciated.
 
Need more information... I think this is a quasi access database question so
here goes nothing...

1. Access file is MDB. check
2. Server on webite is: ?? (Linux/Window 2003, Win 95, Linux, unix,
Microvax 3000, PDP 11/23, trs-80 Coco, Amiga, Atari ST,TT, Nintindo Game
Cube, Xbox, PS-2??
3. Method of Accessing database is: ??
4. Do you have full access to the machine: ??
5. Do you have a development platform: ??
6. Did you test the database on your development platform first: Y/N
7. What is your connection string to the next question.
8. Web Environment: PHP, ASP, ASP.NET, CGI, X Windows, GDI+, Mathsad, HTML,
XML, Flash, etc...
9. DSN setup? Who is going to access it... intranet, extranet, portal,
internet access.

If you can't answer these questions pretty quickly, it will take at least a
week with lots of help for you to set up your database.

But MS Access supports asp and asp.net, although you can use a lot of other
back end languages with them.

Best to get a windows operating system with a server like Window 2003 or a
professional addition, as well as a development environemnt like Borland, or
VS .net and test your app on IIS on your personal workstation b/f you set up
a commercial DNS like somewierdname.net.

I recommed getting books that are sold for IT and computer science courses
personally.

Note: The back end is not saved as HTML. What the user will see is HTML,
but what goes on behind the scences is definitely not HTML. Except all the
strings inside the backend are usually chalked full of HTML strings.

One further note: The connection string on your development platform would
point to the location of the db, if you moved your software such as asp to a
commercial server, you would have to point the connection string to your new
location. Unless of course the database is in the same location as it was
in your development platform.

HTH,
Marc N
 
Back
Top