| Author |
 Topic  |
|
Shaggy
Support Moderator
Ireland
6780 Posts |
 Posted - 21 September 2006 : 10:41:44
|
Please edit your post to remove the contents of your file, replacing them with a link to a *.txt copy of the file instead.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 10:42:47
|
please try to follow instructions, we are not interested in your entire config file !
as previously asked, have you tried using your connection string from your working forum ? on this update |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 10:43:15
|
quote:
Originally posted by Shaggy
Please edit your post to remove the contents of your file, replacing them with a link to a *.txt copy of the file instead.
I already removed it Shaggy  |
|
|
|
Adjunkten
Starting Member
30 Posts |
Posted - 21 September 2006 : 12:15:01
|
quote:
Originally posted by HuwR
as previously asked, have you tried using your connection string from your working forum ? on this update
No. As previously stated I would like to go back to v. 3.4.05, but I can't find the download. I deleted my old version entirely, as I needed to start all over with new members.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 12:21:54
|
obviously we would prefer to get you up and running with the new version
ok, the old MySQL connection string was like his
strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50
could you try that and see if it connects to your database, if not please let us know what error it gives |
|
|
|
Adjunkten
Starting Member
30 Posts |
Posted - 21 September 2006 : 12:39:04
|
I'm back to the beginning!
The forum connects succesfully and I get the type mismatch error in statistics....
Microsoft VBScript runtime error '800a000d'
Type mismatch
/forum2/default.asp, line 923
DOH! :-) |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 13:11:31
|
ok, that's good so far, if we do this a step at a time we will have it figured out
Now, step2, if you replace that line with the new one
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;"
what do you get, does it revert back to the can't find your db error |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 13:12:49
|
| It may help here if you could find out from your host what version of MySQL they are running as well as the version of the myODBC driver they are using |
|
|
|
Adjunkten
Starting Member
30 Posts |
Posted - 21 September 2006 : 13:16:36
|
Yes!
"Code : 80004005
Error Description :
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 13:25:41
|
| OK, do you know what version of MySQL and myODBC are being used ? |
|
|
|
Adjunkten
Starting Member
30 Posts |
Posted - 21 September 2006 : 13:34:24
|
Problem solved! I added the 'option=16387' thing to the old connectstring. Maybe there's no myODBC-driver on my server - ?
String that works for me:
strConnString = "driver=MySQL;option=16387;server=(url);uid=(user);pwd=(pass);database=(name)" '## MySQL w/ MyODBC v2.50
- thanx for your time. |
Edited by - Adjunkten on 21 September 2006 13:36:07 |
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 21 September 2006 : 13:42:58
|
excellent that was going to be my next suggestion, seems your server is using the old myODBC version.
let us know if you encounter any other problems. |
|
|
|
cobrachen
Starting Member
48 Posts |
Posted - 26 April 2007 : 13:17:33
|
I am not familiar with MySQL and I am in the middle to move my current
forum from one hosting service to another. I also want to convert the
database to use MySQL.
The new hosting service provides MySQL 4.1 and 5. The ODBC driver is
3.51. I used the connection string they provided for ASP-ADO
connection which was:
strConnString = "DRIVER={MySQL ODBC 3.51
Driver};OPTION=0;PORT=3306;SERVER=p41mysql11.secureserver.net;user=XXXX;password=######;DATABASE=QQQQQQQ;"
Then I tried to run an ASP page to connect to this existing empty
database, I received an error message:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client
Since the ASP page was uploaded to the hosting server, the database
was over there, too. So, there was no client connection established
from my computer. I made changes to the OPTION with either 0, 4 or
16387 (I copied this number from another place) and none of them
worked.
I talked to the customer support but they could not help me. I did
search with google regarding this error and most of them I checked hadsomething to do with upgrade MySQL and password encryption changed.However, this is a brand new database and no old password involved.
The same error also returned whether I created a database in 4.1 or 5 version.
Hopefully you could help me with some clues. If you need more
information, please let me know.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 26 April 2007 : 15:54:26
|
The client is the web server not your computer, so it's the task of your host to fix the issue.
You will need to use option=16387 for the forum to work with MySQL 4, but that won't stop you from connecting to the server. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
cobrachen
Starting Member
48 Posts |
Posted - 26 April 2007 : 16:13:22
|
quote:
Originally posted by ruirib
The client is the web server not your computer, so it's the task of your host to fix the issue.
You will need to use option=16387 for the forum to work with MySQL 4, but that won't stop you from connecting to the server.
Thanks for your reply. This came from GoDaddy's hosting service and I talked to their customer support team twice last night and they said the server side worked fine (of course it worked fine, that's how I created the database).
Any suggestions that I could pursade them to double check the settings? I really do not believe I am the only and first one tried to connect to MySQL from ASP page.
Thank you very much. |
|
|
|
Topic |
|
Topic Locked
