Par2: Error writing to SQL Anywhere 1998-12-02 -- Joe Suriano > I can read the records form the SQL db but when I try to write back to the DB >the file driver returns the following error ' file system error' and does not allow me >to write back to the file. Looks like you are using an authenticated database, like us. We get this error when we forget to call a proc from the dll supplied by SA, or if you are accessing the db through some other program. Reading is ok, writing is not allowed. The proc is called StartDB() and is called before opening the first file at program startup, and then we call StopDB() at program end. This allows your program to modify any tables in the db. I don't know too many details because my co-worker handled this whole area but there is info about connecting to the authenticated db that comes with SA. I know he had to take the C code supplied and create the dll. I'll try to dig up some more helpful answers for you if you have any more questions Printed May 3, 2024, 5:08 pm This article has been viewed/printed 35110 times. |