OK, I'm new at this whole php, mysql, connection in vwd thing, so you're going to have make this as idiot-proof as possible.....
http://aspnet101.com/aspnet101/tutorials.aspx?id=39 and
http://www.15seconds.com/issue/050210.htm
both appear to take me to some kind of error page for "Server Error in '/' Application." I haven't the foggiest notion what to do with that information.
http://www.sqlstrings.com/mysql-asp.net-connection.htm
takes me to a page that talks about connecting, tells me to do some things I've already done, and SAYS the asp.net code below shows the connection...
Except the area is empty. no code. no nothing........
The other link takes me to a place that actually has a connection:
I have mySql. I have the driver. I have the database set up. I have data (this is all stuff I know how to do)...
Then we get to what it says is the easy part... except that...
<%@ Import Namespace="System.Data.ODBC" %> ---- I'm guessing this line goes in my html file above the <html> tag?
but where do I need to put
"Driver={MySQL ODBC 3.51 Driver};uid=YourUID;password=YourPWD;Server=YourServerIP;Option=16834;Database=YourDB;"
or, you can use:
"DRIVER={MySQL};SERVER=ServerIP; DATABASE=YourDB;USER=YourUID;PASSWORD=YourPWD; OPTION=3;"
and are there html tags I need to use for this? And do I use it exactly as:
DRIVER={MySQL}; SERVER=localhost; DATABASE=salondb;USER=myusername;PASSWORD=mypwd; OPTION=3;
'cause so far, everywhere I've stuck this line in the file, the test shows up on the web page...
More info please...