The Daily Click ::. Forums ::. Non-Klik Coding Help ::. MySql vs MS Access
 

Post Reply  Post Oekaki 
 

Posted By Message

Brad 



Registered
  16/01/2004
Points
  32

VIP Member
6th August, 2004 at 01:35:48 -

Just because I can't think of anywhere else to pose this question:

When writing ASP what is the diffrence when it comes to connecting to a MySql DB as opposed to conecting to a Access DB? Is the connection line the only thing that's different or am I going to have to dramaticallt alter all my code?

 
n/a

Steve Harris

Codito Ergo Sum

Registered
  28/01/2002
Points
  2032

Has Donated, Thank You!VIP MemberGOTM JULY - 2009 - 3RD PLACE!Hasslevania 2!Wii OwnerChristmas Tree!GOTW Winner January 2011!
6th August, 2004 at 04:20:06 -

I don't know why but i've always found a mysql db more stable when it comes to lots of users being online and/or having a lot of records (this is probably just my hosts fault as both TDC and KM seem to run fine...)

 
http://www.create-games.com/project.asp?view=main&id=927

www.steveharris.info
www.useful-by-design.co.uk
www.aellamassemailer.com
www.turningthetide.info

Tigerworks

Klik Legend

Registered
  15/01/2002
Points
  3882
6th August, 2004 at 07:34:03 -

I'd recommend MySql over Access. Access is only good for very small databases, such as in a small site like mine. Any bigger than that and it easily crashes or can't handle the load.
Access was designed before PHP/ASP for use in offices to store data. Then someone went and hacked a server side plugin for it, so it's a bit shakey round the edges.

 
- Tigerworks

Kris

Possibly Insane

Registered
  17/05/2002
Points
  2017
6th August, 2004 at 08:09:07 -

mysql is about 10 times faster at inserting too

 
"Say you're hanging from a huge cliff at the top of mt. everest and a guy comes along and says he'll save you, and proceeds to throw religious pamphlets at you while simultaniously giving a sermon." - Dustin G

ChrisB

Crazy?

Registered
  16/08/2002
Points
  5457
6th August, 2004 at 10:19:36 -

TDC gets quite a few database errors in my experience, and so does Natomic. They both use Access. But what can you expect from Microsoft?

 
n/a

Brad 



Registered
  16/01/2004
Points
  32

VIP Member
6th August, 2004 at 13:57:46 -

Great.. but what's the difference in scripting? Also how do I make a MySql db!?!

 
n/a

The Chris Street

Administrator
Unspeakably Lazy Admin

Registered
  14/05/2002
Points
  50116

Game of the Week WinnerClickzine StaffAcoders MemberKlikCast StarVIP MemberPicture Me This Round 35 Winner!Second GOTW AwardYou've Been Circy'd!Picture Me This Round 38 Winner!GOTM December Third Place!!
I am an April FoolKliktober Special Award Tag
6th August, 2004 at 14:37:59 -

I love it how Brad repeatedly says how TDC sucks, at various community sites, and yet here he is, posting a question because he needs help. The worm has turned, my friend

 
n/a

ChrisB

Crazy?

Registered
  16/08/2002
Points
  5457
6th August, 2004 at 15:38:54 -

AFAIK Brad doesn't use his punctuation like an idiot. I mean, he made 2 spelling mistakes, and that's a stupid question anyway because he knows how to use Google.

(see, you don't get any links to that 'googleit' site here, because we're nice people)

 
n/a

Tigerworks

Klik Legend

Registered
  15/01/2002
Points
  3882
6th August, 2004 at 18:21:52 -

AFAIK there's no difference in the actual scripting. You have to connect to the database a different way, but because the scripts usually use wrapper classes, you can use the same code for multiple database types.

 
- Tigerworks

Brad 



Registered
  16/01/2004
Points
  32

VIP Member
6th August, 2004 at 23:25:13 -

Tigerworks: Thanks!

Chris Branch: I love your poodle avatar.

Circy: If I wanted some 7 page nerd explaination I would have asked at one of the ASP tutorial sites that came up when I was looking for info. However because I don't care how ASP and MySql work server-side and ODBC, ADO, ISS, ODB... whatever other random strand of letters that may be thrown at me in a programers forum don't really help me much. So I asked here assuming someone like Jannis, Club, or Kris would give me a quick to the point explaination.

Anyway my questions are answered, thanks guys.

 
n/a

jast



Registered
  03/01/2014 01:12:19
Points
  186
7th August, 2004 at 12:18:09 -

"So I asked here assuming someone like Jannis, Club, or Kris would give me a quick to the point explaination."

Whoa, my name's in there

Your questions got answered but I'll add my two cents nonetheless In fact, I did with KM2 what you are going to do now (switching from Access to MySQL although lots of lines were already written). I didn't experience any problems. Getting a MySQL DB up and running on both, your own pc and your server can be trickier than you might expect, but you won't have to change much within your code. Just like Tigs said and just like you assumed in your first post, all you have to do is change your connection - that's one line you have to alter. I did not have to change anything else, all other code parts just kept working like they were supposed to.

 
n/a

Yai7

Peace & Love

Registered
  28/01/2002
Points
  249

26th May, 2007 at 18:09:38 -

Image
WRYYYYYYYYYYYYY!!!

 
(=
   

Post Reply



 



Advertisement

Worth A Click