zope mysql database connection not showing

I   downloaded  file  ZMySQLDA then   unpacked and copied library to C:\Zope\Instance\2.9.7\Products
I restarted Zope server( http://localhost:8080/Control_Panel/manage)

Z MySQL Database Connection not available in the "add" dropdown list, and getting error

There are no SQL database connections. You need to add a Zope SQL database connection before you can create a Zope SQL Method.
prashanth agsoftware engineer Asked:
Who is Participating?
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.

Kanti PrasadCommented:
Hi

Try the below and then add the connection

$ /tmp/zsql/bin/easy_install Products.ZMySQLDA

Restarting Zope and add a  "Z MySQL Database Connection", add and  "Z SQL Method"
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
Kanti PrasadCommented:
hi

Then copy the directory ZMySQLDA  to the Products directory inside your Zope instance.

    In a generic default install of Zope the location will be:
    C:\Zope\Instance\2.10.4\Products
0
clockwatcherCommented:
My guess is that you likely either don't have the MySql database driver installed for the adapter that you picked or that you've got a version that's too new for your zope.  Go into the ZMI and open the Control Panel, find the Products area.  The data adapter that you tried to add should be listed there.  I'm betting it is showing up broken.  If it is, it should give you a traceback of the exception that it got when trying to initialize the product.  Post the exception traceback here.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

prashanth agsoftware engineer Author Commented:
Hi All,

I copied  ZMySQLDA in location   C:\Zope\Instance\2.9.7\Products  
and i follow instruction as per URL    http://python.objectis.net/zope-plone-articles/zope-and-mysql-on-windows
but problems that have not yet been solved
0
Kanti PrasadCommented:
Hi

Do you have MYSQL installated?
0
prashanth agsoftware engineer Author Commented:
NO
0
Kanti PrasadCommented:
Hi

Go to http://dev.mysql.com/downloads/mysql/  and dowload  MySQL Community Server  for windows
0
Kanti PrasadCommented:
Hi

If you installed Mysql you will have the driver. Now start MySQL looking at the instructions, stop and start zoop and try it now
0
Kanti PrasadCommented:
Hi

You need to install mysql db so down load the below installer and select the mysql db for windows

http://dev.mysql.com/downloads/windows/installer/5.6.html
0
Kanti PrasadCommented:
Hi

 manually copy my.ini from ProgramData to Program Files folder

This link will help you a bit
https://dev.mysql.com/doc/refman/5.1/en/windows-troubleshooting.html
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
Python

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.