Problem connecting to MySql
I am trying to connect to MySql server from my ASP VB application.
The connection string i use is :
Driver=org.gjt.mm.mysql.Driver;Server=myServerA开发者_开发技巧ddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
The code i use to connect is :
public sub sqlCommand(objCommand, strSqlCommand)
'run query using the command object
set objCommand = server.createobject("ADODB.Command")
response.Write(application("database_connectionstring_external"))
objCommand.ActiveConnection = application("database_connectionstring_external")
objCommand.CommandText = strSqlCommand
objCommand.CommandType = adCmdText
end sub
I am getting error '80004005'
what is the problem in code ? Thanks
Error 80004005 usually means wrong username/password have you checked whether those work manually?
精彩评论