Has anyone made a successful connection to systems union sun’s accounts database on Sql Server.
I have successfully managed a JDBC connection, but servoy gives me an error saying that no primary keys have been defined.
I dont want to play too much and mess up our accounts system, btu wondered if any one else has tried this link.
It is running on SQL Server 7.
David
Dunno about this specific DB you’re trying to connect to, but if you look in Servoy developer at the tables in the DB, do you see PK’s assigned?
Do the tables have primary keys?
If there are no PK’s defined in the table, you should use the row ident column to tell Servoy which columns make a record unique.
Servoy needs to be able to uniquely identify each row in a table based on 1 or a combination of several columns.
Paul