Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?


Login with username, password and session length
May 24, 2012, 01:53:58 PM

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Semi-Newbie Direct Question  (Read 375 times)
Default123
Newbie
*
Offline Offline

Posts: 4


WWW
« on: February 20, 2003, 04:16:00 PM »
Ok, apon detailed investigation, I'm thinking I'm going to go with you guys to host my sites.  However I'm most versed in programming .asp (VBScript) w/ MS Access databases (although not to say I'm any GOOD at it, mind you).  Now, I don't mind converting my databases to MySQL, but will I have to re-code my pages to access the new format?

To be specific, for example, I have a page that runs a counter (in .asp / VBScript) utilizing an MS Access DB ( and "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="... ).  Do I have to re-code the page for the converted MySQL DB?

I just realized this is more of a Dev question destined for a more appropriate forum group.  I'll post it there as well.  Thanks for your time.
Logged
stephan
Guest
« Reply #1 on: February 20, 2003, 07:27:00 AM »
Yeah, at the moment, you would have to change your script to make it work with mySQL.

It might be quite tricky, it depends how good you are with scripts/programming.

Lunarpages is hopefully adding Access database support in the near future, I don't know when it will be added. If you e-mail support@lunarpages.com , they might be able to tell you more about it.

In my opinion, it's easier to use a different script than convert it to use a different type of database. Personally, I wouldn't attempt it.
Logged
Navodyne
Intergalactic Cowboy
*****
Offline Offline

Posts: 64


WWW
« Reply #2 on: February 21, 2003, 10:57:00 PM »
I don't think you will have to recode the page because ASP and VBscript will work with mySQL - you just have to replace your line with something like this:

code:
Driver={SQL Server};UID=YourUserName;password=YourPassword;DATABASE=YourDatabaseName;SERVER=127.0.0.1"
I'm no expert on the subject but I think if a line like that were to replace the line you have, and then have a mySQL database instead of an Access database then it should work.

Remember, I'm no expert - that line is copied from my shopping cart software that uses ASP, VBscript and mySQL.  It should give you an idea as to what to look for.  Also, go check out www.ASP101.com - great ASP forum!
Logged
CPerryWebRat
Space Explorer
***
Offline Offline

Posts: 6


WWW
« Reply #3 on: March 14, 2003, 10:24:00 AM »
quote:
Originally posted by Navodyne:
I don't think you will have to recode the page because ASP and VBscript will work with mySQL - you just have to replace your line with something like this:

code:
Driver={SQL Server};UID=YourUserName;password=YourPassword;DATABASE=YourDatabaseName;SERVER=127.0.0.1"
I'm no expert on the subject but I think if a line like that were to replace the line you have, and then have a mySQL database instead of an Access database then it should work.

Remember, I'm no expert - that line is copied from my shopping cart software that uses ASP, VBscript and mySQL.  It should give you an idea as to what to look for.  Also, go check out www.ASP101.com - great ASP forum!
Logged
CPerryWebRat
Space Explorer
***
Offline Offline

Posts: 6


WWW
« Reply #4 on: March 14, 2003, 10:27:00 AM »
I just signed up - I didn't even think about the Access database which is all I have used
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: