• 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
  • DDL Search works on comments on views but not stored procedures

    As the title states, I can search comments left in views but not in stored procedures. For example we lable all sprocs and views with "author: [INSERT NAME HERE]", yet a search for author only returns the views and not stored procedures.
  • Data comparison - Req "treat null" option to be split

    In Data Comparison tool, the "treat null and empty string as the same" option needs to be split into 3 options. Option 1, for strings: Treat null and "<string defined by the user - default = EMPTY STRING>" as the same value Option 2, for numbers: Treat
  • Unable to attach the Transact-SQL debugger.

    I just started getting this error about 5 days ago, I have no idea why?  I used to be able to debug my T-SQL using the "play" button, now I can't?? I was following this thread here until you moved forums a few days ago.  What I don't understand is that
  • Package load exception after upgrading to Visual Studio 17.4.1

    I just upgraded to VS 17.4.1 and now I am getting a 'devart code compare' did not load correctly.
  • ORA-01745: invalid host/bind variable name when using the same variable multiple times in EF7 query Where()

    Hi, were are currenly using Devart.Data.Oracle.EFCore v10.1.134.7 in combination with EF7 on net6.0. Whenever we use a query that uses the same variable 2 times or more in a Where() method we get an ORA-01745 exception. Example: var today = DateTime.Today;
  • support rad 12

    need support for rad 12
  • Salesforce ODBC - Update Record

    Whats the best way to update a record in salesforce using the ODBC driver? I have this setup as a linked sever in SQL Server Management Studio, and would like to update a salesforce record from a local table.
  • dbForge Studio for PostgreSQL

    does dbForge Studio for PostgreSQL Data Editor allow you to update bytea columns?
  • Connection lost

    Hello all, I moved the databe from Windows to Linux. And after this move my application is getting lost connection error. Is there an option in MyConnection component to handle such a problem? After loosing the connection all queries are getting problems...
  • SecureBridge for Delphi 12

    Hello, When is the plan to release Secure Bridge for Delphi 12? Regards, Bojan
  • dbexpsda doesn't works with fields with space

    Hi, My dbexpsda.dll gives an error using table fields with space like [Num. Registro] in SQL Server . Anyone can help me?
  • Problems with Batch Updates

    Even in the latest version of mydac I have problems with batch updates. (I told you already on the old forum) The problems started when you released a "faster" and "optimized" batch update ;) Now I can reproduce the error in my app. I have a main app
  • SSIS package task error with HardDelete

    I've created a Devart SalesForce Destination task with the HardDelete action. When I attempt to execute, it throws an error of: "...failed with error code 0x80131500 while processing "input"... ." The regular Delete action works just fine. Are there special
  • Next Page

  • Most Discussed Topics

  • A collection of enum array values get translated as (NULL, NULL ...)

    Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database
  • memory leak

    memory leak problem is very serious,memory uses will continue grow to several GB level.
  • Findkey in Cloned DataSet work?

    Hello, I would like to confirm a question. Does the FindKey method work on a cloned dataset? In my tests, it does not work. In the IBDAC documentation, a restriction is that the cloned dataset does not allow the use of filters. Is the fact that FindKey
  • Feature Suggestions for dbForge Studio for PostgreSQL

    1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply
  • Connect to MySQL with SSL and validate server certificate

    Hello I'm working with an Amazon RDS MySQL instance, and i'm sucessfully connecting to my db even when i'm providing a wrong certificate in MySqlConnection.SslOptions.CACert I only have CA certificate, no client certificate. How should I force the verification
  • Popular Topics

  • A collection of enum array values get translated as (NULL, NULL ...)

    Hello, I have found another regression since .NET 9. I am unsure which version specifically caused it because I can't test due to the other problems I have logged in the past. In any case, this worked in .NET 8. We store our enums as a string in the database
  • memory leak

    memory leak problem is very serious,memory uses will continue grow to several GB level.
  • Feature Suggestions for dbForge Studio for PostgreSQL

    1、Allow schema switching within the query interface. 2、Add an option to generate a complete CREATE script for the current database via right-click context menu on the database node. 3、Introduce batch filter configuration in data comparison (e.g., apply
  • Connect to MySQL with SSL and validate server certificate

    Hello I'm working with an Amazon RDS MySQL instance, and i'm sucessfully connecting to my db even when i'm providing a wrong certificate in MySqlConnection.SslOptions.CACert I only have CA certificate, no client certificate. How should I force the verification
  • Newer Version of SQL Complete Breaks Stream Deck Macros

    Using SSMS 20.2. Stream Deck https://www.elgato.com/ca/en/s/welcome-to-stream-deck is a piece of hardware or an app that hooks up to your PC and provides extra macro keys. I have text strings assigned to some of these macro keys. Until SQL Complete v7.0.362
  • 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 Install MySQL on Windows Using MySQL Installer

    The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with ...