Sorry, never mind. I found that I had "misspelled" the user name when I
added it back into the database. I had a dash (-) in there when there
shouldn't have been. I removed the dash from the user name and everything
is working great now.
But, I would have expected that MySQL (or the connector, or what ever is
responsible) would have reported "user name unknown" or something to that
affect. But it didn't, I got nothing. If I hadn't spotted this, I could
have been spending hours trying to figure out what was wrong, because I was
not getting an error message when I should have been.
Jesse
----- Original Message -----
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List" <mysql@lists.mysql.com>
Sent: Monday, December 19, 2005 2:15 PM
Subject: Possible Connection Issue
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
