I just tried:
<DataSource ID="emails">
<DSN>emails</DSN>
and
<DataSource ID="emails">
<DSN>emailsDSN</DSN>
To no avail.
Wayne
On 08/03/2011, at 7:10 PM, Beverly Voth wrote:
> Wayne, are you sure the datasource uses the .fp7 extension? What happens if
> you don't include it?
>
> -- sent from my iPhone4 --
> Beverly Voth
> --
>
> On Mar 8, 2011, at 2:51 AM, Wayne Irvine <[email protected]> wrote:
>
>> 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.
