Hi, could anyone help. We have been trying to test the database connection using asp to mysql but without success. The error message obtained is as follows:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable
to complete your request.

The scripts applied is as follows:
<%@ Language=VBScript %>
<%
dim con,rs
set con=server.CreateObject("ADODB.Connection")
set rs=server.CreateObject("ADODB.Recordset")
 
con.Provider = "MySQLProv"
con.Properties("Data Source") = "server=pegasus.lunarpages.com;DATABASE=databasename here;UID=useridhere;PWD=userpasswordhere"
con.Open
 
sql = "SELECT * from new_member_list"
 
rs.Open sql, con, 3, 1
Response.Write  rs.RecordCount
rs.Close
 

%>



If you have working test scripts to share, will be greatly appreciated!@!

Try this:

for your, "Driver" it should be {mySQL} and your server I don't think is pegasus.lunarpages.com but localhost.  You can pretty much cut and paste the code below.... just change the other things such as the database name, userid,.. et.



%>
dim con,rs

set con=server.CreateObject("ADODB.Connection")
set rs=server.CreateObject("ADODB.Recordset")

Con.Open "Driver={mySQL}; Server=localhost; Database=hereyourdatabase; uid=hereyouruserid; password=hereyourpass"


      sql = "select * from new_member_list"
      response.write sql
%>

Good Luck!

Hello Brian,
  It would go in any page that is going to need a connection, or you can put the string in a common include.