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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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