Recent Topics
Batch move and creating destination table in Access
Hello! I'm experimenting so that we can move away from Paradox onto something a little bit more useful. For the time being, however, the "temporary fix" is Access. Let's not go into the why, how, etc. For now this is the best course of action. The access
Define ClientID and ClientSecret in Dynamics365 ODBC DSN
Hello, how is it possible to store a ClientID and a ClientSecret in a Windows ODBC connection for the Devart driver in the ODBC Manager? I only see the option to generate a token, and I am then prompted to log in. However, I would like to create an app
Secure bridge sign PDF
hello i need help about signing some PDF file, with secure bridge... Some examples, sign with PFX or from smart card...
.NET 9 - Devart.Data.Oracle.EfCore - NullReferenceException
Hi, On EFCore 9, with today driver v10.4.191.9, many operators are failing with this error : System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.EntityFrameworkCore.Query.SqlExpressions.SelectExpression.PushdownIntoSubqueryInternal(Boolean
.NET 9 - devart.Data.Oracle.EFCore method not found
Updating everything for .NET 9.0 and suddenly I get the following error: System.MissingMethodException: 'Method not found: 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlConstantExpression Microsoft.EntityFrameworkCore.Query.SqlExpressionFactory.Constant(System.Object,
Is there a better way to view this panel info?
When viewing indexes for a table, the index "details" panel (see image attached) is incredibly awkward, being compressed into a small space. Is there a way to better view that panel to use it more easily? e.g. a different window/panel arrangement or an
MMOexp New World to the gameplay
In the vast world of online gaming, few titles have generated as much buzz as Amazon Games’ New World. Set in the mythical land of Aeternum, this mmoexp invites players to explore a vibrant open world, engage in combat, and establish settlements. Following
Rsorder OSRS gold in hopes
Playing an Ironman account on Old School RuneScape (OSRS) has become an increasingly popular challenge for players who want to take the game to a new level of difficulty and satisfaction. Ironman mode restricts trading and other forms of assistance from
MMOexp Diablo4 with the combat
Since its launch, Diablo 4 has captivated players with its dark, immersive world, engaging storyline, and a robust system of character customization. With numerous gameplay elements to explore, one aspect that stands out is the game's tiered difficulty
Compare to schema inside same database
Hi, I started to evaluate DbForge Studio for PostgreSQL. I wan't to compare schemas inside database. (I mean those schemas which are created by CREATE SCHEMA myschema); our use case is for example a franchising chain, where all companies are under same
ODAC local filter raises EVariantTypeCastError
We have tried to use a newer ODAC version in production. The following issue is a showstopper for us. It seems that this issue exists since version 12.3.0. Steps: - compile and execute the following command line application Expected: the output is PASS
SecureBridge TscSSHClient irregularly causes critical crash in FMX app on IOS when disconnecting
Hello, after refitting a mobile application with SecureBridge to enable SFTP data exchange I have encountered the following problem: In irregular intervals the app crashes fatally when performing an SFTP data exchange. With the help of the debugger I
DBExpress driver for PostgreSQL
Hello, I've read that you can't use multi transaction with Devart drivers for PostgreSQL. But I also read that PostgreSQL seemed to support it. Can you tell me what's going on? Thank you in advance. Lbn69
Sqlite support to Microsoft Visual Studio Community 2022 (ARM 64-bit)
I'm using Microsoft Visual Studio Community 2022 om a macbook pro M4. Everything work just fine except dotConnect for SQlite. Using latest version 6.4.190 Getting error when try to open SQLiteConnection in debug mode. Application is running fine standalone.
ODAC: "Invalid Field Type" when calling a stored function with VARCHAR2 params
We have developed a VCL application in C++Builder, using RAD Studio 12 Version 29.0.51961.7529 (Version 12.1 basically) with a target platform Windows64. Our database is Oracle 19 running on an ODA with latest patches. The problem always occurs when I
EntityDAC developer on Oracle
Hello, I'm trying to use Entity Developer to generate model for my Oracle database. It seems that after model generation some table are not still present in the database. I'm using Entity Developer version 6.12.1354 trial. Thank you, Luca
dotConnect C# MySQL: Setting charset at global level?
I'm using the generated great TableAdapters in C#, where I had errors with my Hungarian strings (containing á, é letters) until I added any of these before opening the connection: this.Adapter.InsertCommand.Connection.Unicode = true; this.Adapter.InsertCommand.Connection.Charset
When connect via SSH to Mikrotik, the byte stream is broken
For example, when executing the command: ip/service/print detail proplist=port value-list where name=api We get the result: ip/service/print detail proplist=port value-list where name= [admin@MikroTik] > ip/service/print detail proplist=port value-list
How to specify Time Zone format
Hello, It looks like there is now a way to specify time zone format in ODAC. How can I specify it in my code, if I want timestamps in query results (like a TSmartQuery attached to a grid) to always have a specific format. I want to use TZR, to solve the
Access denied for user 'x'@'ip' (using password: YES)
Hello, This is maybe a strange question, but I am evaluating the mysql connector and I started by trying to generate a model Entity Developer (with entity framework - database first approach). The problem is that I am not even able to connect to my server,
Intellisense/Suggestions for Locally Created Temp Tables?
I create local temp tables and query from them often in my script. In my previous installations of SSMS with (and without) SQL Complete, I was able to write "SELECT * FROM #" and would receive suggestions for available temp tables to query, including
Universal Error in Mysql
hi all ! Im getting the following error and I dont know whats causing it. Exception thrown: 'System.NotSupportedException' in Devart.Data.dll UniDbType not supported by current data provider This is how I setup the connection public new Devart.Data.Universal.UniConnection
SQL Formatter Select List Margin Break
Hi there. Is it possible to break the SELECT list at a particular margin point? I'd like to leave the Select List "Stack Columns" option as Single Line, but I'd like to be able to specify when the Select column list should break to a new line. Is this
Module Class connect() method ConnectMode = "Unsafe" parameter
Hi All, I am using this connector for a few days now and I am quite happy with it. Recently I had to deal with a connection to a 3rd party Visual Foxpro database in which I couldn't connect because the dbf file I wanted to access was locked by another
XDBGrid sort function doesn't work
I'm using the XDBGrid sorting feature in FireDac, but it doesn't work in uniDac. If you have any solutions, please let me know. XDBGrid Designer -> Contrlo2 -> sortingControl
Solution made with Mysql for Visual studio 12.0.1
Hello, I am trialing Devart dotConector with Visual Studio 2019. I have a full vb.net solution, which has datasets (XSD) created by MySQL for Visual Studio. I was hoping to just migrate these across to use the Devart.mysql.data namespace (from Mysql.Data.mysqlClient)
opened connection by an exception
In the TCustomPgDataSet.Execute(PgAccess) becomes TCRConnection.FAutoCommit(CRAccess) set to false and not reset after the exception in the RefreshRecord. Then the error dialog, through our THauptForm.ShowServerTimer a ConnectionCheck with "Select true,"
Passing parameters to TUniStoredProc without SELECT privilege
Hello. I have MySQL database with some of the stored procedures for accessing data in it. The only global privilege enabled is EXECUTE, others are disabled. I'm trying to call a stored procedure in MySQL database with the help of TUniStoredProc using
Firbird 5.0 / Substring in IbcQuery.Filter
Hello devart team, Try to filter an IbcQuery (latest release) with firebird 5.0 : IbQuery1.Filtered :=False; IbQuery1.Filter := Substring( MyField from 1 for 5) = 'Hello' IbQuery1.Filtered :=True; This rise an error : "Substring is an unknown Field" (Something
SOQL queries - field/column aliases not recognized and/or toLabel() function duplicate field errors
Currently running Devart ODBC Driver for Salesforce 3.4.1, set up as linked server in MSSQL 2019 (15.0.4405.4), and I don't seem to be able to use field aliases when running SOQL queries via an OPENQUERY statement. For example: SELECT * FROM OPENQUERY(PCCUSFPROD,
Schema compare for PostgreSQL free and commercial editions (dbForge Studio for PostgreSQL)
Is there any difference between Schema compare for PostgreSQL free and commercial editions (dbForge Studio for PostgreSQL)?
.Net 9 / EF Core 9 support
Hi, What is the roadmap / delay to support .Net 9 / EF Core 9 on the Devart.Data.MySql.EFCore library ? Regards.
Data management system
Data is the backbone of generation
Access Direct Mode Connection Fails if Database has a Query (View)
We get EAssertionFailed with a message beginning "jTYPE_ATTRIBUTE" (JetTable.pas line 5126) when using an Access database in Direct mode, but only if there is a query defined in the database. We are using UniDAC 10.3.1 for Rad Studio 10.4. Recent release
This server version 17.1 is not currently supported
I installed the latest dbForge Studio for Postgres. Running on windows 10. Postgres container (latest version from last week) is running in docker desktop for windows on port 5432. When I am creating the connection, dbForge studio is able to connect and
How to disable formatting of Stored Procedure/Function code in backup?
In some Functions I format the code myself. However, in the backup copy my formatting is lost, and instead it is replaced by automatic formatting. How do I prevent this? I use dbForge Studio 2020 for MySQL
Live Data
In the latest version of dbForge Studio for SQL Server is there any 'live data' functionality to show rows populating as a simple query executes instead of having to wait for the entire query to finish before showing results? For example: select * from
SQL Complete Execution History Import
Is there a way to move over query execution history from one computer to another?
Set connection parameters via command line
Hello, we would like to use dbForge for MySQL with PAM solution (not Percona) that requires setting connection parameters via command line (username, password, dbname) to launch dbForge for MySQL application on Windows. Is that possible?
UniLoader has problem with importing data to a table with default value columns in MSSQL.
Hello, UniLoader has problem with importing data to a table with default value columns in MSSQL. I received an "unspecified error" message. If I provide the data myself, it works fine, but I would like the data to be filled with the schema's default value.
Next Page