Alpha Video Training
Results 1 to 8 of 8

Thread: Just loaded Access MDB to Mysql & changed Connection String - WOW

  1. #1
    Member
    Real Name
    Bob Alston
    Join Date
    Feb 2012
    Location
    Dallas
    Posts
    180

    Lightbulb Just loaded Access MDB to Mysql & changed Connection String - WOW

    Just downloaded MySQL, used Bullzip's FREE Access to MySQL conversion utility. Renamed my Access based connection string and created new one with same name as the original and pointed it to MySQL. Republished everything. It works!

    Boy is that slick!
    Bob Alston
    -------------------------------------------------------------------
    http://webpages.charter.net/bobalston/bob1.htm
    Alpha five v11 Tips

  2. #2
    "Certified" Alphaholic kingcarol's Avatar
    Real Name
    Carol King
    Join Date
    Jun 2010
    Posts
    1,536

    Default Re: Just loaded Access MDB to Mysql & changed Connection String - WOW

    I will be so interested to know if there is a significant increase in performance and speed on your grids.
    Carol King
    Developer of Custom Homebuilders' Solutions (CHS)
    http://www.CHSBuilderSoftware.com

  3. #3
    Member
    Real Name
    Bob Alston
    Join Date
    Feb 2012
    Location
    Dallas
    Posts
    180

    Default Re: Just loaded Access MDB to Mysql & changed Connection String - WOW

    My test data right now is very small.

    Bob
    Bob Alston
    -------------------------------------------------------------------
    http://webpages.charter.net/bobalston/bob1.htm
    Alpha five v11 Tips

  4. #4
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,674

    Default Re: Just loaded Access MDB to Mysql & changed Connection String - WOW

    Carol - what issues are you having?
    Insanity: doing the same thing over and over again and expecting different results.
    Albert Einstein, (attributed)
    US (German-born) physicist (1879 - 1955)

  5. #5
    "Certified" Alphaholic kingcarol's Avatar
    Real Name
    Carol King
    Join Date
    Jun 2010
    Posts
    1,536

    Default Re: Just loaded Access MDB to Mysql & changed Connection String - WOW

    Pete, this thread might answer your question.
    http://msgboard.alphasoftware.com/al...age-navigation
    Carol King
    Developer of Custom Homebuilders' Solutions (CHS)
    http://www.CHSBuilderSoftware.com

  6. #6
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,412

    Default Re: Just loaded Access MDB to Mysql & changed Connection String - WOW

    Carol its a massive increase.
    Chad Brown

  7. #7
    "Certified" Alphaholic kingcarol's Avatar
    Real Name
    Carol King
    Join Date
    Jun 2010
    Posts
    1,536

    Default Re: Just loaded Access MDB to Mysql & changed Connection String - WOW

    Chad, did you have experience with using Alpha with Access for awhile, before switching to MySql? If so, did you encounter any issues when migrating from Access to MySql?
    Carol King
    Developer of Custom Homebuilders' Solutions (CHS)
    http://www.CHSBuilderSoftware.com

  8. #8
    "Certified" Alphaholic chadbrown's Avatar
    Real Name
    Chad Brown
    Join Date
    Aug 2007
    Location
    Aurora, Ontario, Canada
    Posts
    1,412

    Default Re: Just loaded Access MDB to Mysql & changed Connection String - WOW

    My access was pretty brief but was a pretty sizeable advantage over dbf's a pretty complicated desktop query went from about 26seconds down to about 3 on access but when i changed to ms sql the query just blinked. Shortly after that I changed to MYSQL for the simple fact that it was easy to install and my mentor new it pretty well. Items that I have online are as fast as a desktop solution.
    Chad Brown

Similar Threads

  1. Broken connection string with MySQL
    By Jay Talbott in forum Application Server Version 10 - Web/Browser Applications
    Replies: 4
    Last Post: 10-17-2011, 03:09 PM
  2. MySQL Connection String help please
    By keelbolt in forum Alpha Five Version 10 - Desktop Applications
    Replies: 1
    Last Post: 05-11-2010, 03:31 AM
  3. MySQL SSL Connection String
    By jdrake in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 04-20-2010, 09:52 AM
  4. Saved connection String with MySQL
    By Dan Blank in forum Application Server Version 9 - Web/Browser Applications
    Replies: 2
    Last Post: 02-20-2009, 12:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •