Snitz Forums 2000 - ASP Create MySql Database

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

ASP Create MySql Database

New Topic

Topic Locked

Printer Friendly

Author

Topic

DarkDrift
Junior Member

USA
126 Posts

Posted - 11 March 2005 : 21:49:38

I am trying to connect to mysql qith myODBC and then Create a Database. Some code that i have is

my_conn2.open "driver={MySQL ODBC 3.51 Driver};option=4;server=" & Request.Form("db_host") & ";user=" & Request.Form("db_root") & ";password=" & Request.Form("db_pass") & ";"
strsql = "CREATE DATABASE '" & Request.Form("db_name") & "'"
my_conn.execute(strsql)
my_conn2.close
set my_conn2 = nothing
set my_conn2 = Server.CreateObject("ADODB.CONNECTION")
my_conn2.open "driver={MySQL ODBC 3.51 Driver};option=4;server=" & Request.Form("db_host") & ";user=" & Request.Form("db_root") & ";password=" & Request.Form("db_pass") & ";DATABASE=" & Request.Form("db_name") & ";"

That just simply doesn't work i get a nice fat err the error is an error has occured around '*WHATEVER DB_NAME WAS*' .....

Kinda stumped thanks for any help anyone can provide

http://www.xcalliber.com - The Future of Boards

Gremlin
General Help Moderator