MySQL OS X Filemaker Pro integration

Hi

I'm a novice with MySQL and ODBC, but I know what I want to do .. and
not getting anywhere fast.

I want to be able to access data in a MySQL database from FileMaker
Pro 7.
I am configuring everything on my iBook, OS X Panther.

I downloaded MySQL from
http://www.serverlogistics.com/mysql.php#download
I installed it and then used a little test.php script I got from
http://macdevcenter.com/lpt/a/1623
And it looked successfull

--------------------------------------------------
Connection to the database has been established.
Table 'wisdom' already exists
The data was inserted correctly!
We successfully got all the table data.
#1: Morbus sez: "Must... remain... awake!"
--------------------------------------------------

I then downloaded and installed OpenLinkUDA-5.1, the demo for OS X
from OpenLink's web site. I tried to follow the documentation but ran
into difficulties.

I opened the OpenLink ODBC Administrator application. Under the User
DSN and System DSN there was nothing, this is fine. Under ODBC Drivers
tab I see
OpenLink Generic Driver
OpenLink Generic Driver (unicode)
Under User DSN I click Add and I am given the choice of the above 2
drivers.
I don't really know which of these to choose but I choose the first
one and click Finish.

I get a window called OpenLink Multi Tier DSN Configuration with 4
tabs
DSN, Connection, Options and Test
Under DSN it wants
name for the data source (I entered MySQLocal)
description for the data source (I entered OSX SQL)
it asks "Which server do you want to connect to?" and offers a
dropdown Server menu, with only one item called "Manual Settings..."
If I click and release this I get a dialog box asking me for a
hostname (localhost is entered) and port number (5000 is entered). I
click ok.

Under connection I am asked to choose a 'Domain' from a drop down
menu, the default is DB2. It also asks for 'Name' and 'Server/Adapter'
and username and password. I have not set any password on MySQL at
this point.

I am trying to follow the instructions for "ODBC Client Components",
the html documentation comes with the download. For the 'Connection'
tab the intructions talk about

Domain
Database
Connection Options
Connect now..
Login ID
Password

This is a little misleading because the window actually asks for

Domain
Name
Connection
Connect now..
Username
Password

I'm not sure what to enter in Domain. I'm using MySQL version: 4.0.15
and there is a choice for MySQL 3.x. The default is DB2
I don't know what to put in 'Name'. I'm just trying to test this at
the moment and I wanted to use the 'test' database that comes with the
MySQL install. So I entered 'test' in Name.
For username I put root, and no password

In the tab 'Options' I left everything default

In the tab 'Test' I have

Data Source Name: MySQLocal
Data Source Description: OSX SQL
Server: localhost
Server Type: Odbc
Database: test
Server/Adapter:
Read-only connection: No
Defer fetching of long data: Yes
Disable interactive login: No
Row buffer size: 30

I click 'Test Data Source' and I get

Running connectivity tests ...

Attempting connection
[OpenLink][ODBC]RPC: Remote system error

TEST FAILED !


Then I looked for more help
http://www.openlinksw.com/info/docs/uda51/liteosxliteconf.html#osxliteusemysql
And saw info on OpenLink MySQL Lite Setup Wizard
What is this, do I need it? Where can I get it?

Also in the documentation that came with OpenLinkUDA-5.1 there was
info about Server Components Installation which talks about installing
OpenLinkUDA-5.0.dmg


So I'm overall confused. I know I'm on the right track but can't get
everything to come together yet.

I want to run MySQL on my laptop and to be able to
select/insert/update/delete with web pages and PHP. This I basically
have .... it's working fine.
I also want to then open up Filemaker Pro 7 and open an ODBC data
source, ie my MySQL databases and access the into that way ....


I've gone through the documentation and I've asked in newsgroups. I
get answers like "Sure you can do this, just get OpenLink's ODBC
drivers and configure" This is a bit too vague for me.

Apologies for the long step by step post, but I wanted to make sure
you understood each step that I took. I want to buy the full version
but I want to make sure I can get the demo working.

Any help would be apreciated. What am I missing, what am I doing
wrong? What am I doing right?

Thanx very much

rmc

I have made some progress
I had the Multi Tier driver instead of the Single Tier driver

So I downloaded the correct driver at
<a rel="nofollow" style='text-decoration: none;' href="http://oplweb.openlinksw.com/product/webmatrixst.asp" target="_blank">http://oplweb.openlinksw.com/product/webmatrixst.asp</a>
and installed and configured OpenLink MySQL Lite Driver. The test
says that the connection DSN was tested successfully.
I am trying to connect to the default test database that comes with
MySQL.
MySQL is running fine

mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| wisdom |
+----------------+
1 row in set (0.01 sec)

mysql>
mysql> select * from wisdom;
+----+--------------------------+--------+
| id | wisdom | author |
+----+--------------------------+--------+
| 1 | Must... remain... awake! | Morbus |
| 2 | Must... remain... awake! | Morbus |
| 3 | Must... remain... awake! | Morbus |
| 4 | Must... remain... awake! | Morbus |
+----+--------------------------+--------+
4 rows in set (0.00 sec)

So I opened Filemaker Pro 7, then File>Open ...>ODBC Data Source
and got the "Select Data Source" window showing the 'OpenLink MySQL
Lite Driver' which I selected.
I'm asked for username and password and enter root, I have no password
at the moment
This gives me Filemaker's 'SQL Query Builder' window with the SELECT,
WHERE and ORDER BY tabs.
This all very good so far.
Here's where it doesn't work. I select the 'wisdom' table and the 'id'
colunm and click 'Insert into SQL Query' which results in

SELECT wisdom.id
FROM wisdom

