Connect to MySQL works on Mac standalone and not on PC

Deploying to Windows? Utilizing VB Script execution? This is the place to ask Windows-specific questions.

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
Jordy
Posts: 32
Joined: Sat Feb 27, 2016 3:59 am

Connect to MySQL works on Mac standalone and not on PC

Post by Jordy » Sun Jun 05, 2016 4:01 am

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

SparkOut
Posts: 2839
Joined: Sun Sep 23, 2007 4:58 pm

Re: Connect to MySQL works on Mac standalone and not on PC

Post by SparkOut » Sun Jun 05, 2016 8:56 am

I would start with checking the database connection parameters.
Then the Windows firewall.

Jordy
Posts: 32
Joined: Sat Feb 27, 2016 3:59 am

Re: Connect to MySQL works on Mac standalone and not on PC

Post by Jordy » Sun Jun 05, 2016 2:51 pm

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?

Jordy
Posts: 32
Joined: Sat Feb 27, 2016 3:59 am

Re: Connect to MySQL works on Mac standalone and not on PC

Post by Jordy » Sun Jun 05, 2016 8:09 pm

I disabled my firewall on PC and I get the same results. :(

Jordy
Posts: 32
Joined: Sat Feb 27, 2016 3:59 am

Re: Connect to MySQL works on Mac standalone and not on PC

Post by Jordy » Wed Jun 08, 2016 11:32 pm

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.

FourthWorld
VIP Livecode Opensource Backer
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

Post by FourthWorld » Wed Jun 08, 2016 11:47 pm

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

dave.kilroy
VIP Livecode Opensource Backer
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

Post by dave.kilroy » Thu Jun 09, 2016 10:52 am

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...
"...this is not the code you are looking for..."

Post Reply

Return to “Windows”