Help with MySQL and ODBC

Hi,

I am stuck on how to configure ODBC with MySQL.

I am still trying to use the WebAssist database tutorial.

I get a server problem and it asks to verify that the ODBC DSN exists with the testing server.

I have Vista which has ODBC, but the Sql data base wasn't installed.

I need to add MYSQL to this list (which I have tried) that will allow the Webassist database to work.

Windows has the dbase,excel and MS Access setup. This is under the user DSN which I believe I should be adding SQL.

Can anybody help with this?

Mike

This is the third thread you started on this and it is becoming impossible to keep track of where you are and what you've done.

connector-odbc.html

Hi,

My intention was not to confuse. I started with the 1st thread and we figured what was going on with Xampp. I would figure that one closed because thru your help both Apache and MySQL come up.

The 2nd one was the a different issue which we figured out.

The 3rd issue is the one we are commenting on now. So I was wrong in starting this link, I am sorry. That was no my intention!

I am starting to look at the link which you sent and I say thx for you help.

I have been on with Adobe, Microsoft and other sites trying to understand what the real problem is.

I will read the following link that you sent.

thx

Mike

Fair enough. I think part of the problem was several others were also asking for help on the same issues over the weekend. Thanks for your explanation.

You will not need to configure ODBC to work with MySQL unless you are using ASP pages. If you are using PHP as your server model, MySQL should already be configured to work.

As office172461 stated, creating multiple threads will just create confusion and excess traffic, so if the issue is related, please try sticking to the same thread.

Thank you Jimmy!

I will keep with your advise.

Since this is my first time working with Apache/PHP and MySql, it is very hard in the beginning how everything is put together.

Hopefully by learning can I help myself and others on the WebAssist forums.

I wanted to double ck my work and see how things are put together, I found an Adobe link to a great article. Hopefully this will help others if they follow this thread.

setting_up_php_02.html

This tutorial will help you understand what is going on. It took me 3 tries to figure it out. You mess up one thing and that's it.

The biggest problem was the localhost. Yes, I changed it to 8080 and it should work, but it would end up with a ODBC error. I inhibited the IIS which I should have done long ago and follow the above link. I got the database to work and now by doing that, I understand how the php links up.

So yes Jimmy, I don't have to mess with the ODBC.

So, if you download the WebAssist the Database Starter Kit for PHP, make sure you do the link above to teach you the ropes.

Thx

Mike

Glad to be of help, and thanks for posting up your findings to be of help for other users.