oNw thats a sad commentary on a programmers life. :} 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
“You can't let praise or criticism get to you. It's a weakness to get caught up in either one.” On Jan 14, 2011, at 5:34 PM, Wayne Irvine wrote: > 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. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
