myODBC not found

I have installed mySQL with myODBC  latest version. But it says on the first line of the textbox on the right hand side "not found", but it showed the details of myODBC correctly below it. What is going on? Thanks
Jack
luckieAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HMaxCommented:
Nothing is going on I think...

It says the same thing here, and I don't have a single problem...

If you are talking about WinMySQLAdmin of course.
0
tpwithattitudeCommented:
things that you should check while using myODBC with mySQL
1. check as if it is running as a win-nt service...
even on XP machines if ur running mysql ... you should change the defaults in the ini file...like remove the password and user name from the mySQL Admin thing.
plus you will see something where you can change the orientation of mySQL running... like as mysql-nt something and stuff like that
choose the mysql-nt there for myODBC to work corrently.

Once this is out of the way... go to the ODBC manager and create a new ODBC connection. you will be given a screen to fill out the details.

where there is host name give the name of your PC or try local host or the best thing would be to try the IP.

the username field should be root .. password can be empty.

and make sure that the mySQL server is running. the rest is pretty normal stuff. cheers .
0
luckieAuthor Commented:
How do you add db and tables under WinmySQLAdmin? Do I have to use the ugly DOS interface? I clicked on the tab called database/table or something like that. But all of them are freezed/disabled...
Thanks
Jack
0
HMaxCommented:
Do not use WinmySQLAdmin to manage your databases.

Download mySQL Control Center or use PhpMyAdmin or anything other mySQL GUI to do so

mySQL CC is available for free at mysql website.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
luckieAuthor Commented:
Extra Question: How do you set primary key on a table?
Thanks
Jack
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.