Need help connecting to a MySQL database with ASP.

It looks like you should change this:
SERVER=h41mysql1.serverurl.net;
to
SERVER=acct.ipowermysql.com;

Also, the single quote in front of a line means it has been commented out and can be ignored.

It's been awhile since I worked with ASP but perhaps it's the &_ ( I believe this is to include the next line.)
Perhaps try this on one line:
Conn.Open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=acct.ipowermysql.com; PORT=3306; DATABASE=dbname; USER=username; PASSWORD=*password*;OPTION=3;"

it has been a while since i touched asp but there is one thing that is the same in asp/asp.net/and .net winforms.

&_

should have a space between them. so: & _

if that does not work, put it as one single line instead.

Hi Mark,

What you have there is some darn klutzy ASP code.

Microsoft moved from ASP to ASP.Net ten years ago. Is there a good reason to keep this thing in old-school ASP instead of moving into the current century?

As Kirk mentioned, a single quote at the start of a line indicates comments. The developer should have entirely removed, rather than commenting out, the junk that was no longer needed, such as the alternative Conn.Open lines for different servers.

Conn.Open takes a string. I like to build the string first, then pass it to Conn.Open. And to build the string, I like to refer to constants that I group together so the code is easy to maintain:

' database access constants
const dbServer = "acct.ipowermysql.com"
const dbPort = "3306"
const dbUser = "userNameGoesHere"
const dbPass = "passWordGoesHere"
const dbDatabase = "dataBaseNameGoesHere"
const dbDriver="{MySQL ODBC 3.51 Driver}"
const dbAppend = "OPTION=3";

dbConn = "DRIVER=" & dbDriver & ";"
dbConn = dbConn & "SERVER=" & dbServer & ";"
dbConn = dbConn & "PORT=" & dbPort & ";"
dbConn = dbConn & "DATABASE=" & dbDatabase & ";"
dbConn = dbConn & "USER=" & dbUser & ";"
dbConn = dbConn & "PASSWORD=" & dbPass & ";"
dbConn = dbConn & dbAppend
' should really get saved as a global variable in the Application object

conn.Open dbConn

The next problem is why the database connection is opened two different places. There should be exactly one function in the code that encapsulates opening the database, and it should be in a library that's separate from both your GUI code and your business rules.

But the real problem is why to use the obsolete and very, very limited ASP environment rather than moving on to ASP.Net, which makes this kind of configuration so much easier (if people know what they're doing).

Chris

i think no direct connection is available for asp/mysql like php/mysql. but you can connect through ODBC . I have dont that few years ago. But why ASP yet? use php or .net

anyway thanks