Hello Alan,

Thanks for your comments

    MyODBC 3.51 has not been setup, just installed.

    I am using ADO 2.6 with myOdBC as its driver. if the UID & PWD are
    removed from the connection string it works ok

    Also the connection Property("User ID") is empty

    if the property is set to a fictitious user before opening.
    cnn.Properties("User ID") = "rthur"

    it works ok

    Whenever a password is set it just gives the error

    cnn.Properties("password") = "fred"
  

sql,query
-- 
Best regards,
 Arthur                          mailto:[EMAIL PROTECTED]


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to