The Devart Salesforce Connection Manager has "Connection Timeout" option:
Connection Timeout - The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. The default value is 15.
https://www.devart.com/ssis/docs/index. ... sforce.htm
You can try to increase it. But we don't sure that the issue is related to Devart SSIS Data Flow Components at all.
Search found 152 matches
- Fri 21 Oct 2022 15:50
- Forum: dotConnect for Cloud Applications
- Topic: The underlying connection was closed
- Replies: 2
- Views: 47940
- Wed 19 Oct 2022 09:34
- Forum: dotConnect for Oracle
- Topic: Oracle error OCI-21500 and hard crash.
- Replies: 2
- Views: 52561
Re: Oracle error OCI-21500 and hard crash.
We couldn't reproduce such an issue using the Oracle 19c server and Oracle Instant Client 19.16 (as well as the latest version of the Oracle client). Even if we increase the number of threads. Perhaps we need to know more details about your environment.
In any case, we would recommend using the latest version of the Oracle Client.
https://www.oracle.com/cis/database/tec ... loads.html
In any case, we would recommend using the latest version of the Oracle Client.
https://www.oracle.com/cis/database/tec ... loads.html
- Tue 18 Oct 2022 08:39
- Forum: dotConnect for Cloud Applications
- Topic: Magento Error accessing web service.
- Replies: 1
- Views: 11306
Re: Magento Error accessing web service.
dotConnect for Magento works via Magento API
The API description you can see in the Adobe documentation:
https://magento.redoc.ly/2.4.5-admin/ta ... saddressId
See also "Connecting to Magento" topic:
https://www.devart.com/dotconnect/magen ... cting.html
Service Version connection string parameter - Magento version to connect to - 1.x or 2.x. If you omit this parameter, dotConnect for Magento will try to connect, assuming that target is Magento 1.x;
dotConnect for Magento allows connecting to both Magento 1.x and Magento 2.x version. For connecting to Magento 1.x, you need to specify the API Key parameter. You can find the API Key in the User information section of your Magento dashboard.
For connecting to Magento 2.x, you need to set the Service Version parameter to Ver2 and specify the Password parameter instead of API Key
All the connection properties: ConnectionString Property
https://www.devart.com/dotconnect/magen ... tring.html
The API description you can see in the Adobe documentation:
https://magento.redoc.ly/2.4.5-admin/ta ... saddressId
See also "Connecting to Magento" topic:
https://www.devart.com/dotconnect/magen ... cting.html
Service Version connection string parameter - Magento version to connect to - 1.x or 2.x. If you omit this parameter, dotConnect for Magento will try to connect, assuming that target is Magento 1.x;
dotConnect for Magento allows connecting to both Magento 1.x and Magento 2.x version. For connecting to Magento 1.x, you need to specify the API Key parameter. You can find the API Key in the User information section of your Magento dashboard.
For connecting to Magento 2.x, you need to set the Service Version parameter to Ver2 and specify the Password parameter instead of API Key
All the connection properties: ConnectionString Property
https://www.devart.com/dotconnect/magen ... tring.html
- Fri 07 Oct 2022 17:47
- Forum: SSIS Data Flow Components
- Topic: Big Query Connection Manager - Authentication Fails
- Replies: 1
- Views: 47132
Re: Big Query Connection Manager - Authentication Fails
You have to unblock the application here:
https://myaccount.google.com/lesssecureapps
However, this option is not available for accounts with two-step verification.
In this case, you can create an application password, as described here:
https://support.google.com/accounts/answer/185833?hl=en
https://myaccount.google.com/lesssecureapps
However, this option is not available for accounts with two-step verification.
In this case, you can create an application password, as described here:
https://support.google.com/accounts/answer/185833?hl=en
- Tue 04 Oct 2022 18:46
- Forum: dotConnect Universal
- Topic: WaitAll Problem
- Replies: 3
- Views: 63715
Re: WaitAll Problem
The main feature of dotConnect Universal is access to multiple database servers using the same code, but dotConnect Universal doesn't support database-specific features for all databases.
So, with database specific providers you can reach better performance than dotConnect Universal.
- Tue 04 Oct 2022 18:44
- Forum: dotConnect for Oracle
- Topic: Connection problems in Advanced Queueing
- Replies: 1
- Views: 14705
Re: Connection problems in Advanced Queueing
Please provide us with an example of your application and DDL for the necessary database tables to reproduce the issue.
Note that the feature is supported only for OCI connections and is not supported for Direct connections.
Note that the feature is supported only for OCI connections and is not supported for Direct connections.
- Tue 04 Oct 2022 10:30
- Forum: dotConnect for Cloud Applications
- Topic: Where is the UseBulkAPI setting?
- Replies: 3
- Views: 13572
Re: Where is the UseBulkAPI setting?
dotConnect for Salesforce includes SSIS Data Flow Components as an additional.
"SSIS Data Flow Components for Salesforce" - another product.
https://www.devart.com/ssis/salesforce/
It doesn't replace dotConnect for Salesforce.
"SSIS Data Flow Components for Salesforce" applies to SSIS only and doesn't have dotConnect functionality.
UseBulkApi option is available in "SSIS Data Flow Components for Salesforce".
dotConnect for Salesforce always uses Bulk API and doesn't have UseBulkApi option.
To have UseBulkApi option you should have "SSIS Data Flow Components for Salesforce" product.
https://www.devart.com/ssis/salesforce/
"SSIS Data Flow Components for Salesforce" - another product.
https://www.devart.com/ssis/salesforce/
It doesn't replace dotConnect for Salesforce.
"SSIS Data Flow Components for Salesforce" applies to SSIS only and doesn't have dotConnect functionality.
UseBulkApi option is available in "SSIS Data Flow Components for Salesforce".
dotConnect for Salesforce always uses Bulk API and doesn't have UseBulkApi option.
To have UseBulkApi option you should have "SSIS Data Flow Components for Salesforce" product.
https://www.devart.com/ssis/salesforce/
- Tue 04 Oct 2022 08:29
- Forum: dotConnect for PostgreSQL
- Topic: Problem with DbFunctions.TruncateTime
- Replies: 12
- Views: 52715
Re: Problem with DbFunctions.TruncateTime
Please create a support ticket via the contact form, so that we can offer you an extended trial.
https://www.devart.com/company/contactf ... postgresql
- Tue 04 Oct 2022 08:23
- Forum: dotConnect for Oracle
- Topic: AccessVisolationException
- Replies: 1
- Views: 13940
Re: AccessVisolationException
dotConnect for Oracle 9.14.1204 was released 18-Feb-21
There are many updates and improvements including that:
9.14.1228 01-Apr-21
• The bug with throwing AccessViolationException by OracleCommand.ExecuteScalar() in the OCI mode is fixed
https://www.devart.com/dotconnect/oracl ... story.html
Unfortunately, without being able to reproduce the error, we cannot know its cause.
There are many updates and improvements including that:
9.14.1228 01-Apr-21
• The bug with throwing AccessViolationException by OracleCommand.ExecuteScalar() in the OCI mode is fixed
https://www.devart.com/dotconnect/oracl ... story.html
Unfortunately, without being able to reproduce the error, we cannot know its cause.
- Tue 04 Oct 2022 08:07
- Forum: dotConnect for Oracle
- Topic: Execute Array too slow since updating to net 6 from net core 3.1
- Replies: 1
- Views: 13717
Re: Execute Array too slow since updating to net 6 from net core 3.1
To reproduce the issue please show us the complete test project and DDL for the tables you were updating.
- Tue 04 Oct 2022 07:44
- Forum: dotConnect for Oracle
- Topic: Bugreport: NullReferenceExpetion when using dotConnect for Oracle 9.14 with the ADO.Net appender from log4net
- Replies: 2
- Views: 14393
Re: Bugreport: NullReferenceExpetion when using dotConnect for Oracle 9.14 with the ADO.Net appender from log4net
Since you create .NET Framework project, you should use local assemblies (Devart.Data.dll, Devart.Data.Oracle.dll) shipped with the installation of dotConnect for Oracle (not a NuGet).
- Mon 03 Oct 2022 19:52
- Forum: LinqConnect (LINQ to SQL support)
- Topic: Zip versions of the downloads
- Replies: 1
- Views: 15506
Re: Zip versions of the downloads
Please create a support ticket via the contact form.
https://www.devart.com/company/contactf ... inqconnect
Specify the email where your Devart products are registered, so that we can provide you a version in accordance with your license.
https://www.devart.com/company/contactf ... inqconnect
Specify the email where your Devart products are registered, so that we can provide you a version in accordance with your license.
- Mon 03 Oct 2022 19:45
- Forum: dotConnect for Oracle
- Topic: Set InitialLobFetchSize for EF 6 db context
- Replies: 17
- Views: 332266
- Mon 03 Oct 2022 19:42
- Forum: dotConnect for Oracle
- Topic: Set InitialLobFetchSize for EF 6 db context
- Replies: 17
- Views: 332266
Re: Set InitialLobFetchSize for EF 6 db context
Please create a support ticket via the contact form.
https://www.devart.com/company/contactf ... ect/oracle
Specify the email where your Devart products are registered, so that we can provide you with a pre-release build in accordance with your license.
- Mon 03 Oct 2022 19:13
- Forum: dotConnect for Oracle
- Topic: Visual Studio slow open .cshtml pages when Devart dotconnect extensions are enabled
- Replies: 1
- Views: 16853