Devart Forums

Could you describe the issue in more detail?
Please also specify the version of dotConnect for SQL Server and the version of Visual Studio you use.

Note that dotConnect for SQL Server doesn't support .NET Core (.NET 6) yet.

dotConnect Universal currently supports .NET Framework only and isn't distributed via NuGet Packages.
https://www.devart.com/dotconnect/unive ... ility.html

At the moment, Devart Excel Add-ins do not support interaction with VBA. We will investigate the possibility to support using VBA, but there is no any timeframe.

We will investigate the possibility to support using VBA, but there is no any timeframe.

1.) Please clarify the version of SSIS Data Flow Components for Salesforce.
2.) Could you show us an example of your query?
3.) The example of your Data Flow Task?

You are probably using dotConnect for Salesforce. It contains SSIS Components for Salesforce.

But this documentation (https://www.devart.com/ssis/docs/) is related to a different product: SSIS Data Flow Components for Salesforce.
https://www.devart.com/ssis/salesforce/
It has similar functionality but is slightly different.

Note that dotConnect for Salesforce always uses Bulk API.

If your Oracle server requires SID to connect, use SID.
If it requires Service Name, use the Service Name.
Both options are possible and acceptable.

See also ConnectionString Property

Service Name Alias to an Oracle database instance (or many instances) to use in the OracleConnection.Direct mode. The default value is empty string. When Service Name is specified and implies several database instances, dotConnect for Oracle connects to the first instance provided by Oracle listener. Note that the Direct mode has limited support for RAC, it supports RAC with Connect Time Connection Failover (CTCF) only.

SID Unique name for an Oracle database instance to use in the OracleConnection.Direct mode. The default value is empty string.

The connection string could look like this:

In your case the connection string to the Oracle Autonomous Database could look like this:

User Id=my_user_id;Password=my_password;Server=tcps://<oracle_cloud>;Direct=True;Service Name=<name_goes_here>;Port=<port>;SSL ServerCertDN=<cn_ou_and_more_goes_here>;SSL WalletPath=<path_to_wallet>;


You can also specify the Server connection string parameter in a format like in the TNS_NAME.
For example:

User Id=my_user_id;Password=my_password;Direct=True;Server=(description= (retry_count=<put_count_here>)(retry_delay=<delay_here>)(address=(protocol=tcps)(port=<port>)(host=<oracle_cloud>))(connect_data=(service_name=<name_goes_here>))(security=(ssl_server_cert_dn="<cn_ou_and_more_goes_here>")(MY_WALLET_DIRECTORY=<path_to_wallet>)));

See also: Using Direct Mode
https://www.devart.com/dotconnect/oracl ... tMode.html

The new version of Devart Excel Add-ins 2.7.940 22-Sep-22
https://www.devart.com/excel-addins/dyn ... nload.html

The bug with Web Login was fixed.

dotConnect for SQL Server 4.0.0 30-Jun-22

• Visual Studio 2022 version 17.2 is supported.
• Visual Studio 2022 version 17.3 Preview is supported.

https://www.devart.com/dotconnect/sqlse ... story.html

The express (free) version of dotConnect for Oracle doesn't support .NET Core (.NET 6)

dotConnect for Oracle Editions

Thank you for your report. We will investigate the issue, but we will need more time to create the necessary infrastructure and reproduce the problem.

Please clarify the exact version of Visual Studio 2019.
We recommend using the latest version Visual Studio 2019 16.11.19

Thank you for your report. We have reproduced the issue and the investigation is in progress. We will inform you as soon as we have any results.

Thank you for your report. We have reproduced the issue and the investigation is in progress. We will inform you as soon as we have any results.