• IBDAC Fastreport integration

  Hello, I'm using IBDAC (latest version) in combination with Fastreport (latest version). In the parameters i send to Fastreport i also send the location of the database. I have IBDAC database component in the report and i set the path correctly to the

• Error deleting record from table

  I am trying to delete a record from a table, and receive this message: Incorrect Syntax near 'Index'. If this is intended as part of a table hint, A WITH keyword and parenthesis are now required. See DQL Server books Online for Proper Syntax. I am using

• Program refused to run with SQL server access error, Before tmsconnection is connected

  Hi, From a Windows 10 Pro workstation (in a workgroup) I am having problems connecting to a SQL server 2022 (Express) on a Windows 11 Pro machine (same workgroup), using Windows Auth. I have setup the SQL to allow both Windows and SQL server users, and

• Unable to load extensions in version 4.3.1 on Delphi 7

  Hi, Setting the option EnableLoadExtension in AfterConnect has no effect. Debugging the driver shows that TSQLiteConnection.Connect is called before TSQLiteConnection.SetProp. Hence, the call to sqlite3_enable_load_extension made from TSQLiteConnection.Connect

• Swapping Connectionstring between Prod and Development

  Hello, Using latest SDAC and Delphi 11.3: Today I forgot to change the connection string in an application I sent to a customer. That made me think if there would not be a better, and simpler, method than to replace the connection string and recompile

• Asp.net project Getting Devart error during build pipeline (Azure Devops) - License compilation file - Unable to resolve type 'Devart.Data.Oracle.OracleConnection,

  Asp.net VB Project. It has Class library project & Asp.net website project in solution. Builds in dev machine. During Azure Devops build pipeline, getting below Unable to Resolve Type error during license file compilation. Please help on resolving this

• Connecting Delphi client to .NET FireDAC alike server ?

  I am aiming to replace Delphi FireDAC based server with .NET C# ASP.NET server which to keep providing the FireDAC requests to the Delphi clients. Is there such a thing ?

• Cannot connect to SQLServer in os authentication mode

  Hello! Delphi 11.3 Pro. This is my connection configuration: object UniConnection1: TUniConnection ProviderName = 'SQL Server' Port = 1433 SpecificOptions.Strings = ( 'SQL Server.Authentication=auWindows') Server = 'DESKTOP-4J9A9E5' LoginPrompt = False

• Postgres

  Estoy trabajando con el componente tunisql con una base de datos postgres, el problema es cómo recupero el id usando esta declaración: ON CONFLICT DO NOTHING, devolviendo id

