fm and MySql

[max123]

hi, all....

I am a new developer in FM, and am trying to develop an application to manipulate the Data of MySql through FileMaker8.5,

so,please help me in this matter.

please explain me what are steps to be taken to solve this problem.?

Which plug-in to be used.?

How to handle the ExcuteSql Script step.?

Thanks in advance.

[Genx]

Hi Max, Welcome to the forums :

The Execute SQL Script Step lets you construct and execute any SQL statement you want (it can be dynamic) in relation to any ODBC connection you have installed on your system. To what end are you trying to manipulate the information?

[max123]

hi Genx.

Thanks for u r quick reply..

I download an Actual_OpenBase21 file from www.actualtechnologies. i am able to install Acutal OpenBase driver on my system.And also create userDSN for that driver.

I create one table emp in MySql DB with two column name and age,as well as one row in table emp.

now i am writing sript with script step ExeuteSql.

In this step i select the UserDSN and next pop up window comes which ask for username and password for odbc data source..and here i struct..

i think that when i install Driver there must be one window which ask for this username and password. may be i am wrong..

please help..

Thank..

[Genx]

Hi Max,

The username and password its asking for is your MySQL username and password (try user: root, pass: root) or (user: root, pass: blank)... or if its neither of those, find out what your actual password is.

[max123]

hi Genx.

i used both the username and password but i got the error that server is not running..

Help me..

Thank,

[Genx]

Try connecting via the MySQL console (if you don't know how, just google it, or if you need a copy, go to www.mysql.com).