• Connecting to PostgreSQL or MSSQL Using Oracle Database Link and ODBC Driver

    I want to connect PostgreSQl and MSSQL in Oracle using dblink. I do everything from this page https://docs.devart.com/odbc/postgresql/oracle_dblink.htm and it doesn't work. Please help

  • Foreign Key violation with 11.0.0

    I recently updated SDAC to 11.0.0 (Delphi 7) and made a few tests and all seemed ok. This morning I had an Issue arise with a migration application, The main difference with this is the application connects to two MSSQL databases and allows our customer

  • Concurrency violation when updating SQLite database using DevArt ODBC Driver

    Hi, I'm trying to debug errors produced when updating an SQLite database using the DevArt ODBC Driver from a Win32 application. I'm using COM/MSADO in C++ to interface with the Microsoft OLE DB Provider for ODBC Drivers, which in turn uses the DevArt

  • Strange behavior when opening and saving documents to OneDrive

    I have dbForge Studio 2022 for Oracle PE v4.4.64. At my work, I save all my work in OneDrive. For years I have become used to a behavior where, a few seconds after saving a file, I am prompted like this: I assume some file properties were in motion while

  • This server version 8.0.36 is not currently

    dbforge version : dbForge Studio for MySQL Enterprise 9.0.338.0 mysql version：8.0.36 connect error：This server version 8.0.36 is not currently

  • ODBC Driver for SQL Server with DBExpress

    I Want to know if it is possible to work with the ODBC Driver for SQL Server using dbexpress connection with Devart drive ? and how should I configure tha parameters connections ?

  • Remove Transaction

    Hello, i am creating at runtime a update transaction based on the edit form : Var FUpTrans: TIBCTransaction; procedure OnFormCreate; begin FUpTrans:= TIBCTransaction.Create(AOwner); <-- AOwner = Form FUpTrans.Active := False; FUpTrans.DefaultCloseAction

  • IBCQuery1.LoadFromXML(File)

    Hello Devart Team, All is on the Title. I need this scenario : 1. Saving data to an XML File : IBCQuery1.SaveToXML(aFile); 2. Retreiving these Data from this aFile, something like : IBCQuery2.LoadFromXML(aFile); As IBCQuery.LoadFromXML does'nt exists,

  • Proxy connections in Direct Mode

    Hello, I know that proxy connections are not supported in Direct mode. My question is - will they ever be? Is this something on your to-do list, or is there some reason that this is not possible? Thank you. John Dorlon

  • Code debuging

    Hi, where is debug menu items ? Thank you.

  • CRDBGRID Number format of summary row

    Hello, does anyone know how i can set the number firmat in th tcrdbgrid summary row? I use this grid as a generic SQL table view. In the programme the displayformat of each field is set (floating and integer). The grid will show me the values. But right

  • Magento ODBC Driver with Filemaker

    I am trying to use the Magento ODBC driver with Filemaker, but this is totally useless. My first try was the category DB which has something like 100 records. And this worked fine, after about 10 seconds the table was available. Of course that is still

  • Support Fastreport 2024.1

    Can you add Support for Fastreport 2024.1 to use the FastqueryBuilder. In FastReport are come Changes and it will be fine to use ther frxUnidac Component with the QueryBuilder.

  • ERROR: devart_ase_connector-1.0.1-cp37-cp37m-manylinux_2_34_x86_64.whl is not a supported wheel on this platform.

    Guys, I'm trying to install the "Python Connector for ASE 1.0 - Python 3.7 for Linux" library on Linux and I ended up coming across the following message: ERROR: devart_ase_connector-1.0.1-cp37-cp37m-manylinux_2_34_x86_64.whl is not a supported wheel

  • Problem with Firebird ODBC on Ubuntu

    After setup and running isql -v DEVART_FIREBIRD I get: [S1000][unixODBC][Devart][ODBC][Firebird]Cannot load library: libcrypt.so [ISQL]ERROR: Could not SQLConnect Here is my setup [ODBC Data Sources] DEVART_FIREBIRD=Devart ODBC Driver for Firebird [DEVART_FIREBIRD]

  • VirtualQuery To_Date

    Hi, I need to write query in VirtualQuery with To_Date syntax what is the correct way to do it, what is the engine behind VitrualQuery ? Thanks.

  • Suggestion: add "Encoding" parameter to TIBCScript.ExecuteFile()

    Hi, my database is all UTF8. If I load a script in UTF8 format(*) using TIBCScript.ExecuteFile(), all german "umlauts" are scrambled. Funny enough, if I set "UseUnicode" option of TIBCConnection to FALSE, then it loads correct. But then all other inserts

  • Find and replace dialog - look in All open documents

    Hi, Find and replace dialog often suppose look in All open documents As for me it's very special case and most user will prefer Current Document by default.

  • current_schema ?

    Hi, how to set current_schema ? Yes, i can make it using ALTER SESSION SET CURRENT_SCHEMA = but 1. It's not convenient 2. In database explorer tree view staying old schema I think this feature should be integrated in interface.

  • EntityDac save entity to mariadb

    I use entitydac context. in Delphi12 and entityDac 3.3.0 var predpokladanaoperace := entitycontext1.CreateAttachedEntity<TTOrderWork> ; predpokladanaoperace.OrderId := 'zakazka000001'; predpokladanaoperace.TsLastchange := now(); predpokladanaoperace.TsCreated

  • Entity Developer - generated metadata error - Delphi and MariaDB

    Hello, in table are BIT type fileds. After generate code are errors in datamodel.metadata.pas file now in source code: FKontrolamnozstvi := TMappedAttribute.Create(Self, 'Kontrolamnozstvi', etBoolean, False, 'KontrolaMnozstvi', False, False, 'b'0'', 'BIT

  • Insert into Sybase: The token datastream length was not correct. This is an internal protocol error.

    I'm trying to insert data into a Sybase table, with Python, (with one column) through a procedure and I'm getting this error message. "The token datastream length was not correct. This is an internal protocol error." Below is the code I'm using: my_cursor

  • How to send plain text ScSslClient

    I want to start using ScSslClient to connect to my ICS component SslWSocketServer. Connection happens successfully. Issue is when I send some data it shows as junk (unicode characters) at the Server Side. Kindly let me know if I am sending text wrongly.

  • SDAC Support for 'Always Encrypted'

    Hi Our Delphi application uses SDAC components (TMSConection, TMSQuery etc). I would like to know whether these support SQL Server 'Always Encrypted'? Thanks and regards Vinod A S

  • EntityDac save entity to mariadb - using FireDac

    I use entitydac context. in Delphi12 and entityDac 3.3.0 var predpokladanaoperace := entitycontext1.CreateAttachedEntity<TTOrderWork> ; predpokladanaoperace.OrderId := 'zakazka000001'; predpokladanaoperace.TsLastchange := now(); predpokladanaoperace.TsCreated

  • unidac + oracle direct mode + non blocking mode

    Hi, another question around non blocking mode. the actual working seetings - unidac + oracle db - direct mode - disconnected mode for me the non blocking mode doesn't work very smoothly as it blocks sometimes the entire main thread which the exact reason

  • monitoring evolution table

    Hello, I have a schema table A which is populated , I want to compare it against another reference schema table B and recover all the data changes, is this possible with Dbforge compare? Thanks. Regards Damien.

  • Salesforce ODBC driver - select from ContentDocumentLink slow buggy

    Hello! I am running this simple query in SSMS via a linked server against the ContentDocumentLink table. It its not only EXTREMEMLY slow, bit it does not respect the LIMIT clause and keeps slowly pulling more records into the output window maybe 30 seconds

  • MSAccess Direct Mode

    Hi, With version 10.1.0 you add support of : MS Access data provider Added support for Direct mode How can I use it and is it working with old access database (.mdb) Regards,

  • Select and update

    Hello I have a stored procedure that returns data and updates a table. How should I execute it to retrieve all the rows it returns and ensure that the changes are saved in the database? Thank you

  • where is trigger tab in table editor window ????

    Hi where is trigger tab in table editor window ???? i see columns, constraints, Indexes, Options, Date but, triggers ???? Is it exists only in Database explorer tree ?

  • unidac, oracle, direct mode, disconnected mode, non blocking - cancel query

    Hi, i am using unidac to connect to oracle in direct mode, disconnected mode, non blocking and i have sometimes SELECT queries which are last long. I want to cancel them. The query will be triggered from the main/ui thread. How to do this? Do you have

  • SQL Server Source Control - which Git client is needed?

    SQL Server Source Control - which Git client is needed? instructions state Git client for windows must be installed. We use DevOps for our Visual Studio / C# code. I was unsure exactly which Git client to install, and was skittish about changing any existing

  • where is window splitting for procedures and package window ?????

    where is window splitting for procedures and package editor window ????? is this possibility a big technical problem ?

  • VirtualQuery DataMaping Unidac 10.0

    Hi, I use the code below : try //---- Création TableP_MESURES := TUniQuery.Create(Self); try //---- Création WQ := TVirtualQuery.Create(Self); //---- Source de données TableP_MESURES.Connection := FicheModuleDonnees.Connection; WQ.SourceDataSets.Add(P_VLC,

  • Error message since version update

    We are using Delphi 10.2.3, wth WIndows 10 Since today, Securebridge 10.2.1 worked fine. But today, we updated to 10.3.1, and since then, the previous sftp connections are not working. I checked the application, which was compiled yesterday, with the

  • SecureBridge "Trial expired" right after install

    Newly-downloaded SecureBridge is giving "Trial period has expired" message. I just downloaded SecureBridge for Delphi 12 and installed it. (2024-02-09) I loaded and compiled demo SFTPClient and ran it. In the SSH configuration area I filled in server

  • Can´t compile x64 Package dacsbridge280

    Hello, i can´t compile the x64 Package for Securebridge 10.3.1 in Delphi 11. The Error are [dcc64 Fataler Fehler] CRSSHIOHandler.pas(10): F2084 Interner Fehler: URW7676 I reinstal the SBridge and try also the latest Version as Trial -> Same The Path are

  • How to add the activation key to SQL Server without Visual Studio

    Hello. We have SSIS Dataflow Components for SalesForce installed on an SSIS SQL Server. However Visual Studio is not installed. How can we activate the product without Visual Studio? I found one other thread on this topic that advised copying a .lic file

  • MAX number of connections reached

    hi. I have a C# .net WebForms app with several hundred users. it is running on windows server 2016. my connection string looks like this: value="direct=True;Min Pool Size=5;Max Pool Size=200;Validate Connection=true;Connection Timeout=5;Default Command

  • Next Page

  • Most Discussed Topics

  • The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.

    I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created

  • Invalid Typecast exception on Insert/Update blobs

    Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++

  • Oracle - EFCore - Hints

    Hi, I am trying to use OracleFunctions.Hints("ALL_ROWS") in a project that is using Devart.Data.Oracle.Entity.EFCore. What is the recommended way to add Oracle optimizer hints in EFcore ?

  • How do I show the Functions/Procedures within a Package

    I'll be respectful since I'm a user that has used Oracle Toad for probably 20+ years. The list below are features available within Toad and I don't see how to accomplish these tasks within dbForge Studio for Oracle. How do you display the Functions/Procedures

  • Will dbForge for Postgresql filter out comments when submitting queries?

    Will dbForge for Postgresql filter out comments when submitting queries? If filtering is applied, it is recommended not to do so, as certain features of Alibaba Cloud Polardb may become completely ineffective. pg_hint_plan - PolarDB - Alibaba Cloud Documentation

  • Popular Topics

  • Invalid Typecast exception on Insert/Update blobs

    Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++

  • The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.

    I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created

  • Virus scanner alarm - Trojan found

    Hello, this morning I received an update message for the installed test version of SQLTools. After downloading the sqltoolsent.exe file from the download area at devart, I started the installation. Unfortunately, I received the following messages from

  • Sql Complete v2025.1.134 won't switch to express license

    I updated to v2025.1.134 for SSMS 21 but somehow my Express license was reset and I'm now back in the "Enterprise" license trial mode. The previous solution of setting HKEY_CURRENT_USER\Software\Devart\dbForge SQL Complete\Activation\UseExpress to 1 isn't

  • Advice on which Unidac components to use in android app

    I have a small personal android app which accesses a sqlite database with several tables. The app is single user, no db sharing. Only one table open at a time. Browse, add, edit, delete, search. I currently am trying out a TUniconnection, and a TUniQuery

  • Popular Articles

  • How to Download and Install a Previous Version of the Product

    If you need to download and install an earlier version of a product, other than the latest release available on the website, follow these steps: Uninstall the Newer Version: To install a previous version available under your license, you must first ...

  • How to Connect to MySQL Server

    In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

  • How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools

    If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...

  • Cannot Open Table ‘Case’ and ‘Order’ in SSMS with ODBC Driver for Salesforce

    When working with SQL Server Management Studio (SSMS) and the Devart ODBC Driver for Salesforce, you may encounter difficulties accessing certain tables such as Case or Order. Important Note on SSMS Behavior Queries in SSMS are first processed by SQL ...

  • How to Activate a Trial Version in dbForge Products

    Starting from release 2025.1, the method of using the trial version and Express Edition has been updated for all paid dbForge products. To help you get started smoothly, please follow the step-by-step instructions below. As of version 2025.1, ...