I gave up on JDBC and am now connecting via ODBC ...
The main problem I have now is that any dates fields seem to cause an
SQL error when searching. If I change the date fields to text
everything is OK.
Has anyone been able to search on date fields with Filemaker 8
Advanced Server and Witango 5.0?
For now I have created a calculation field that I can use to sort by:
Year ( insert_date ) & "-" & Month ( insert_date ) & "-" & Day (
insert_date )
(Witango server - MacOSX Server 10.3.9)
cheers,
dan
At 15:20 -0500 14.03.2006, John May wrote:
I know I've gotten JDBC and ODBC connections to FMSA on OS X before,
though I don't have time to re-work out the specifics right now.
- John
Dan is there a reason you can't use ODBC? At least I have seen that one work
although then you will want 10.4 or at least to install the latest drivers.
So far no takers on people using JDBC from the FSA list I'll try my FMI SE
see if he has any ideas.
on 3/14/06 10:56, Dan Urlich at [EMAIL PROTECTED] wrote:
Hi Dan,
At 10:46 -0500 14.03.2006, Dan Stein wrote:
Dan,
I will try and get you definitive install instructions. I think you will
find this would work better on 10.4x but I will check for you.
Great - looking forward to that.
As I have said before this is all much much easier to do on a Windows box
then Mac. You FMSA comes with both licenses so you should at least think
about it.
The setup speed and functionality is just plain better on windows Server
2003
I have no choice but to use the MacOS X 10.3.9 server at the moment
and we only have a Mac Witango server license.
Cheers,
Dan
on 3/14/06 10:27, Dan Urlich at [EMAIL PROTECTED] wrote:
Hi,
I am trying for the first time to connect to Filemaker 8 Server
Advanced via JDBC. Testing with MacOS X 10.4.5 client but I will
deploy on 10.3.9 Server. I have installed the JDBC Client Driver
into "/Library/Java/Extensions/".
I get a "No suitable driver" error message.
Any ideas?
Thanks,
Dan
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com
"There is a larger frame to the painting than the one that bounds our
>> life's events."
--
-------------------------------------------------------------------
John May : President <http://www.pointinspace.com>
Point In Space Internet Solutions [EMAIL PROTECTED]
Professional Lasso / PHP / MySQL / FileMaker Pro Hosting
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
