My jdbc.ini is currently:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd">
<JDBCINI Version="0x00010000">
<DataSources>
<DataSource ID="emails">
<DSN>emails</DSN>
<DriverClass>com.filemaker.jdbc.Driver</DriverClass>
<URL>jdbc:filemaker://203.24.144.42/emails.fp7</URL>
<Properties>
<Property ID="">
<Name></Name>
<Value></Value>
</Property>
</Properties>
</DataSource>
</DataSources>
</JDBCINI>
AND IT WORKS!!!
On 08/03/2011, at 8:58 PM, Wayne Irvine wrote:
> I'm using FMS Advanced but I think you'll find all flavours of Filemaker
> support ODBC/JDBC connectivity.
>
> Wayne
>
> On 08/03/2011, at 8:21 PM, Marc Herman wrote:
>
>> Wayne,
>>
>> Are you using FileMaker Server or FileMaker Server Advanced (version 11)?
>> From what I understand, FileMaker Server 11 does not support ODBC/JDBC
>> connectivity. FileMaker Server Advanced 11 on the other hand, does.
>> http://www.filemaker.com/products/compare/fms_vs_fmsa.html
>>
>> Marc Herman
>>
>>
>> Op 8-mrt-11, om 08:51 heeft Wayne Irvine het volgende geschreven:
>>
>>> I'm getting extremely frustrated with this and not sure how much is because
>>> it is new ground for me and how much is due to bugs and incompatibilities
>>> between FileMaker and Witango. I can see light at the end of the tunnel but
>>> it will probably be a train coming. ;)
>>>
>>> I keep going back to square one and going through the steps and hitting
>>> dead ends everytime. What I intend to do is document my steps in detail.
>>> Hopefully someone can point out where I am going wrong along the way. And
>>> this can form a guide for anyone else who finds themselves in my
>>> predicament.
>>>
>>> This assumes you have installed Apache, Witango Application Server, Witango
>>> Dev Server, FileMaker Pro and FileMaker Pro Server on the same Mac. You
>>> must also have placed the file 'fmjdbc.jar' in the folder
>>> /Library/Java/Extensions of the Mac.
>>>
>>> Step 1 - Build a FileMaker database
>>>
>>> Open FileMaker Pro (single user)
>>> Create a new FileMaker file. Mine is called 'emails.fp7'.
>>> Add a couple of fields to it. In this example I am using two text fields,
>>> 'contactname' and 'contactemail'. No spaces.
>>>
>>> I suspect the default table names might not be allowed by Witango so I
>>> select File:Manage:Database and rename the table to something descriptive
>>> (no spaces}. In this example I rename the default table 'emailstable'.
>>>
>>> I now go to File:Manage:Security. Here I set up and Account named 'witango'
>>> with Password 'password' and assign it Full Access.
>>>
>>> Then go to File:Sharing:FileMaker Network. Turn on sharing, select the
>>> 'emails.fp7' db, select the 'Specify users by privilege set' radio button
>>> and click specify. A dialog box appears with a list of privilege sets.
>>> [Full access] includes the account 'witango'. Check this box.
>>>
>>> Repeat the above for File:Sharing:ODBC/JDBC.
>>>
>>> Now close the database file. You are now ready to upload the file to
>>> FileMaker Pro Server.
>>>
>>> Step 2 - Upload the database to FileMaker Pro Server.
>>>
>>> Copy the database file to the Mac running FileMaker Pro Server.
>>>
>>> Open the admin app. This will have been created on your desktop during
>>> installation. It will be called 'FMS11-<name of server>.app'. On the left
>>> hand side should be a list containing Administration and Configuration and
>>> sub categories. The last option in Configuration is 'ODBC/JDBC'. Click this
>>> and ensure it is enabled.
>>>
>>> Across the top of the window are 8 icons. The fifth icon looks like a
>>> FileMaker Pro file with an up arrow. This is the upload database icon.
>>> Click it.
>>>
>>> The first dialog asks where you would like to place the database. Select
>>> 'Default Folder' and click 'Add Database' on the right. Now locate the FMP
>>> file you copied over and click Select. You will see the same folder
>>> structure with your database under Default Folder and a tick next to it.
>>> Click Next. A dialog appears with 'Automatically open databases after
>>> upload' already checked. Click Next. you will see a progress bar as your
>>> database is uploaded. When it is done click Next. An then click Finish.
>>>
>>> In Administration:Databases you will see your database hosted with a tick
>>> in the Pro column and the ODBC/JDBC column.
>>>
>>> Step 3 - Configure jdbc.ini
>>>
>>> On the Mac running the web server and Witango Application Server you need
>>> to edit the following file:
>>> /Applications/Witango Application Server 6/Configuration/jdbc.ini.
>>>
>>> Replace the contents with these:
>>>
>>> <?xml version="1.0" encoding="ISO-8859-1" ?>
>>> <!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd">
>>> <JDBCINI Version="0x00010000">
>>> <DataSources>
>>> <DataSource ID="emails.fp7">
>>> <DSN>emails.fp7</DSN>
>>> <DriverClass>com.filemaker.jdbc.Driver</DriverClass>
>>> <URL>jdbc:filemaker://127.0.0.1/emails.fp7</URL>
>>> <Properties>
>>> <Property ID="">
>>> <Name></Name>
>>> <Value></Value>
>>> </Property>
>>> </Properties>
>>> </DataSource>
>>> </DataSources>
>>> </JDBCINI>
>>>
>>> Notice the following line:
>>> <URL>jdbc:filemaker://127.0.0.1/emails.fp7</URL>
>>>
>>> The IP address is the IP address of the host server. 127.0.0.1 means 'this
>>> host'.
>>>
>>> Save and close.
>>>
>>> You will now need to restart Witango. Open Terminal
>>> (/Applications/Utilities/Terminal.app) and enter the following:
>>>
>>> sudo launchctl unload /Library/LaunchDaemons/witango.plist
>>>
>>> and press return. It will ask you for the administrators password. Once
>>> entered it will think for quite a long while then return you the terminal
>>> prompt. That quits witango.
>>>
>>> Now type:
>>>
>>> sudo launchctl load /Library/LaunchDaemons/witango.plist
>>>
>>> and return. That restarts witango.
>>>
>>> Theoretically Witango is all set up to talk to your database.
>>>
>>> Step 4 - Configure Dev Studio
>>>
>>> Launch Witango Development Studio.
>>>
>>> The first thing to do is to configure the JDBC drivers. Go to Data
>>> Sources:JDBC Drivers. A dialog will come up listing four driver types. We
>>> are only interested in the last one, FileMaker v11.3. On the right hand
>>> side click the corresponding Browse button and locate the jdbc.jar file you
>>> copied during installation. It should be in sudo launchctl unload
>>> /Library/Java/Extensions/fmjdbc.jar. Select it and click Open. Close the
>>> dialog box.
>>>
>>> Step 5 - Load the datasource
>>>
>>> In the Dev Studio window, running up the left hand side are four buttons.
>>> Click on Database. You will see two options: JDBC and ODBC. Right click on
>>> JDBC and select New Datasource from the menu. A dialog appears.
>>>
>>> In the first cell enter a suitable name. I used 'emailsDSN'.
>>> The next cell is a drop down with only one options. Select 'FileMaker
>>> v11.3'.
>>> Next is URL. Enter 'jdbc:filemaker://127.0.0.1/emails.fp7' without the
>>> quotes. Once again, the IP address is the IP address of the server.
>>> Careful not to TAB to Properties. The software will hang and you will have
>>> to force quit and start again.
>>> Ignore the Properties.
>>> In the Username field enter 'witango'. No quotes.
>>> In Password enter 'password'. No quotes.
>>>
>>> The check box for 'Ask each time' becomes active. Uncheck this.
>>>
>>> Click 'OK'.
>>>
>>> A new item should appear below JDBC called 'emails'. Double click on it. It
>>> might ask you to enter the Username and Password.
>>>
>>> A dialog should appear asking which table from the database should be used.
>>> Under the list of available table should only be one: emailstable. Click on
>>> this and then click the 'To >>' button. It will be moved across to the
>>> 'Tables to Use:' column. Click 'OK'.
>>>
>>> A new item should appear below the datasource 'emailsDSN'. It should be a
>>> table called 'emailstable'. Next to it is an arrow. If you click the arrow
>>> it expands and shows the fields in the table emails. These should be ROWID
>>> (the index field) and the two fields you defined so many steps ago;
>>> contactname and contactemail.
>>>
>>> You are no ready to start coding!
>>>
>>> Step 6 - Creating a TAF.
>>>
>>> Select File:New:New Application File.
>>> Drag the New Record Builder from the Actions Palette.
>>> Drag the fields: contactname and contactemail across.
>>> Click the Build Actions button.
>>> Save the file to your webserver.
>>>
>>> Step 7 - Time for disappointment.
>>>
>>> Open a web browser and enter the address of your TAF in the address bar.
>>> Press return,
>>> You see a form with two fields; contactname and contactemail. Put a name in
>>> the first field and an email in the second one. Press return.
>>> Get an error message:
>>>
>>> Unable to connect to the specified data source.
>>> Verify that data source is properly configured and that database server is
>>> online.
>>>
>>> Hopefully with a bit of refinement this tutorial will end a little better
>>> than this.
>>>
>>> Wayne Irvine
>>>
>>>
>>>
>>> To unsubscribe from this list, please send an email to [email protected]
>>> with "unsubscribe witango-talk" in the body.
>>
>>
>> To unsubscribe from this list, please send an email to [email protected]
>> with "unsubscribe witango-talk" in the body.
>
>
> To unsubscribe from this list, please send an email to [email protected]
> with "unsubscribe witango-talk" in the body.
----------------------------------------
To unsubscribe from this list, please send an email to [email protected]
with "unsubscribe witango-talk" in the body.
