I have finished my ASP.Net/MySQL 5.0 application on my development machine. I am now ready to move it to our server. We do not currently have MySQL installed on our web server, so I figured I'd go through the motions of getting everything installed and running on my laptop. That way I would know what sort of problems I'm going to run into, so when I install it on our actual server, I'll know how to take care of everything. Plus, I need this on my laptop anyway, for when I'm away.
So, I installed MySQL 5, the .Net connector, backed up my database, and restored it on my laptop. I was using the MySQL Administrator (visual) to do the backup/restore. It had a problem with the stored procedures, so I just saved it out to a .sql file, and executed them on my laptop (I only have two stored procedures). I am also using a different port on my development machine 3307. I know the default port is 3306. I have made sure that I've edited my connection string to account for this difference. I have also unblocked that port in the firewall on my laptop. I know it's working, because I can hook in with MySQL Query Browser, or the MySQL Command prompt, and do what ever I want. It works just fine. Here's what's happening. When I try to connect, it just seems to freeze. I've made sure that I've created the user name as well. Here is my connection code: function OpenConn AS MySqlConnection Dim cConnStr as String cConnStr = "uid=myid;password=mypw;Server=localhost;port=3306;Database=mydatabase;" OpenConn = New MySqlConnection(cConnStr) OpenConn.Open() end function This works just fine on my development machine (the port being changed to 3307 there, of course), but on my laptop machine, when I execute this, I just get a progress bar at the bottom, and a never ending blank screen. My Laptop is running Windows XP Pro. I have McAfee Virus scanner installed, but it doesn't have a firewall on it. I'm using the Windows Firewall, but as I've explained, I've set that to allow port 3306 through. I have also gone in and created an application in IIS for my program. I've also copied the MySql.Data.dll file into my bin folder in my application. I think I've done everything I need to, but obviously not. Any ideas? Thanks, Jesse
