I finally found out what FM ODBC installer does. It provided no feedback during the installation, but in cruising the FM help files, I found that it created a new directory in Applications called DataDirect ODBC. It looks like there might be some help there on what to do next.
Thanks, David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Graham Sent: Friday, January 19, 2007 12:11 PM To: 'REALbasic NUG' Subject: RE: ODBC and Filemaker Todd, Thanks, that might be good news. I just installed ver 7, but most of the documentation in FM I can find is for using ODBC with Windows, and I neglected to mention that I need it to run under OS 10.4. Which platform are you using? I can't get past what I think is the first step of assigning a user DSN with OS 10.4's ODBC administrator. FM's driver doesn't appear when I try to add the DSN. The "Filemaker ODBC and JDBC Developer's Guide" mentioned in FM help is not on the installation disk, as they claim, nor can I find it on their web site. I did find a note in help saying which drivers to use for OSX (SQL Server 2000), but no indication of where they are or how to install them, other than that they are included. I downloaded Actual's SQL server, but they say that is only for reading data from FM, and not for pushing data into FM, since FM provides their own driver. David Graham -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Todd Geist Sent: Friday, January 19, 2007 9:47 AM To: REALbasic NUG Subject: Re: ODBC and Filemaker On Jan 19, 2007, at 8:32 AM, David Graham wrote: > I would like to automatically store data I am collecting with a > REALbasic > program into FM. Does anyone know if any version of FM supports > pushing of > data into a FM database via ODBC (or any other way). Apparently FM > 6.0 does > not, and I have not been able to get a clear answer from Filemaker > whether > more recent versions would be any better. Their version of ODBC > support > seems to be it allows FM can read other databases, not that other > databases > can store data into FM files. > > David Graham Hello, Yes you can push data into FileMaker using ODBC. I do it all the time. Versions 6 and earlier were pretty slow and only supported a subset of SQL commands. Versions 7 and later are much better. They support all standard SQL commands. If you can do it, you are much better of going with the latest version of FileMaker. In fact I wouldn't try doing any serious ODBC stuff on FileMaker 6 or earlier. It isn't worth the trouble. FileMaker 8.5 is really pretty good at it. Todd -- Todd Geist ______________________________________ g e i s t i n t e r a c t i v e _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
