Jump to content
Sign in to follow this  
max123

fm and MySql

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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..

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

hi Genx.

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

Help me..

Thank,

Share this post


Link to post
Share on other sites

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).

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    MartieH 
×

Important Information

By using this site, you agree to our Terms of Use.