Hi,
At 11:00 -0500 28.03.2006, Dan Stein wrote:
Dan No problem from windows. Are you sure it is not a timestamp? I searched
a timestamp with no problem.
[DataDirect][ODBC SequeLink driver]Unable to convert column 9. Cannot
convert from SQL type 91 to C type 9.
07006
COLUMN 9 is a date field %d.%m.%Y
Cheers,
dan
I also tested a 350000 record database and searched for a date field with no
problem either. You can contact me off line if you want more info or need
help. I only did windows testing.
on 3/28/06 3:57, Dan Urlich at [EMAIL PROTECTED] wrote:
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
--
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
'I wonder why we say that people are of different "races". It seems to me,
we're all running at the same speed and heading towards the same
destination. The only "winners" are the ones who've made the world a better
place for having been here.'
From for Better or Worse 2/28/2006
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
