SQL Anywhere 16.0.0.2798
Windows 2016 build 17763
I feel that I've referenced this issue in the past, but have some additional info here and we're out of ideas.
We are experiencing a huge lag in our client/server Student Billing application on the pr...
We had a hard crash of a database which has left at least one (that we know of) table corrupt. We're not able to validate, query, drop, truncate the table without taking down the database. I am able to query the objects: SELECT sc.* FROM dbo.syscol...
I have a proc that is dynamically creating the columns of a report, based upon the number of terms that fall within my reporting period. So perhaps I run it one time and get a student number followed by 8 thems. Then run it again with another range ...
We're having some sporadic performance issues in each application that accesses our database. I can't really tie it to load. We suspected a set of specific procedures, although we can run them via ISQL with no issues.
I'm trying to do some Applicati...
SQL Anywhere 16. We had someone retire, and I am removing his role as a dba. He feels that removing his dba role will affect any authorities he granted as dba. I'm sure that's not true, as it's not like I'm removing the dba user! But I said that ...
This forum has be an invaluable source for me over the past 30 years that I have used SQL Anywhere. It's difficult to think it will be gone. ALL of you administrators, monitors, and especially Breck for starting it, have given me so much insight to ...
Oh my I did NOT know about this. This is a huge loss, indeed. He helped me through several 'stuck' points. We also had good forum conversations on techniques. I have his book and have used in many times. I also had the chance to meet him in a class ...
An update: We did not have the current version of ODBC drivers on all client machines. Some had quite old versions. We replaced all of those and have seen some significant improvement. Mea Culpa; I did not know db client drivers versions, down to th...
