Connect to MySQL works on Mac standalone and not on PC
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Connect to MySQL works on Mac standalone and not on PC
I was ready for compiling a test app finally. Made a standalone for Mac and PC. All database use works flawlessly on Mac. Nothing at all happens on PC, no errors, or connection "answer". I basically follows this code.
http://lessons.livecode.com/m/4071/l/70 ... l-database
Thanks for suggestions of where to start
http://lessons.livecode.com/m/4071/l/70 ... l-database
Thanks for suggestions of where to start
Re: Connect to MySQL works on Mac standalone and not on PC
I would start with checking the database connection parameters.
Then the Windows firewall.
Then the Windows firewall.
Re: Connect to MySQL works on Mac standalone and not on PC
Ok windows firewall seems like it could be the problem. As a side note current version isn't signed as a verified publisher and Windows firewall prevented one of my friends from downloading it (didn't even give him an option). Can I please ask what you mean by check DB connection parameters?
Re: Connect to MySQL works on Mac standalone and not on PC
I disabled my firewall on PC and I get the same results.
Re: Connect to MySQL works on Mac standalone and not on PC
I had a friend with a mac download this and the application doesn't work on macs either. Apparently the application is only connecting or attempting to connect on the computer it was made on.
-
- VIP Livecode Opensource Backer
- Posts: 9802
- Joined: Sat Apr 08, 2006 7:05 am
- Location: Los Angeles
- Contact:
Re: Connect to MySQL works on Mac standalone and not on PC
Are you using a full path to the database file?
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
-
- VIP Livecode Opensource Backer
- Posts: 858
- Joined: Wed Jun 24, 2009 1:17 pm
- Location: Plymouth, UK
- Contact:
Re: Connect to MySQL works on Mac standalone and not on PC
Hi Jordy - it may be due to something happening on the server. I don't know why they keep that lesson on connecting directly to a remote MySQL - much more secure etc to have your app talk to a .lc (or php) web service on the server, and let that connect to the db.
Are you by any chance connecting to an on-rev service or other shared account? If so then in cPanel go to 'Remote MySQL' and try adding the ip of where your windows machine is at as well as your friend with the mac...
Are you by any chance connecting to an on-rev service or other shared account? If so then in cPanel go to 'Remote MySQL' and try adding the ip of where your windows machine is at as well as your friend with the mac...
"...this is not the code you are looking for..."