how to use SQLConfigDataSource to create a User DSN of mysql 5.1

[rolfk]

---

patchchen wrote:

hi, rolf

thanks your reply

as you said : You need to add an extra \00 at the end!

is that mean:

DSN=aa\00SERVER=localhost\00UID=patch\00PWD=patch\00DATABASE=bbb\00\00

if is yes, it still not work.

actually I checkd those parameters couple times before,and this time I do it again and show you the result, please check the picture file.

I can use the same parameters to created a ODBC driver by manually.

thanks

patch

---

Well I can't help anymore. Just one thing. If you have specified already a DSN with that name it might just as well fail because of that!

Rolf Kalbermatter

[patchchen]

hi,rolf

thank you very much, you indeed help me a lot.

this problem still not solve, hope anybody could help.

thanks

patch

[rolfk]

---

patchchen wrote:

hi,rolf

thank you very much, you indeed help me a lot.

this problem still not solve, hope anybody could help.

thanks

patch

---

One extra remark! There needs at least an extra parameter "DRIVER=<whatever>" in that string. How should ODBC otherwise know how to invoke the corrrect database driver for your database?

Best is to simply create such a DSN entry with the ODBC Wizard and then look in the registry for the various parameters this DSN has to use.

Rolf Kalbermatter

Message Edited by rolfk on 05-21-2009 08:17 AM

[patchchen]

hi, rolf

thanks your reply

you mean I should need to confirm the "DRIVER" name? I guess the driver name is "MySQL ODBC 5.1 Driver", because I use mysql 5.1 and many person thought should to use this who in the internet. so I always used in my program, please see the red circle on the attached file.

of course I had checked those registry parameters entirely before.

is that right? if I mistake your meaning please explain more clearly.

thanks

patch