close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Help with MySQL and ODBC

Thread began 9/21/2009 5:47 am by madelectrical386948 | Last modified 9/22/2009 5:18 pm by Jimmy Wu | 2325 views | 6 replies |

madelectrical386948

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

Sign in to reply to this post

office172461

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

Sign in to reply to this post

madelectrical386948

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

Sign in to reply to this post

office172461

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.

Sign in to reply to this post

Jimmy Wu

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.

Sign in to reply to this post

madelectrical386948

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

Sign in to reply to this post

Jimmy Wu

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

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...