Newbies piping Posted October 13, 2009 Newbies Share Posted October 13, 2009 Hello! I need to access the information saved on FM v10 server advance to create reports on Cyrstal Report, but I do not know what to do, can someone help me? Do I need a driver? if I do, where i can find it? How I should I configure that driver? Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted October 14, 2009 Share Posted October 14, 2009 Depends on what protocols Crystal supports. ODBC? XML? PHP? Server must be set to accept such connections and you will need FileMaker drivers that support Crystal. Steven Link to comment Share on other sites More sharing options...
Newbies piping Posted October 14, 2009 Author Newbies Share Posted October 14, 2009 Thank you Old Man Advance for your replay. I am trying to use or configure the ODBC/JDBC that works on Crystal and FM, but I do not know how. For what I had read, it does not work too well. I am using Crystal Report v11 and FM v10 server advance. Could you tell me which drivers are you talking about? Where I can find them? Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted October 15, 2009 Share Posted October 15, 2009 Look on Install CD for FileMaker Server 10 to see if there are ODBC drivers from FMI to use with FIleMaker Server. Failing that see if there are generic ODBC drivers from Microsoft or if using MAc OS from Actual Technologies (IIRC). Steven Link to comment Share on other sites More sharing options...
Newbies pzhitomirsky Posted March 5, 2013 Newbies Share Posted March 5, 2013 I am writing and SQL query in Crystal connecting via ODBC to filemaker database and trying to get a system date and cannot! I am typing something like this; SELECT Get(CurrentDate), VISITS.Visit_Date FROM VISITS Get an error "Invalid syntax" Link to comment Share on other sites More sharing options...
Wim Decorte Posted March 5, 2013 Share Posted March 5, 2013 get(currentdate) is not a SQL COMMAND What is it that you are trying to do, find all of today's visits? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4081 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