Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2008-10-24
7
Medium Priority
?
166 Views
Last Modified: 2013-11-07
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
Comment
Question by:bschave2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 13

Expert Comment

by:TechTiger007
ID: 22799144
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
 

Author Comment

by:bschave2
ID: 22799187
the database is on a separate server, so it points to the same server. I will find out about the mysql client.
0
 

Author Comment

by:bschave2
ID: 22799301
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
Interactive Way of Training for the AWS CSA Exam

An interactive way of learning that will help you visualize core concepts so that you can be more effective when taking your AWS certification exam.  Built for students by a student to help them understand the concepts that they are being taught.

 
LVL 13

Accepted Solution

by:
TechTiger007 earned 2000 total points
ID: 22799479
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
 

Author Comment

by:bschave2
ID: 22799887
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
 

Author Comment

by:bschave2
ID: 22812661
the exception is not being thrown while connecting to the database. I don't know what else the issue could be.
0
 

Author Closing Comment

by:bschave2
ID: 31516499
the issue wasn't the database, it was something else. I am awarding you credit for helping.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question