Set the maxConcurrentConnections property: The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer). Overrides: OdbcSource.withMaxConcurrentConnections(Object maxConcurrentConnections) Parameters: maxConcurrentConnections with...
A data source for which connection information is stored on the system (for example, the registry). manual-commit mode A transaction commit mode in which transactions must be explicitly committed by callingSQLTransact. metadata Data that describes a parameter in an SQL statement or a column in ...
<cfset var connectionArgs = arguments.args><!--- :: set this to a 2nd var as a temp storage location :: ---> <cfset var accessmanager = createObject("component", "CFIDE.adminapi.accessmanager")> <cfset accessmanager.checkAdminRoles("coldfusion.datasources")> <!--- :: init dsn...
Write Conflicts or Row Location Errors How do I handle Write Conflicts or Row Location errors? If you see the following errors, select theReturn Matching Rowsoption in the DSN configuration dialog, or specifyOPTION=2, as the connection parameter: Write Conflict. Another user has changed your dat...
How do I handle Write Conflicts or Row Location errors? If you see the following errors, select the Return Matching Rows option in the DSN configuration dialog, or specify OPTION=2, as the connection parameter: Write Conflict. Another user has changed your data. Row cannot be located for ...
You can also set driver options in the connection string when you connect programmatically, or by adding or changing registry keys in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\your_DSN. For more information about configuring a DSN, see Install and configure the Amazon Redshift ODBC driver on ...
Define a data source name (DSN) by using either theODBC Data Source Administratorto store the connection information in the Microsoft Windows registry or a DSN file, or a connect string in Visual Basic code to pass the connection information directly to the ODBC Driver Manager. ...
Click Test connection. The user name USER1 and password Password1 can be entered when prompted for credentials. Press OK to save the data source. Saved values can also be viewed using the Microsoft Windows registry editor under the key Computer\HKEY_CURRENT_USER\Software\ODBC\ODBC.INI. For...
PrivateEndpointConnectionResource.Definition PrivateEndpointConnectionResource.DefinitionStages PrivateEndpointConnectionResource.DefinitionStages.Blank PrivateEndpointConnectionResource.DefinitionStages.WithCreate PrivateEndpointConnectionResource.DefinitionStages.WithIfMatch PrivateEndpointConnectionResource.DefinitionStages.WithParen...
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\16.0\Access Connectivity Engine\Engines\ODBC\QueryTimeoutI only have access to 1 table, but still it takes at least 1½-3 minutes to open the connection. I'm told because...