Thanks Dan, You've given me something to do this weekend. ;)
Wayne Irvine On 13/01/2011, at 11:12 PM, Dan Stein wrote: > Wayne, > > After years of doing this I have come up with some rules of the road that are > essential for good performance. > > First and foremost create a filemaker file called myname_odbc.fp7. That file > should have just one table in it doesn't mater what you call it. Once field > and one record. > Add as an external datasource you solution file > Then add just the tables you need Witango to use. Make no relationship at all > in the relationship graph. > Depending on the version of filemaker you may need to make one relationship > an X one between this files table and one of the external datasource tables > but if you use 11 I am pretty sure the fixed that bug. > Make sure under file sharing you have ODBC turned on > Make sure user for this file and delete the admin user > Create a privilege set for web or witango ( see attached screen shot) > You need to create same user, password and privilege set in the file that > hold the data > Make sure you server have ODBC turned on > Read the docs FileMaker supports most but not all SQL > If you are using 11 make sure you get the latest driver update because the > original had serious bugs. > The ODBC in FM11 has a memory leak. Its better but still there so keep an I > on the server FMODBC lisener process and you will have to stop and start ODBC > on FM server every week or so you'll know by looking in task manager ( this > is not an issue on Mac) > The 11 drivers does not support @@identity. So if you want the ID back you > will have to insert you own unique value ( I use timestamp and user-reference > combined) as a variable and then search for it and get record ID > Otherwise we have found the ODBC to be very fast. Faster and more flexible > then filemaker in some respects for handling large data sets. > > Dan<ODBCPS.tiff><ODBCRG.tiff> > > -- > Dan Stein MSN CPNP > FileMaker 7 Certified Developer > FileMaker 9 Certified Developer > Digital Software Solutions > 303 W. Chestnut St > Souderton PA 18964 > Land: 215-799-0192 > Cell: 610-256-2843 > Fax 215-799-0192 ( Call 1st) > FMP, WiTango,MSSQL, MySQL,PHP > [email protected] > www.dss-db.com > > > Men do not care how nobly they live, but only how long they live, although it > is within the reach of every man to live nobly, but within no man's power to > live long. Brian Haig Private Sector > > > > > > > > On Jan 12, 2011, at 5:11 PM, Wayne Irvine wrote: > >> Thanks Beverly and Dan. That will get me started. >> >> Wayne Irvine >> >> On 13/01/2011, at 3:40 AM, BEVERLY VOTH wrote: >> >>> <http://www.filemaker.com/support/technologies/odbc.html> the xDBC >>> page on FMI site with links to the help, knowledge bas and the xDBC >>> guide: >>> <http://www.filemaker.com/support/product/docs/fms/fm11_odbc_jdbc_guide_en.pdf >>>> >>> On 12 Jan 2011, at 9:23 AM, Dan Stein wrote: >>> >>>> I am the one the wrote something up. I'll see if I can find it and >>>> update it for 11. >>>> Dan Stein MSN, CPNP >>>> FileMaker 7 Certified Developer >>>> FileMaker 9 Certified Developer >>>> Digital Software Solutions >>>> 303 W. Chestnut St >>>> Souderton PA 18964 >>>> Land: 215-799-0192 >>>> Cell: 610-256-2843 >>>> Fax 215-799-0192 ( Call 1st) >>>> FMP, WiTango,MSSQL, MySQL,PHP >>>> [email protected] >>>> www.dss-db.com >>>> >>>> “Talent is God given. Be humble. Fame is man-given. Be grateful. >>>> Conceit is self-given. Be careful.” John Wooden >>>> >>>> >>>> >>>> >>>> On Jan 12, 2011, at 7:05 AM, Beverly Voth wrote: >>>> >>>>> You can get the FM guides (PDF) on their site. I'll send you the >>>>> link when I get to the office. Keep in mind that FM Server Advanced >>>>> is required to use xDBC on hosted databases. I'll send the link to >>>>> that info, too. >>>>> >>>>> And I'll add that it works very well web published that way. :) >>>>> >>>>> -- sent from my iPhone4 -- >>>>> Beverly Voth >>>>> -- >>>>> >>>>> On Jan 12, 2011, at 4:26 AM, Wayne Irvine <[email protected]> >>>>> wrote: >>>>> >>>>>> I seem to remember someone wrote a how to on using FileMaker as an >>>>>> ODBC/JDBC datasource for Witango. Does anyone remember this or >>>>>> know where it can be accessed? >>>>>> >>>>>> Also, if there are any changes with the new versions that anybody >>>>>> is aware of it would be most useful. >>>>>> >>>>>> If there isn't anything publicly available I will happily do a >>>>>> write up and publish it. >>>>>> >>>>>> 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. >>> >> >> >> >> ---------------------------------------- >> >> 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.
