Automatic Timestamp Macro
Hi, I found this topic and I think this is still a problem with UniDac: https://forums.devart.com/viewtopic.php?f=28&t=38112 When I use an SQL like ".... {timestamp '......'] ..." this works fine except for one client where I get an error: La conversion
How to translate SQLite messages
Hi, I use UniDAC to deal with SQLite databases. I use direct mode. If there is any error I use EUniError(E).ErrorCode but it is not detailed. (usually returns 1). E.Message holds detailed message in English. How to intercept to be able to get real error
Can a "dotConnect for Oracle" license be transfered from 1 developer to another developer
We're planning to buy a "dotConnect for Oracle" license type Team (up to 4 developers) for the company, and we analizyng the following scenario: If the 4 licenses are assigned to 4 different developers in the company, and at some point 1 of the developer
EF7: query (with JSON and CLOB) is much slower with directmode=true than without directmode
When querying an oracle view that has a CLOB which stores JSON using a connectstring with direct=true is much slower then without direct=true. <PackageReference Include="Devart.Data.Oracle.EFCore" Version="10.1.134.7" /> <PackageReference Include="Microsoft.EntityFrameworkCore"
How to setup encrypt connection on DBExpress Devart SQL Server?
Hello! I tried to add on params of TSQLConnection: (using Devart SQL Server) Trust Server Certificate=True; Use Encryption for Data=True;Login Prompt=False and Encrypt=True TrustServerCertificate=True but no effect on connection. I verified by this SQL:
dbExpress Trial Period
Good morning, I'm trying to use the dbexpress trial with my software, but when i try to use it on my software i receives an message saying that the trial period has expired, even if i dont have other dbxpress installation on the pc. I already tried to
Oracle RAC connectivity issue (regression)
Hi Devart Team, In early 2021 we updated our dorConnect for Oracle dependency to 9.14.1180 due to a client not being able to connect to their Oracle RAC database with our software. After the update all was good. Late last year we again updated our dotConnect
Best practice to work with SQL Server transactions
Hello, what's the best way to perform a transaction with a TMSQuery? See the following source code: try LQuery := LDatenHandler.GetQuery; // returns an TMSQuery object try LQuery.SQL.Clear; LQuery.SQL.Add('Begin transaction'); LQuery.SQL.Add('INSERT INTO
Devart SSIS Data Flow Components for Salesforce trial was expired
Good morning, We have several SSIS that stopped working after a month. We have the Devart license working in our computer using Visual Studio, but when we execute the SSIS from the server, it is throwing this error: "Tarea Flujo de datos:Error: There
Could not load file or assembly 'Devart.Data.Oracle.Entity.EF5'
Hi, we moved from devart 8.4 to version 10.0 so current entity dll is devart.data.oracle.enity.EF6 but after running program on a new user environment we're getting below error although we never had or used such dll devart.data.oracle.enity.EF5 - no idea
Insert to oracle 21 -> -922337203685478 value instead of 1.99 (exactly 1,99)
Hello, we have a problem with entering values to fields. The value 1.99 is entered into the table as null or as -922337203685478. We are using a 32 bit client - there is a problem on it. On the 64 client it is fine, unfortunately we cannot use it. Current
Delphi 6 - How to specify HomeName
Hi, I know that the HomeName option is only available for Delphi 2007 and higher IDE versions, but there is a workaround to specifiy an Oracle Home in Delphi 6, using last version of dbexpoda.dll? Thanks.
Long response time for a query
Hi, Last year, I posted a question on the old forums and the answer was: you need to install the latest version... Which we did in September (version 9.16.1434). Now we're back in that period where our application is used a lot and we're still experiencing
Table Mapping Generator
Hi All, during the generation of the mapping for a Database in EF Core v 7, importing the tables in model we have an error because is inserted a wrong value into a table definition. The wrong value is: .UseTptMappingStrategy() another problem is that
ExecuteDeleteAsync Error
Hello, every time i try to use ExecuteDeleteAsync in EF7 , for example context.TABLE_NAME.Where(x => x.ID == id).ExecuteDeleteAsync(cancellationToken: cancellationToken) i get error like : System.InvalidCastException: Unable to cast object of type 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.DeleteExpression'
Saving NULL geometries in Oracle DB with EF Core
We are migrating our solution from EF6 to EF Core and .NET Framework to .NET 6. When saving an entity using EF Core (using UseNetTopologySuite on the DbContext) where a column of type Geometry is NULL, it results in the following error: Microsoft.EntityFrameworkCore.DbUpdateException:
Performance on PostgreSQL connection
Good afternoon! We use TUniConnection in our applications, using in most cases the PostgreSQL database. We are experiencing problems related to slowness, especially when our customers use VPN for the connection. We are currently using the parameters below:
EMyError
Hey there, I think that the online documentation for EMyError is *very* incomplete. There is no mention, for example, of a "Message" property, which I've seen you mention in some help topics. Can you please point me where I can find the structure of EMyError
NET:IOHandler is not specified
A user is receiving this error message when attempting to connect to the database using a TOraSession in DIRECT mode. Can you tell me what this error means and how to resolve it? I am using the most recent ODAC version on Delphi 11.3 compiling in 64 bit.
Modify TStringField for ANSI / UTF translation
I am using the latest UniDac version with Delphi 12.3 on an oracle database (db2 / sqlserver planned) There are many old cobol applications running which not support UniCode, so data is written as AnsiString using the codepage setting of the windows client.
[ASE] Error on connection: Finally we got Status param!!! Analyze it.
Hi everyone, I'm currently trying to connect to a ASE Sybase database running on version 17.0.10.5963. I've installed the devart ASE driver as version 3.3.0. When trying to connect with different connection strings from Python, C Sharp and when testing
Firebird ODBC devartodbcfireird.dll access violation
Hi, I need to update my 2 servers with ODBC for V4 of Firebird. When I test on my workstation running Windows 11 Home, I have success. When I install and run on both Windows Server 2008 64bit and Windows 2012 64bit, they both get the same access violation
How to delete from SFDC Object in SSIS
Hi there. I have built out a suite of integrations using SSIS, SQL Server, and Devart for SFDC. It is working well. However, I need to clear out one SFDC object before I load it again. I am the kind of guy who needs a worked example when I hit a brick
UniDac - Delphi 11.3 - OpenSSL - Linux
Hello Community, We'd like to upgrade our Ubuntu Docker containers from V 18.04 to someting newer. We'd also like to use newer SSL components, but it seems like UniDac (MySqlConnector) only works with OpenSSL 1.x.x. Can someone shed some light on that
OLAP Connection to Azure Analysis Services Data Cube on macOS
On Windows we're successfully connecting an Excel pivot table to an Azure Analysis Services data cube using Excel's built in functionality. It generates the following connection string: OLEDB;Provider=MSOLAP.8;Persist Security Info=True;Initial Catalog=***;Data
What is Query API for and what does SQL_ATTR_MAX_ROWS allowing you to do? I have ZOHO CRM
What is Query API for and what does SQL_ATTR_MAX_ROWS allowing you to do? I have ZOHO CRM
Oracle - Query Type class '____' cannot have primary key.
In the Oracle Entity Developer, I'm getting this error on some tables: Query Type class '____' cannot have primary key. The table does have a primary key in Oracle, but it is a varchar column. How can this table be used?
Mac DevArt -> Postgres connectivity issues
I've attempted to connect using the Devart Mac to Postgres driver. I've followed the instructions in the documentation. Upon hitting the test connection button I'm met with the error invalid activation key: I just downloaded the trial version on Friday
SOQL Query Syntax Issues
Trying to get all fields from our ACCOUNT table limiting it by 200 and getting an error in SSMS. Syntax: SELECT * FROM OPENQUERY(XXXX,'SOQL:SELECT FIELDS(ALL) FROM Account LIMIT 200') (where XXXX is the Linked Server) OLE DB provider "MSDASQL" for linked
MSSQL Managment Studio can link to Zoho CRM, I can see all the tables but I cannot access the fields
On the 2 ends Zoho and MSSQL I am the administrator with full privileges. -- [ZOHOCRM].[default]..[Users] contains no columns that can be selected or the current user does not have permissions on that object. GO Please see attached document.
Zoho CRM ODBC error when trying to update Subform
I am trying to update the values in a subform. The subform data is in a string field of the primary form's table, formatted as a JSON array of objects -- each object being a row of the subform table. When trying to modify the field via an Update query,
Unknown Database error when running initial migration
Connection string is: "Server=127.0.0.1;Database=MyDatabase;Uid=username;Pwd=secret;" Entity Framework Core 7 My SQL version 8.0.32 Initial migration is scaffolded using `add-migration`. However `update-database` fails with error: "Unknown Database MyDatabase"
SSIS package created with Devart cannot be opened in VS2017 after Devart Addon is installed.
SSIS package created with Devart cannot be opened in VS2017 after Devart Addon is installed.
SOQL Queries with Salesforce ODBC Driver
Hi, I have connected the ODBC driver as a linked server in MS SQL Server and can read/write Salesforce data. Is there a way to issue a SOQL query directly to Salesforce from SQL Server using the ODBC driver or does one have to rely on the ODBC driver
Oracle trial license key
Hi, After having installed and used DevArt Oracle driver for EF I tried to renew my trial license key without success. I uninistalled software (clean program files and program data folders) and installed again using dcoracle.exe downloaded from your site.
'Invalid parameter specified' on prepared query with a double
In our project we get an Exception: 'Invalid parameters specified'. We've determined that this is specifically when we use a double variable. In the scenarios below the first two instances of TPgQuery are executing properly, however on opening the third
ConnectDialog
Hello, when trying to open the connection to the database, if it fails, it shows me the ConnectDialog even though I don't have any associated TConnectDialog component, I need it to mark the exception and not show the ConnectDialog. How do I do this?
Why should I buy Devart ODBC for SQL Server when I can get the MS equivalent for free?
Hi guys. I would be interested in purchasing the Devart ODBC driver for SQL Server, but I can't see it has a real advantage over the MS equivalent. Indeed, the server version price will raise from May 15th. Please, would you make it clear for me what
ODBC for Firebird: Problem with case sensitive table and field names
Hi, We've downloaded the trial version of the ODBC driver for Firebird. We are using Firebird 4. We are interested in purchasing the ODBC driver for Firebird, but it depends if the problem that we are seeing can be fixed. We are testing PowerBI with the
Number(20) cannot be read!
Hi, using c++ builder 10.3.2, unidac 9.2.1. I have an oracle table with column number (20) populated with numbers having 17 digits create table pelidetail(id number(9), peliid number(10), sortweight number(20), primary key(id)); insert into pelidetail
Next Page