[thelist] MySQL Drivers on Win2K
Michael Pemberton
evolt at mpember.net.au
Sat Jan 15 23:45:32 CST 2005
Michele Foster (WizarDev) wrote:
> Set cnn = Server.CreateObject("ADODB.Connection")
>
> cnn.Open "Driver={MySQL ODBC 3.51
> Driver};Server=megasqlservers.com;" &_
> " DATABASE=rhf_letshookrugs_com;" &_
> " UID=dbm.letshookrugs.com;PWD=yadda;option=3;"
These two lines have different usernames
> Which results in this error locally:
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [MySQL][ODBC 3.51 Driver]Access denied for user:
> 'dbm.letshookrugs at ip216-239-89-117.vif.net' (Using password: YES)
>
It looks like the ".com" is being dropped in the process of the
connection being made. I would suggest looking into having a shorter
username that does not contain any punctuation.
HTH
--
Michael Pemberton
evolt at mpember.net.au
More information about the thelist
mailing list