We help IT Professionals succeed at work.

HELP!!!  "Database Connection Error" with an app that using MYSQL

Hi, I have a program that uses MYSQL for its database.  If I execute the program locally on the server it seems to come up just fine.  However, if I try to execute it remotely using a shortcut with a mapped drive to the program on the server from a desktop (Windows XP Pro or Windows 7), it gives me error messages.

-----------------------------------------------------------------------------------------------------------------
First error message: Database Connection Error [SQL Error: Can't connect to MySQL server on 'localhost' (10061)]

Second error message: The exception unknow software exception (0x0eedfade) occurred in the application at location 0x7c812afb.

Third error message: The instruction at "0x01d06d30" referenced memory at "0x00000000".  The memory could not be "read".

Fourth error message: The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c812afb.

Fifith & final error message: The instruction at "0x01768e20" referenced memory at "0x00000000". The memory could not "read".
-----------------------------------------------------------------------------------------------------------------

I tried turning off the firewall and even uninstalling the antivirus/antispyware software and it still does not work remotely.

Only other thing I can think of is that the software needs a patch or something.

I did perform a few Microsoft Updates on the Server 2008 Standard 32-bit OS.  But not sure how that will effect the app.

Everything else seems to be working just fine.

Any ideas or suggestions of what else I should look at?


Thanks in advance.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
> First error message: Database Connection Error [SQL Error: Can't connect to MySQL server on 'localhost' (10061)]

If you're running it from a remote machine, localhost won't work anymore - it needs to connect to <remote machine>:<port 3306>.  So you probably are not going to be able to do this with a shortcut, because it needs to run differently from your remote machine than it does locally.
Maybe the application can receive a parameter, that way you can have the shortcut send some parameter and the link from the localhost a different one.
David Johnson, CDSimple Geek from the '70s
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
or set a static ip for the sql server and replace localhost with the ip address
IT Manager
Commented:
OK, apparently, I wasn't given all the information on this.  The client's run an app on their desktops, which I thought it was just a shortcut pointing back to the exe on the server via a mapped network drive.

So, the issue was that one of the exe files became corrupted.  It is suppose to be 400+ kb in size, but was actually 1kb.

Thanks for all your suggestions.
rsnellmanIT Manager

Author

Commented:
This is the answer.  An exe file was corrupted, which caused the issue.  The file has been replaced and everything is working as before.

Thanks.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.