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
Opening reviewed file
Hello, when reviewing file, it always opens some temporary file under AppData folder instead of that one in Repository Directory. Why is it so? Issue is that that one temporary file si missing its context and therefore I cannot easily navigate to definitions
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
Error while running schema comparison (PostgreSQL)
Hello! The same error exists in dbForge Schema Compare for PostgreSQL and in the dbForge Studio. As I can see these both tools using the same files: Devart.DbForge.DbObjects.dll Devart.DbForge.DbObjects.PostgreSql.dll I have sent Error Report yesterday.
Exception when generating diff report for PostgreSQL from command line
Evaluating schema compare tool using PostgreSQL 14.7 local databases. Can successfully generate HTML report from User interface, but same process is failing when generating via command line. We want to plug this into our build server pipeline, so command
Importing CSV with french boolean
Hi, I'm testing dbForge studio for PosgreSQL. I'm trying to impot CSV file with french boolean value in a column ('VRAI', 'FAUX')... but it fails How can I handle that ? (PS : I cannot change the source CSV file)
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"
Attaching dbForge to a new version of SQL Server
My company pushed SQL Management Studio 19.0.1 to my computer but left SQL Management Studio 18.5 also installed. I cannot install or uninstall any software on my own. I've tried re-installing dbForge SQL Complete, but it remains connected to the 18.5
Database Explorer does not show all objects, even if 'Show All Objects' option is enabled for the connection.
Hi Team! I faced an issue with Database Explorer View when it does not show all objects, even if 'Show All Objects' option is enabled for the connection. The problem seems relates to the fact that query: SELECT * FROM ALL_OBJECTS WHERE OWNER = 'MY_SCHEME'
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
cant open View Table
My view table has quite a lot of lines and sub queries. Once i created it, i cannot open it via SQL, Editor or Generate script as CREATE. It just keep loading and eventually not responding. Kindly advise. below is sample query of how the view table looks
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.
"Profile server events" tool require VIEW SERVER STATE permission
"Profile server events" tool require VIEW SERVER STATE permission. But at the same time the original ms "SQL server Profiler" perfect work under the same account without VIEW SERVER STATE permission
'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?
[9.1.21] Unresolved error when using JSON_TABLE function against simple scalar JSON array.
For some strange reason, the following valid and correct JSON_TABLE command generates an error when executing the following statement in a new query window or stored procedure. SET @json = CONVERT('[1095, 1106, 1193, 1288, 1357, 1385, 1390]', JSON); SELECT
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
dbforge schema compare for mysql not generating html from command line
dbforge schema compare does only generate an empty report when running it from command line. From gui, everything works fine. The comparison itself looks fine, log files look good, just the report is not created properly. the generation seems to abort
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
How to browse Linked Servers - SQL Server
I’m using dbForge for SQL Server Enterprise, how can I use this to browse Linked Server objects? I can do this with SSMS’s Object Browser, but I’d like to not have to switch between 2 db tools.
Build Solution In MS hosted
Bonjour We have solutions .Net with differentes TargetFramework and version Devart Exemple Solution Number 1 TargetFramework : .Net 4.7.2 Devart version : 8.5.583.6 Version=7.1.40.0 Solution Number 2 TargetFramework : .Net 4.0 Devart Version=8.5.583.6
Next Page