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
SQL Server LockTimeout not working?
I am using Delphi XE10.3.2 with UniDac 9.3.0. SQL Server We have a problem with a MS SQL Server Stored Procedure that frequently comes up with a "Lock request time out period exceeded." error. The SP basically does a lot of table Truncates and then INSERT
BREAKING CHANGE - Default Encrypt with Microsoft OLE DB-Driver 19 for SQL-Server
Hello I create a database connection with all standard parameters (TUniConnection.SpecificOptions) to MS SQL Server MyConnect := TUniConnection.Create; MyConnect.ProviderName := 'SQL Server'; MyConnect.Database := <DBName>; MyConnect.Username := <DBUser>;
Unidac 9.4 and SQL-Server
I'm trying to connect to a SQL-Server database. This works without any problems with Unidac 9.3.0. After installing Unidac 9.4.0 the application crashes. The reported error is 2.5 Type : EMSError 2.6 Message : TCP Provider:_Es konnte keine Verbindung
PgDAC on MAcOs
Hi am testing your Demo Mobile program with Delphi Alexandria 11.3 and PgDAC Version 7.4.0 using Mac Pro Book M2 chip . In this Demo on postgres Schema fish when i use Greek language on Mac not appear correctly Mac Running Windows Running
SetEmptyStrToNull does not work correctly
Hi, we have a problem with varchar fields, wich are not set to null even if we set SetEmptyStrToNull to true. If the value of a field is an empty string it all works correctly, but if we have an fields with a string with only spaces, then the field value
Memory leak in UNIDAC connecting to Oracle
Hello, I'm facing a memory leak in Unidac accesong to Oracle: 1. Oracle 12C 2. Delphi 11.3 First of all, on client side my customer was facing a problem after days the system is running and doing one task that executes every minute, a NET. Invalid pointer
Learning : How to save a Virtual table in SQL Tables
Sometimes we need to store a memory table (Virtual table is the best :) ) in a field of a database table. I present these 2 sub-programs and how to use them as a review. //--------- Wide string to TStringStream
procedure TDMT.WS2Mem(S: string; Var K
EntityDac 3.2.0 and Firebird 2.0.7
EntityDac 3.2.0 Firebird 2.0.7 IBDAC 8.3.0 Expression: From(ti).Where(ti.TRANSID = AId).OrderBy(ti.ID).Select(); Result: SELECT t1.ID ID, t1.TRANSID TRANSID, t1.ITEMCODE ITEMCODE, t1.OPIS OPIS, t1.OPISDOD OPISDOD, t1.KWOTA KWOTA, t1.SZTUKI SZTUKI, t1.WAGA
MySQL Router SSL Handshake error dotconnect mysql
I am trying upgrade my development machine and need to reinstall dot connect on the new machine, however, I cannot get dotconnect to work with mysql router - even though it's setup the exact same on the current development environment. I always receive
TMyDump from v8 to 5.7 charset problem
Hi Is there a way to specify the charset and collation when perforing a backup and restore? We have a clean set of data that we use for install that is on a Mysql 8 server but ur clients are using 5.7 We get the following error. I could perform a replace
missing compatible file : libdevartodbcase.2.1.4.dylib
Hello, we installed odbc driver for sybase 2.1.4 on macos M1 bigsur 11.6 and the error below is generated when trying to connect excel to sybase DSN : Could you please help us with this urgent issue Thanks in advance for your attention Kind regards,
Property EncryptedPassword does not exist
Good afternoon, I have a problem with one of the legacy systems here at the company, it is unfortunately developed in Delphi 6. My problem is that I updated the Delphi ODAC that was in version 8.6 to version 11.4, but when updating, when trying to compile
How do I insert an image file into a TVirtualTable Blob field?
Hello, I know how to insert blobs into TUniQueries. But I could not find the way to do this in a TVirtualTable. It does not expose any AsProperty which can sugest I can use a LoadFromStream method. Thank you very much. Jayme Jeffman Filho
TDADataSet
After reading Unidac 9.4.0 Revision History, I have a question: which unit TDADataSet class is declared?
dotconnect for Quickbooks
I have doconnect for SQL Server. Can the dotconnect for Quickbooks co-exist? I got an error when I tried to install the Trial version.
Is there a way to remove decryption out of sqlite db
Hi, I use dotconnect universal with sqlite and the Encryption of SQLiteCrypt: UniConnection conn = new UniConnection("Provider=SQLite; Data Source=database.db; Encryption=SQLiteCrypt; SQLiteCrypt License Key=00000-000-0000000-00000; FailIfMissing = false;
Next Page