• SignalR

  Hello, i need help with SignalR component. I have SignalR Client application (C#) The below code received the message from server and send result to the server: connection.On("GetResult", async (string StationID) => { var result = await Console.In.ReadLineAsync();

• SSL Support in Express Editions

  Would like to know why in light of emphasis on security in managing and access to databases these days that you took the frankly moronic decision to not include SSL support in the express editions of the tools. Even free open source tools like heidisql

• TUniLoader - Oracle 19c: Direct path loading is not supported in Direct mode

  Hello, we are currently using version 8.4.4 of the "Universal Data Access Components" for Delphi 10.4. For copying data we use the component TUniLoader, which has worked without any problems so far. We now want to copy data from one Oracle 19c instance

• EORAERROR - ODAC DB Exception

  We would like to handle exceptions according to the error number of the EORAERROR class. I would like to know the defined error number and message-related meaning. The following is an example of handling major exceptions when an error occurs when executing

• UniDac Disconnected Mode Bug

  I am using Delphi 11.3CE and UniDac 9.4.0 trial version, the problem is like this, I create two connections, one connection to SQL SERVER, one connection to Oracle (Disconnected are assigned to True), create two Query and set up the corresponding connection,

• Upgrading SSIS Data flow for Salesforce Issue with License

  Hello, We are using the SSIS data flow component 1.7.x for salesforce. It has been working for years. Now we have migrated servers (SQL2014=>SQL2019) and when deploying the SSIS Package and scheduling it to run using SQL Server agent we get "Cannot find

• Source controle for git doesn't detect git folder

  The folder has been clonned with visual studio with this result: When we set the folder in source controle he doesn't detect the git.

• Data Generation Wizard only lists tables from one schema

  Using dbForge for Postgre SQL (version 3.1.701) I connect to a simple test database. The DB happens to be in google cloud as a CloudSQL Postgres. The db has tables in 3 schemas (public, immutable, version3). I fire up the data generation wizard. After

• Change notification is not supported in Direct mode

  Hi I would like to use change notification but i looks that this feature cannot use in Direct mode. Is there a workaround using change notification in Direct mode because our clients have no Orcale client installed. br, Robert

• Is dbForge Studio for SQL Server in evaluation version?

  Hello, I have just downloaded SQL complete tools and I don't find this product dbForge Studio. Is it a different product? Thank you in advance.

• MS SQL Date and Time fields seen as TWideString fields by Delphi

  Hi All, I know this is not a SDAC created problem, but nevertheless, it is a problem for me, using SDAC and MS SQL tables with Date and Time fields. It's with Delphi 11.3 on Win 10 and 11. The problem is that Delphi see MS SQL Date and Time fields as

• xmlserialize problems in direct mode

  For demo, PLS create table CREATE TABLE XML_TEST ( ID NUMBER (9,0) NOT NULL, XML_COL XMLTYPE ) / ALTER TABLE XML_TEST ADD ( CONSTRAINT XML_TEST_PK PRIMARY KEY ( ID ) / You don't need any data to reproduce. Create a new 64-bit application and add TOraSession,

• Trail Period has expire, but I updated the license key and Still Fails

  Trail Period has expire, but I updated the license key and Still Fails. TITLE: Microsoft SQL Server Management Studio ------------------------------ The test connection to the linked server failed. ------------------------------ ADDITIONAL INFORMATION:

• SQL Complete with large databases

  Any tips for tuning SQL Complete with large databases? I work with ~100 similar databases across multiple servers. Each database has ~65k tables, ~100k stored procedures, 15k functions etc. I've read that SQL Complete shouldn't cause SSMS to freeze -

• ODBC DRIVER FOR XBASE ERROR

  HELLO IM TRIYING TO CONNECT TO THE DE .DBF FILES OF MY ERP. BUT IM GETTING THE FOLLOWING ERROR IN POWER BI: DataSource.Error: ODBC: ERROR [HY000] [Devart][ODBC][xBase]table CLIENTEAC already exists Detalles: DataSourceKind=Odbc DataSourcePath=dsn=TRY

• Bug UniScript

  Attached is a demo project the event cannot continue even using procedure TForm.UniScript1Error(Sender: TObject; E: Exception; SQL: string; var Action: TErrorAction); begin Action := eaContinue; end; This Script can be executed by IBExpert by creating

• internalcalc Necessary facilities

  I'm using "unidac" comps for "delphi" with "tclientdataset" I want to use "unidac" comps without "tclientdataset" before I was use it with "tclientdataset" and use internalcalc field as in-mem field I was change it whenever i want "Devart" add internalcalc

• Assertion failure

  Welcome, I am using delphi 10.4 Update 2. with UNIDAC 9.4.0. The component is used in a multi-threaded service. Due to load balancing, this service is running on multiple machines. On one of the application servers (only one), the following error message

• ODAC Oracle RAC SCAN direct mode support.

  Hello, I was curious of Oracle SCAN name is supported with ODAC and using direct mode. We have an application we are trying to connect to an Oracle cluster using SCAN and it works fine with the Oracle client but not using the SCAN name with direct mode.

• Event when a connection is taken or put back into the pool

  Hi, Is there an event when a connection is made or reset in the pool ? Thank you

• Query - ParamByName

  Hello. RAD 11.3 / Unidac 9.4.0 / Windows 10 Pro version 22H2 I have problem with ParamByName in Query component. Field in Table is defined as CHAR(1) SQL: Select * from <table> where <field> LIKE '%A%' If the code is Q.SQL.Add('SELECT * from <table> where

• Error Log Recorded

  We are getting a lot of security alerts from our SQL Server that triggers from dbForge Studio 2019 Express for SQL Server. It spams our SQL logs for failed log in attempts (currently from one user that uses this application) very frequently through the

• Connecting Postgresql with certificate

  Hello We need to connect to the Postgresql database with a digital certificate, how do we do it?

• UniDac ilink32 warning

  Hello. RAD 10.4.2 / Unidac 9.4.0 / Windows 10 Pro version 22H2 I am getting the warning below: [ilink32 Warning] Warning: Duplicate string: ID 102; File C:\PROGRAM FILES (X86)\DEVART\UNIDAC FOR RAD STUDIO 10.4\LIB\WIN32\DBACCESS.RES string kept: "Password";

• Parameter.AsString for an integer field results in a "record not found" error

  Hi, With Delphi 5 + V6.11.23 of SDAC components + request : select * from TABLE where KEYFIELD = :Key + ParamByName('Key').AsString := '123' with Key integer field evrything works fine with SQL Server 2016 with SQL Server 2008 (or 2012, not sure), error

• Urgent: Does DBForge Source Control Support Azure SQL MFA Authentication & Object Locking in Shared Mode ?

  Does DBForge Source Control Support Azure SQL MFA Authentication & Object Locking in Shared Mode ?

• Closing UniDac VERY slow

  I have been using UniDac for years, currently in Delphi XE10.3.2 with Firebird 3 and for one particular UniDac query I have come up with a (to me) strange problem. It is taking about 8 seconds to close. The query is fairly simple (basically just a SELECT

• type mismatch for field ‘xxx’ expecting string actual widestring

  Hi all, I'm using SDAC 10.3 on Delphi 11.3: I got the above mentioned type mismatch, as I had created my SQL tables with NVarChar, and had persistent fields in my MSTables on the form. I found a description for the problem and a solution on this forum,

• How and where do I set UseUnicode in sdac 10.3

  Hi All, I have asked this question in a previous topic, but with another angle and more complex description. The simple question is: How and where do I set UseUnicode to False. I'm using SDAC 10.3 in Delphi 11.3 Regards Soren

• Automatic choice of provider

  Hello, We're wondering about the algorithm that chooses the provider to use to connect to a SQL Server instance when the Provider property is set to prAuto. According to the documentation (and the UniDac's source code), the Native Client is prefered over

• NTDLL.DLL error when calling mstable.open, from an inherited form

  Hi All, Using SDAC 10.3 and Delphi 11.3: I have a form, with 2 MsTable, which it has inherited from a standard form. On the standard, the Connection is pointing to a DB module with the MSConnection, but no tablename. In the inherited form, I set the tablename

• 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 ...