[thelist] MySQL Drivers on Win2K

[Michael Pemberton]

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