For customers who have a full blown cluster just as in database mirroring, typically when testing a failover, there is a hiccup of a few seconds. Our auto-reconnect feature has been able to detect the failover and continue working without problems.
Archive for the ‘DBMS’ Category
Using Auto-Reconnect in a Cluster Situation
Tuesday, February 24th, 2009How and When To Use MS SQL Server Native Client
Monday, February 16th, 2009SQL Native Client can be used rather than Microsoft Data Access Components (MDAC) to create new applications or enhance existing applications that need to take advantage of new SQL Server 2005 features such as Multiple Active Result Sets (MARS), Query Notifications, User-Defined Types (UDT), and XML data type support.
New Flex2SQL for MS SQL Server v10.x Driver Feature: LOB Support
Monday, February 16th, 2009BLOBs are very large variable binary or character data, typically documents (.txt, .doc) and pictures (.jpeg, .gif, .bmp), which can be stored in a database. In SQL Server, BLOBs can be text, ntext, or image data type.
Controlling Locking Behavior With the SET_ISOLATION_LEVEL Command
Monday, February 16th, 2009SET_ISOLATION_LEVEL controls the locking and row versioning behavior of SQL statements issued by a connection.
New Command: SQL_ENABLE_RECONNECT
Monday, February 16th, 2009SQL_ENABLE_RECONNECT allows the MySQL Driver to automatically reconnect to the server after the connection has been closed by a time-out. In the MySQL my.ini file you can set a system variable called wait_timeout to set the number of seconds that the server will wait on a non-interactive connection before it closes the connection. The default value for this variable is 28800 (8 hours). See also the MySQL manual under Server System Variables and more specifically the variables wait_timeout and interactive_timeout. (more…)