we just upgraded our backend database from Sybase 7.0.3 to Sybase 10.0.1
servoy server & the repository are still on Sybase 9 (with a few other tables), and run on a separate box
all are win xp
I now see all kinds of strange behavior
I try to create a new form, on a sybase 9 table, and it complains that a sybase 10 table has no primary key
and, existing relations between sybase 9 tables now return null
any suggestions?
can 3.1.6 or 7 connect to sybase 10?
do I need to re-define my sybase 10 dataproviders?
since the db’s were upgraded from Sybase 7.0.3, the option string_rtruncation is OFF
in define dataproviders, I can only view the first few columns of each Sybase 10 Table
my server config is:
jdbc:sybase:Tds:192.168.1.23:7400?ServiceName=nti&CHARSET=utf8
com.sybase.jdbc3.jdbc.SybDriver
a surprise, that one “bad” dataprovider can cause havoc in an entire solution, even on forms where it is not referenced
(the sybase 10 tables are queried for totals only, and do not appear on any form)
thanks,
greg
PS
after much knashing of teeth, we just reverted back to Sybase 7, and all is well. Perhaps sybase 9 would have been a safer upgrade.
the developer guide says any database with a JDBC connection is supported, and “Sybase” is listed (but with no versions)
any comments appreciated