Answers Posted June 8, 2009 Share Posted June 8, 2009 We have filemaker server 9.0v3 advanced, ODBC sharing is turned on. We want to connect to our V2 database to get parts & other information into filemaker. I installed on the ODBC driver on the server: DataDirect 4.10 32 Bit, Progress SQL 92 v.9.1E At first I was getting a network daemon error. One time I tried to add a table from that data source, it prompted for user name & password, then got a message data soucrce not supported. Now, when I try to access the external data source filemaker unexpectedly quits. This happens from different workstations, all running 9.0v3 Does the ODBC driver need to be installed on all client machines or just the server. From the windows 2003 server I tested the ODBC connectivity and it worked. Maybe someone could point me in the right direction. Thank you, Caroline Link to comment Share on other sites More sharing options...
mr_vodka Posted June 8, 2009 Share Posted June 8, 2009 I dont think Progress SQL is supported. These are the only ones supported for FMS9 using ESS. * MS SQL Server 2000 * MS SQL Server 2005 * Oracle 9i * Oracle 10g * MySQL 5.0 Community Edition (free) You can always use an ODBC connection to perform an import or Execute SQL statement though. Link to comment Share on other sites More sharing options...
Answers Posted July 29, 2009 Author Share Posted July 29, 2009 I am finally getting back to working on this odbc connection. I'm surprised that it can't connect to the progress data direct driver, it's the same driver Fedex uses, UPS etc... What we wanted to do is incorporate the same customers that we use with our sql database for accounting with our filemaker database. So our client list popup would access the other client list through an ODBC connection. We wanted live data, thats why we have Filemaker server advanced. Not sure what to do now. any ideas? Link to comment Share on other sites More sharing options...
mr_vodka Posted July 29, 2009 Share Posted July 29, 2009 You can always import then via ODBC into a FM table. You could do this every 30 minutes or each time that the list is accessed. Link to comment Share on other sites More sharing options...
Answers Posted July 30, 2009 Author Share Posted July 30, 2009 You can always import then via ODBC into a FM table. You could do this every 30 minutes or each time that the list is accessed. John, Thanks for your reply, but if it's importing every 30 minutes won't that slow the database down. And could I import just changes, or would it be a delete & import. We would like the customers and parts to be available from the ODBC source. Are you thinking a script that just runs every so many minutes? Just not sure the best method. your ideas? Thanks in advance, I appreciate your help, Caroline Link to comment Share on other sites More sharing options...
mr_vodka Posted July 30, 2009 Share Posted July 30, 2009 You can import only those records that have been modified if you have a modification timestamp in your external source tables. Also you dont have to import ( update/add to ) every few minutes if you dont want to. It just depends on how current you want the data. Link to comment Share on other sites More sharing options...
Answers Posted September 2, 2010 Author Share Posted September 2, 2010 Just curious if Filemaker 11 connect with DataDirect 4.10 32 Bit, Progress SQL 92 v.9.1E. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5007 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now