I just tried setting up snitz on a linux server with sun one asp, mysql version is 5.0.26 and I used connection string: strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=mysql2.namesco.net;user=username;password=password;DATABASE=db_name;" '##MySQL w/ MyODBC v3.51
and get the error: The database could not be opened !! Check your config.asp file and set the strConnString so it points to the database. Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description : SQLState: S Native Error Code: 1251 [TCX][MyODBC]Client does not support authentication protocol requested by server; consider upgrading MySQL client
Being a complete idiot I need help getting around this, it's only recently my server has started supporting asp so I would love to try this forum software. Database is setup but it's never been used on anything before.
Topic Locked
Posted - 18 November 2006 : 12:22:13
