setting up MyODBC to connect to MySQL, need help....

http://www.devarticles.com/c/a/ASP/Using-MyODBC-To-Access-Your-MySQL-Database-Via-ASP/

Decent article for what you want.

thanks for the article...i read through it and got everything setup until i reached the user name and password portion. it says to run the winmysql.exe under the bin folder but i do not have that file and cant find it anywhere. the exact version of mysql is 4.1.12a-win32 so i figure that file shouldve been extracted to that folder upon install, correct? please let me know how to obtain this file because thats the step i cant get past is the user name and password. when i setup mysql on the server, it used mysqladmin as the root user but thats not working. thanks for the help!

This is a windows admin utility.

THis should have installed when you instaleld mysql.

it is under the c:\mysqlroot\bin\ directory.

i think what happened is i downloaded the stripped down version of mysql that all it gave me was a cmd line interface with no GUI. any ideas of where i can download the full version? every site i've gone to has zip files that download and cant open because of invalid zip files, and only show as 547B....and its supposed to be around 40Mb. any help would be appreciated! thanks!

I would think you would have done the same thing, but I started by going to www.mysql.org. I clicked downloads, scolled down to the full Windows Installer...ended up at this mirrors page.
http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.12a-win32.zip/from/pick#mirrors
I selected the top in the list for me--which was FTP from a Chicago, IL server. Downloaded in a few seconds. I unzipped, and it was a single Setup.exe file of 38.8MB.

http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.12a-win32.zip/from/pick#mirrors

Take your pick from the mirrors form link pasted before this one..

They work.. and install just fine.. just tested myself.

ok, i must be missing a step then or installing this incorrectly....i used that site to download from, the first time i downloaded it, i used the "without install" package which is y i said i downloaded the stripped version. so then i went back and downloaded the full package which was 38mgs. i extracted that fine, ran the setup file, configured it using the instance config program, set it to minimum usage because other applications are on that server, enabled tcp/ip port so others can query information from client machines, 10 users, created the root account, which should be mysqladmin by default, gave it a password.

finished the install, it started the services, a DB was created inside it, i search for the winmysql.exe file and its nowhere to be found?? myodbc was downloaded and installed as well, i go to the system dsn tab to add it, the login tab asks DSN, description, server, user, pw, and DB....i add those in on the local server and use loopback for server, and the default root admin and pw and that doesn't work....i also type the db that was created.

if you have anymore ideas of where i went wrong or how to obtain that winmysql.exe file, that would be very much appreciated....thanks!!

Try this instead:

http://dev.mysql.com/downloads/administrator/1.0.html

thanks for the link....i did download it and install it but i also re-ran the instance config wizard and took out the create security option all together which somehow allowed me to connect locally with no security and with root and pw from remote machine <<shrug>> but it so far seems to be connecting.

thank you guys so much for your help!! and i will post up again if i run into more issues.

Yes the default will have no root pw you need ot set one.