![]() Setting Pooling to Yes and a positive CPTimeout value in the odbcinst.ini file enables connection pooling. The driver should be reloaded for the changes to take effect. The ConnectionPooling attribute cannot be used to enable/disable connection pooling.Ĭonnection pooling can be enabled/disabled by editing the odbcinst.ini configuration file. For information about other connection attributes, see Connection Options. If necessary, please check How to: Disable Multiple Active Resultsets (MARS). However, the query timeout setting will take effect in the subsequent queries. When both MARS and pooling are in use, in order for MARS to work correctly, the driver requires a longer time to reset the connection on the first query, thus ignoring any query timeout specified. Multiple Active Result Sets (MARS) is enabled by default. If the ConnectionPooling attribute is omitted from the connection string or if it is set to true (or 1), the driver only creates a new connection if an equivalent connection does not exist in the connection pool. You can force the driver to create a new connection (instead of looking for an equivalent connection in the connection pool) by setting the value of the ConnectionPooling attribute in the connection string to false (or 0). Enabling/Disabling connection pooling Windows When a connection from the pool is used, the connection state is reset (Windows only).Ĭlosing the connection returns the connection to the pool.įor more information about connection pooling, see Driver Manager Connection Pooling. The driver determines whether connections are equivalent based on a comparison of connection strings. If an equivalent connection is not found in the pool, a new connection is created and added to the pool. When connection pooling is enabled and you connect to a server, the driver attempts to use a pooled connection before it creates a new one. In Linux and macOS, connections are pooled only if connection pooling is enabled for ODBC (see Enabling/Disabling connection pooling). The Microsoft Drivers for PHP for SQL Server uses ODBC connection pooling.īy default, connection pooling is enabled in Windows. Otherwise, if your purpose for using "File DSN" was to avoid ODBC driver installation and the associated registry entries, then consider JDBC which requires neither.The following are important points to note about connection pooling in the Microsoft Drivers for PHP for SQL Server: ![]() New > D atabase > Connect to an e xisting database > ODBC > Next > Browse > Organize.Įdit > Data base > Connection Type. To setup a 32-bit ODBC DSN run: %windir%\syswow64\odbcad32.exeĮither way, Base opens the applicable system ODBC Data Source Administrator as follows: To setup a 64-bit ODBC DSN run: Control Panel > System and Security > Administrative Tools > Data Sources (ODBC) > Drivers (tab) And they mention that you can access specific versions of the Windows ODBC Data Source Administrator as follows (but apparently either will suffice due to Windows awareness): According to these ODBC driver experts, Windows is smart enough to handle the versions a 32-bit application will automatically be directed to the 32-bit driver, while a 64-bit app will always use the 64-bit version. ![]() But Base does require the 32-bit driver because Base is a 32-bit app. That's fine - I have both versions of the Firebird ODBC driver installed. Or perhaps OOo/LibO simply doesn't support "File DSN" connections.Īs a workaround, setup a "User DSN" or "System DSN" in the system ODBC Data Source Administrator.Īs a Windows 7 64-bit user you might have installed both 64-bit and 32-bit versions of the ODBC driver.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |