Min asp kode vil ikke connecte til mysql database?
Hej.Jeg har et progblem med min kode, og det er hvis jeg trykker på submit knappen kommer den med denne fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/add_table.asp, line 36
Og det er min kode:
<%
step = Request.QueryString("step")
x_server = "localhost:3306"
x_database = "testing"
x_username = "root"
x_password = "root"
%>
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US">
<head>
<title> Add table </title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="title" content="" />
<meta name="author" content="" />
<meta name="subject" content="" />
<meta name="language" content="" />
<meta name="keywords" content="" />
</head>
<body>
<%
if step= "" then
Response.Write("<form method='post' action='add_table.asp?step=1'>")
Response.Write("Table navn: <input type='text' name='tablename' /><br />")
Response.Write("<input type='submit' />")
Response.Write("</form>")
end if
if step= "1" then
Set con = Server.CreateObject("ADODB.Connection")
con.Open "Driver={MySql};Server=" & x_server & ";Database=" & x_database & ";UID=" & x_username & ";PASSWORD=" & x_password & ""
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "CREATE DATABASE `" & Response.Form("tablename") & "` ;",con
rs.Close
Set rs = Nothing
Response.Redirect("add_table.asp?step=2")
conn.Close
end if
if step = "2" then
Response.Write("Databasen " & Response.Form("tablename") & " er lavet")
end if
%>
</body>
</html>
Jeg håber at der er en som kan hjælpe.
