About chinmaydixit

chinmaydixit

Version: SQL Anywhere 16.0.0.2127 Scenario: A .NET app connects to the db with a user 'AA'. ConnectionString has user 'AA'. Connection Pooling: ON Provider: iAnywhere.Data.SQLAnywhere.v4.5.dll The .NET app then switches to another user 'BB'...

chinmaydixit

What is the maximum connection count threshold beyond which it will start impacting SQL Anywhere 16 database server's performance? DB Server Profile: SQL Anywhere 16 64 bit / Intel i5 2.5 GHz 8 cores / 16 GB RAM / 512 GB SSD Drive Max Connection Limi...

chinmaydixit

We had a similar situation where we had to change the encryption key. After much QA and discussions we decided to prompt the users with new passwords. We also lost the password history for each user but it was deemed that it is a one time effort for ...

chinmaydixit

I have never seen this behavior, have used ADO.NET with SA with Dapper and EF. I don't explicitly close the connection. Connection pool is enabled by default and my understanding is that the connection goes back to the pool for the connection string....

chinmaydixit

Correct. Wrong credentials doesn't show up either but syntax errors does.

chinmaydixit

I noticed this behavior few years ago in SA16 and did not see a connection id in All Connections in Sybase Central, but yes you are right, SA team members can confirm this.

chinmaydixit

An event of type ConnectFailed would never fire on "Database server connection limit exceeded" as the connection object has not been initialized yet.

User Statistics

User Activity

System function User_Id() is not returning the correct user ID of the current user in a trigger

Max connection count

Re: Decrypt error

Re: Bug in Sybase 17 when not closing reader in ADO.Net after executing a procedure

Re: ConnectFailed event

Re: ConnectFailed event

Re: ConnectFailed event