I click execute and I get
ODBC Error: [OpenLink][ODBC][MySQL Server]No Database Selected (1046)
No matter how I alter this SQL query I get either a syntax error or
the above error

I've tried
SELECT wisdom.id FROM wisdom [with and without the ending semi
colon (]
SELECT * FROM wisdom [with and without the ending
semi colon (]

If I just enter 'use test' as the query I get 'No fields are define in
the data source' but at least it seems to have some communication
happening.

So either I have a problem with building this query or ... well or I
dunno what.

Any help would be appreciated.

Thanx

rmc


(spacemancw) wrote in message ...
 > Hi
 >
 > I'm a novice with MySQL and ODBC, but I know what I want to do .. and
 > not getting anywhere fast.
 >
 > I want to be able to access data in a MySQL database from FileMaker
 > Pro 7.
 > I am configuring everything on my iBook, OS X Panther.
 >
 > I downloaded MySQL from
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.serverlogistics.com/mysql.php#download</font" target="_blank">http://www.serverlogistics.com/mysql.php#download</font</a>>
 > I installed it and then used a little test.php script I got from
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://macdevcenter.com/lpt/a/1623</font" target="_blank">http://macdevcenter.com/lpt/a/1623</font</a>>
 > And it looked successfull
 >
 > --------------------------------------------------
 > Connection to the database has been established.
 > Table 'wisdom' already exists
 > The data was inserted correctly!
 > We successfully got all the table data.
 > #1: Morbus sez: "Must... remain... awake!"
 > --------------------------------------------------
 >
 > I then downloaded and installed OpenLinkUDA-5.1, the demo for OS X
 > from OpenLink's web site. I tried to follow the documentation but ran
 > into difficulties.
 >
 > I opened the OpenLink ODBC Administrator application. Under the User
 > DSN and System DSN there was nothing, this is fine. Under ODBC Drivers
 > tab I see
 > OpenLink Generic Driver
 > OpenLink Generic Driver (unicode)
 > Under User DSN I click Add and I am given the choice of the above 2
 > drivers.
 > I don't really know which of these to choose but I choose the first
 > one and click Finish.
 >
 > I get a window called OpenLink Multi Tier DSN Configuration with 4
 > tabs
 > DSN, Connection, Options and Test
 > Under DSN it wants
 > name for the data source (I entered MySQLocal)
 > description for the data source (I entered OSX SQL)
 > it asks "Which server do you want to connect to?" and offers a
 > dropdown Server menu, with only one item called "Manual Settings..."
 > If I click and release this I get a dialog box asking me for a
 > hostname (localhost is entered) and port number (5000 is entered). I
 > click ok.
 >
 > Under connection I am asked to choose a 'Domain' from a drop down
 > menu, the default is DB2. It also asks for 'Name' and 'Server/Adapter'
 > and username and password. I have not set any password on MySQL at
 > this point.
 >
 > I am trying to follow the instructions for "ODBC Client Components",
 > the html documentation comes with the download. For the 'Connection'
 > tab the intructions talk about
 >
 > Domain
 > Database
 > Connection Options
 > Connect now..
 > Login ID
 > Password
 >
 > This is a little misleading because the window actually asks for
 >
 > Domain
 > Name
 > Connection
 > Connect now..
 > Username
 > Password
 >
 > I'm not sure what to enter in Domain. I'm using MySQL version: 4.0.15
 > and there is a choice for MySQL 3.x. The default is DB2
 > I don't know what to put in 'Name'. I'm just trying to test this at
 > the moment and I wanted to use the 'test' database that comes with the
 > MySQL install. So I entered 'test' in Name.
 > For username I put root, and no password
 >
 > In the tab 'Options' I left everything default
 >
 > In the tab 'Test' I have
 >
 > Data Source Name: MySQLocal
 > Data Source Description: OSX SQL
 > Server: localhost
 > Server Type: Odbc
 > Database: test
 > Server/Adapter:
 > Read-only connection: No
 > Defer fetching of long data: Yes
 > Disable interactive login: No
 > Row buffer size: 30
 >
 > I click 'Test Data Source' and I get
 >
 > Running connectivity tests ...
 >
 > Attempting connection
 > [OpenLink][ODBC]RPC: Remote system error
 >
 > TEST FAILED !
 >
 >
 > Then I looked for more help
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.openlinksw.com/info/docs/uda51/liteosxliteconf.html#osxliteusemysql</font" target="_blank">http://www.openlinksw.com/info/docs/uda51/liteosxliteconf.html#osxlite...mysql&l</a>>
 > And saw info on OpenLink MySQL Lite Setup Wizard
 > What is this, do I need it? Where can I get it?
 >
 > Also in the documentation that came with OpenLinkUDA-5.1 there was
 > info about Server Components Installation which talks about installing
 > OpenLinkUDA-5.0.dmg
 >
 >
 > So I'm overall confused. I know I'm on the right track but can't get
 > everything to come together yet.
 >
 > I want to run MySQL on my laptop and to be able to
 > select/insert/update/delete with web pages and PHP. This I basically
 > have .... it's working fine.
 > I also want to then open up Filemaker Pro 7 and open an ODBC data
 > source, ie my MySQL databases and access the into that way ....
 >
 >
 > I've gone through the documentation and I've asked in newsgroups. I
 > get answers like "Sure you can do this, just get OpenLink's ODBC
 > drivers and configure" This is a bit too vague for me.
 >
 > Apologies for the long step by step post, but I wanted to make sure
 > you understood each step that I took. I want to buy the full version
 > but I want to make sure I can get the demo working.
 >
 > Any help would be apreciated. What am I missing, what am I doing
 > wrong? What am I doing right?
 >
 > Thanx very much
 >
 > rmc