• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

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!
0
bschave2
Asked:
bschave2
  • 5
  • 2
1 Solution
 
TechTiger007Commented:
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
0
 
bschave2Author Commented:
the database is on a separate server, so it points to the same server. I will find out about the mysql client.
0
 
bschave2Author Commented:
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.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
TechTiger007Commented:
so you have mysql client in the server.
Can you add a try catch block  where your application is trying to connect to database and find out what is the exception thrown. Since you have not handled the exception it says Unhandled exception
0
 
bschave2Author Commented:
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.

0
 
bschave2Author Commented:
the exception is not being thrown while connecting to the database. I don't know what else the issue could be.
0
 
bschave2Author Commented:
the issue wasn't the database, it was something else. I am awarding you credit for helping.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now