| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 26 April 2007 : 16:24:17
|
You really need to ask them if they can explain what causes the error message. If they are supposed to know anything about what they are doing, they should be able to explain it. If they don't... well, you draw your own conclusion.
My personal opinion is that, most times, they don't have a clue about what is going on and they are just able to repeat typical recommendations! |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
mdj101
Starting Member
21 Posts |
Posted - 02 May 2007 : 22:14:24
|
OK, My first post here and hopefully a usefull one.
The reason you are getting the error is because the connection string is wrong.
It should be...
strConnString = "DRIVER={MySQL ODBC 3.51
Driver};OPTION=16387;SERVER=[myserver];DATABASE=[mydatabase];user=[myuser];password=[mypassword];"
NOT...
strConnString = "DRIVER={MySQL ODBC 3.51
Driver};OPTION=16387;SERVER=[myserver];user=[myuser];password=[mypassword];DATABASE=[mydatabase];"
MySQL needs to see the database before you ask it to connect using your username and password, this is why the error was saying that it couldnt even see a database let alone connect to it.
Hope this helps many of you. |
Regards.
Mark
buy retail fireworks |
Edited by - mdj101 on 02 May 2007 22:15:56 |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 03 May 2007 : 09:12:02
|
quote:
Originally posted by mdj101
OK, My first post here and hopefully a usefull one.
The reason you are getting the error is because the connection string is wrong.
It should be...
strConnString = "DRIVER={MySQL ODBC 3.51
Driver};OPTION=16387;SERVER=[myserver];DATABASE=[mydatabase];user=[myuser];password=[mypassword];"
NOT...
strConnString = "DRIVER={MySQL ODBC 3.51
Driver};OPTION=16387;SERVER=[myserver];user=[myuser];password=[mypassword];DATABASE=[mydatabase];"
MySQL needs to see the database before you ask it to connect using your username and password, this is why the error was saying that it couldnt even see a database let alone connect to it.
Hope this helps many of you.
Oh my goodness - if that really is the case, that may save so many people so much frustration (and the driver deserves a slap!). Thanks for posting. If anyone verifies this for their own setups, could they post the confirmation here? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 03 May 2007 : 09:50:58
|
| I'd think if that was the issue all those MySQL installs floating around would have failed miserably from the get-go and we would have found it sooner... but, I have seen stranger things. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 May 2007 : 10:24:14
|
quote:
Originally posted by AnonJr
I'd think if that was the issue all those MySQL installs floating around would have failed miserably from the get-go and we would have found it sooner... but, I have seen stranger things.
I know that's not an issue. I am sure of it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 03 May 2007 : 10:44:16
|
That was intended a semi-sarcastic, more light-hearted second to what you'd said.  |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 03 May 2007 : 11:08:10
|
| It did seem somewhat unlikely, named parameters passed in a string, so glad that's debunked! |
|
|
|
mdj101
Starting Member
21 Posts |
Posted - 09 May 2007 : 19:43:59
|
Well I challenge you to try it on a server running MySQL5 and the 3.51 ODBC Driver!
If it didnt work, change the string and it WILL WORK!
It may not be the way its meant to work, BUT IT WORKS! |
Regards.
Mark
buy retail fireworks |
|
|
|
mdj101
Starting Member
21 Posts |
Posted - 09 May 2007 : 19:45:42
|
| INFACT! if you want to see the difference i can always show you on my server. |
Regards.
Mark
buy retail fireworks |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 May 2007 : 21:11:55
|
quote:
Originally posted by mdj101
Well I challenge you to try it on a server running MySQL5 and the 3.51 ODBC Driver!
If it didnt work, change the string and it WILL WORK!
It may not be the way its meant to work, BUT IT WORKS!
Well, I have it working on my server, several DBs, several forums, MySQL 5.0.19, 3.51 driver and it works no matter the order of the parameters. I usually test stuff before stating anything regarding something I haven't tested before. I actually tested this before posting, or I wouldn't even have posted it at all.
Again, I repeat. It doesn't even make sense that the parameters have any specific order, that's why they are named, otherwise the names wouldn't be needeed. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
mdj101
Starting Member
21 Posts |
Posted - 09 May 2007 : 21:53:48
|
Well on my two production Win 2003 servers, I had to change the string to get it to work, if it helps the others on here that have tried everything under the sun to get theirs to work, then so be it!
Bit like the hundreds of people that have problems with the CDOSYS sending emails even though they are using authentication. Changing the authentication string end from basic to 1 like...
Flds("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
Will probably solve all their problems, but maybe I wont bother posting weird solutions, if im going to get flamed! |
Regards.
Mark
buy retail fireworks |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 May 2007 : 01:53:37
|
| Well I help people in many situations and I've helped people using MySQL 5.0 and Windows 2003 and I never needed to resort to this. So, no matter what you say, I never found this needed in several servers respecting your specs: MySQL 5.0 and Windows 2003. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
mdj101
Starting Member
21 Posts |
Posted - 10 May 2007 : 10:24:04
|
| im not saying you haven't, im just saying that it worked for me and it probably will for others, would be nice if some of the others on the forum that were getting the same errors as me tried this fix to see if it worked. |
Regards.
Mark
buy retail fireworks |
|
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 11 May 2007 : 10:57:48
|
Hello everyone  . Let's try to remember Mother's Day is around the corner.
Anyway, had to put my 2 cents in here somewhere... hope its in the right topic.
I started out intending to convert my forum from access to my sql. With the headaches I got attempting such a challenge, I decided to do a fresh install of the current snitz to my sql instead.
I must say, with all the resources of information, instructions and the many members that provide us with on-line help here on this board, I had little trouble installing it! I want to thank this board and its community members for being so supportive with this product!
Anyway, the little trouble I did have was quickly remedied by reading the search topics, asking questions and taking my time. 
Thank you everyone and Happy Mother's Day!!
|
Have a great day!
Terry |
|
|
|
Topic |
|
Topic Locked
