connecting to access

[shilpag2]

hi
i am very new to asp and is not able to connect to the database that is in access.
please tell me in detail what sholud I do
thanks

 

[snowboardr]

Don't use Access unless you have no other options on your host. I would suggest if you have hosting that has MySQL to go with it, you will be happy you did in the long run.

Don't be scared, mysql is not hard at all. And this tutorial will get you through the rough stuff:
Even will shows you how to import an existing Access database.

http://www.vzio.com/tutorials/mysql_database.asp

There is alot of bad things that happen when using access. And MySQL makes your life much easier.

Make sure you have IIS (Internet Information Services) or PWS (Personal web server) running for testing your scripts on

http://localhost/

I can imagine you do already

- Jason

 

[ChrisHirst]

search the forum and the FAQs

try these.

http://www.stardeveloper.com/articles/display.html?article=2000030903&page=1

http://www.haneng.com/Lessons_17.asp

http://www.webwizguide.info/asp/tutorials/connecting_to_a_database.asp

http://www.asp101.com/samples/index.asp

not that I'm being unhelpful but the question has been answered many times.


Chris.

Indifference will be the downfall of mankind, but who cares?

 

[snowboardr]

In all honesty I wish I would have never had to mess with Access in the first place when I started, but I had good half a year in it, and I never could get Insert to work because Permissions in Win XP, and I couldnt change the permissions for some reason, it was just difficult.

I have read about access, and it can't take much abuse, it can become corrupt, you don't have alot of handy little tricks that you do with other databases, such as RAND() Or LIMIT 0,10 in MySQL, which is a time saver.

And even though this database seems like it would hog all your computer resources + some MySQL is using about 2 mb's of ram right now on My Developing computer.

And if you want room to grow MySQL is the way to go on that to.

One of the case studies states this on MySQL.com:

Cox Comm Company:
- 2-billion row MySQL database
- 3,600 tables
- MySQL database handles approximately 4 million inserts every two hours
-soon to be 600GB in size


Found here:

http://www.mysql.com/press/user_stories/Cox Communications.html

- Jason