Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 MySQL problem		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

BrokenSockets
Starting Member

Canada
4 Posts
Posted - 31 July 2008 :  09:41:18  Show Profile
Trying to do Setup ASP with MySQL DB

I get this error:

SQLState: S Native Error Code: 1251 [TCX][MyODBC]Client does not support authentication protocol requested by server; consider upgrading MySQL client

WTF?

<moved from="Help: General / Current Version (v3.4.xx)" by="AnonJr" /><
Edited by - AnonJr on 31 July 2008 10:05:25

AnonJr
Moderator

United States
5768 Posts
Posted - 31 July 2008 :  10:06:22  Show Profile  Visit AnonJr's Homepage
I'm not an expert on MySQL, but my first question would probably be which version of MyODBC is installed on the MySQL server?<
Edited by - AnonJr on 31 July 2008 10:06:44
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 31 July 2008 :  10:44:00  Show Profile  Send ruirib a Yahoo! Message
What connection string are you using?<

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

BrokenSockets
Starting Member

Canada
4 Posts
Posted - 31 July 2008 :  12:05:41  Show Profile
I don't know re: version of MyODBC - I am attempting to add forums to my site at my service provider. I have a sql db already set up and am trying to connect to it. They have mysql with phpmyadmin to access settings. version says 5.0.51a-community

The conneciton string I am using is
strConnString = "driver={MySQL ODBC 3.51 driver};option=16387;server=localhost;user=xxxxxxx;password=xxxxxxx;DATABASE=xxxxxxxx;" '##MySQL w/ MyODBC v3.51

Any pointers in the right direction would be much apreciated

Thanks<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 31 July 2008 :  12:21:52  Show Profile  Send ruirib a Yahoo! Message
Seems like the issue is not related to anything you're doing. You will need to contact your hosting provider and let them know about the error message.<

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

BrokenSockets
Starting Member

Canada
4 Posts
Posted - 31 July 2008 :  18:05:58  Show Profile
Still working with my hosting provider, so far they suggested trying a different password - not useful

Anyone encounter this problem before?<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 31 July 2008 :  18:12:12  Show Profile  Send ruirib a Yahoo! Message
Either the host makes sure they are using latest MyODBC version or follow the advice here regarding passwords:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html<

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

BrokenSockets
Starting Member

Canada
4 Posts
Posted - 03 August 2008 :  08:03:47  Show Profile
My hosting company updated the server where my site was located - all is now well - Thanks for the support and input!<
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 03 August 2008 :  08:12:37  Show Profile  Send ruirib a Yahoo! Message
Glad it's all working now .<

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07