Link to home
Start Free TrialLog in
Avatar of bschave2
bschave2

asked on

app will connect to mysql db on local, but not on the server it was moved to

I have a vb.net app built in visiual studio 2005  and this app hit's the mysql db fine on my local machine. I put this application into test on a microsoft 2003 server and then was moved to another server for specific reasons and worked fine on the other server. When the app got moved to another microsft 2003 server, I keep getting a 'Exception of type 'System.Web.HttpUnhandledException' was thrown' everytime the application tries to connect to the mysql db. The drivers on the server are odbc 3.51 and 5. Also there is no dns. what could be the issue. If you need sample code or anything from me just ask.

Thanks in advance!
Avatar of Toms Edison
Toms Edison
Flag of India image

1. Have you modifed the connection string to point to new database?
2. Do you have mysql client component installed in the server where your application is running? You can download it from mysql web site
Avatar of bschave2
bschave2

ASKER

the database is on a separate server, so it points to the same server. I will find out about the mysql client.
there are multiple clients I believe mysql5, 5.1, and 5.2. the mysql.data.dll file in my bin is version 1.0.10.1.
ASKER CERTIFIED SOLUTION
Avatar of Toms Edison
Toms Edison
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have to have the tech update the files in test. I added error handling, so I will know in a little while, what the issue was specifically.

the exception is not being thrown while connecting to the database. I don't know what else the issue could be.
the issue wasn't the database, it was something else. I am awarding you credit for helping.