by Nath >> Tue, 5 Aug 2003 5:10:23 GMT
One of our clients uses GreenTree accounting system, which uses JADE. We have developed an application (Access 2000) for them that uses SQL server 2000 for it's data. A section of the application requires a list of Debtors that they can select from.
We've connected the required table via the JADE odbc driver 5.02.08.258 to the access app. But it's toooo slow, some of the users connect to the db's via VPN so I assume it would be even slower, therefore unusable.
So, I thought maybe we setup a DTS (Data Transformation Service) package in SQL 2000 and simply import the data (Debtors) once a day (the same method that we import exchange contacts into SQL 2000 for another purpose). Unfortunately there is an 'unexpected error message .....' and the data fails to import / export.
Does anyone know of this error?
Has anyone tried to do what we're doing?
Any suggestions / comments / solutions would be greatly appreciated.
TIA
Nathan