Recent Topics
ScHttpServer and ResponseInfo.OutputStream
I would like to know what is the best way to use the ScHttpServer component to return an Outputstream. I have the following code in ScHttpServerProcessRequest, and it works, but when I release the stream, it stops working. try fs := TFileStream.Create(
Cant get ScSSHClient to work with key - not even following step by step instructions
Hi, I cannot get the ScSSHClient component to connect when using a key instead of a password. I've been trying out these steps: https://docs.devart.com/sbridge/index.html?client_configuration.htm Here's what I've done: create SSH server on Ubuntu, connecting
PostgreSQL column default values
Hi, I'm using PostgreSQL 15 with Delphi 11 and latest UniDAC components. Create a table: CREATE TABLE sample (col_a VARCHAR DEFAULT 'A'); Then use a TUniQuery that "SELECT * FROM sample", add a TDataSource linked to the query and a grid and dbnavigator
Issue with Dynamics ODBC
Good morning, We've a recurrent issue with this ODBC...every 2 weeks - more or less - we're not able to use it due to this error: We bought a full license months ago. We've tried several times what you suggested on previous communications: remove the
Trouble installing SQL Source control add-ins for SSMS
Hi all, Trying to follow the steps in the installation guide to evaluate this vs redgate, and the first bump is that the download link for source control goes to the DBForge SQL Tools download, and not a standalone installer. Ok, fine. I install the full
Update to 12.2 with C++Builder 12.0 not working
Hello support, I made an updaet tp 12.2 and got these errors. [C++ Error] Crtypes.hpp(230, 7): unknown type name '_DELPHI_CONST' [C++ Error] Crtypes.hpp(230, 29): cannot define or redeclare 'Int8' here because namespace 'Crtypes' does not enclose namespace
UniDAC Providers components disappear Delphi 11.0
Yesterday I downloaded the UniDAC trial version, installed under Delphi 11.0. Created a program that consisted of a connection, provider, data source, and a dbgrid. Got connected to my SQL Server and the grid populated with the results of the query. Fantastic,
Trouble reading response from websocket connect/call
Apologies for the newbie question, but do you have sample code on how to parse the OnMessage data array to a format that I can read into a memo field? Thanks! - Robert
dotConnect for MySQL is missing a detail on running a Update in ASP .NET MVC
I am attempting to follow the code snippets on the link shown below and have been able to retrieve and create new database records. dotConnect for MySQL Entity Framework Tutorial (devart.com) The issue is that trying this code snippet below doesn't actually
Can't install SQL Search version 2.7.25 for SSMS version 20.0
Hi, This is the error that I get. With SSM 19.X, it's working.
How to delete a Db in dbForge Studio for Postgres
How can I delete a database in dbForge Studio for Postgres (without running a command) I don't see such an option when I right click database
UniDAC 10.1.0 - StoredProcedure incorrect results
Database: Firebird. Since the update, it may happen that StoredProcedures return incorrect results. For some colleagues with Delphi 11 or Delphi 12 it happens that a TUniStoredProc does not return the correct result. But not with all of them, so unfortunately
dbForge Studio: Is it possible to work with diagrams (*.DBD) without being connected to a database?
Hi, I am trying out dbForge Studio and would like to use its DB Design features without necessarily being connected to an instance of SQL Server. Is this possible? Thanks and regards, Mario
How to draw/sync db with ER Diagram?
We are evaluating DBForge Studio for PostgreSQL, and in a prior position while using the DBForge for SQL Server, I saw that it had a ER Diagramming tool. Since PGAdmin is so very basic and lacks much, I was hoping to make up for that deficit with DBForge
Can I use dotConnect Universal with Entity Framework?
Hello, I'm very new to your product and I consider using it in our project. We need to have the ability to switch between two different databases - Oracle and Postgre. My question is would that be possible with dotConnect Universal while also working
Support .gitignore in dbForge Source Control (Feature Request)
Please follow .gitignore for SQL Objects. For instance, we have a convention to deprecate objects by prefixing them with "zzz_old_YYYYmmdd" and then waiting a few months before finally deleting them. Source Control doesn't follow the .gitignore file so
License issue when upgrading from EF Core 7 to 8
Hi, I am working on an application that uses the Devart.Data.Oracle.EFCore nuget package to read data from an Oracle 10g data base. Originally, my application was based on .NET 6.0 and Entity Framework 7. Recently .NET 8.0 was approved for usage within
"The client code page 65001 does not have a corresponding SQL Server Collation. InMemory Rowset creation failed."
A customer has set a Windows setting that was marked as beta, but is probably now required by several applications: Control Panel > Clock and Region > Region > Administrative tab > Change system locale button > Beta:Use Unicode UTF-8 for worldwide language
Error Adding DevartNHibernate Model
Hallo I'm using Visual Studsio Community 2022 And Entity Developer I uninstall it and check the Template Folders for existing ZIP Files and reinstall it with Admin USer Rights. But with the NHibernate Template I get this error: The EF Core Model works.
OperationalError: Trial period has expired
Hi guys! I'm trying use devart.ase lib for python (3.10) and i get this message: "OperationalError: Trial period has expired." Is this lib free for use? if not, how much is? and how can i get a valid license? Thank you in advance
Unexpected SqlParameterExpression implementation when using Oracle spatial functions in EF Core 8
We are planning to upgrade EF Core 6 to EF Core 8 along with upgrade from .NET 6 to .NET 8. We frequently use Oracle spatial functions: "SDO_RELATE" and "SDO_WITHIN_DISTANCE", which unfortunately do not have built-in support in dotConnect for Oracle according
Encrypted data is corrupt
I am considering purchasing a SecureBridge license to use in an older project developed with Delphi 7, I have installed the trial version. But this code gives error: Encrypted data is corrupt procedure TForm1.Button1Click(Sender: TObject); Var Request:
Unidac 10.1 (in)compatibility issue with Delphi 12.1 in 64bits mode
Hello, We came across an issue while trying to use Unidac from packages compiled with Delphi 12.1 (Version 29.0.51961.7529) on 64bits windows platform. At launch, the package tries to resolve a symbol called __init_record_FILENAME, which, was apparently
How to use UniDAC to connect to Borland's Paradox database
Hello everyone, I'm maintaining a legacy project, developed in Delphi 7, and using the Paradox database (plzl.DB). I now need to migrate the database using the UniDAC component, but I found that there is no Paradox option in the ProviderName property.
SQL Complete - Management Studio 20?
I just migrated to a new machine, and by default installed the current release of SQL Server Management Studio, which is version 20.0. When I installed SQL Complete, it doesn't add itself to SSMS; is this because version 20 is not yet supported? If this
Keep getting an exception of "ORA-00971: missing SET keyword" where SET keyword is there.
Hello friends, I keep getting an exception of "ORA-00971: missing SET keyword" for the following source code. I have no idea why. As you can see, it has SET keyword. Any ideas? Thank you so much! try { OracleConnection connection = new OracleConnection(_connectionString);
How can detect which driver is used by active TMSConnection?
Hello, How can detect which driver is just used by active TMSConnection from code.. For example if is used Native client 11 or Native client 10 or Ole db provider, or SQL server OLE DB driver 19 or 18....... etc... need something like this showmessage('Iam
SQL Complete Support for Synapse/Serverless
We are moving our SQL Servers to Synapse/Fabric, and are using the Serverless options. However SQL Complete does not work with these. Are there any plans on making it compatible?
Is DbForge for postgres unfinished ?
There is no designer for creating objects like: Tables PK and FK indexes triggers Functions Domains See this post from the year 2021 where it said it was in the plans and it's been 2 years. forums.devart.com/viewtopic.php?f=51&t=47836 I am very interested
Schema compare not syncing
Using the MySQL Schema compare I have a field in a view which does not sync, it sees the difference every time but does not update it. the difference is: CAST(LEFT(`assets`.`AssLocation`, 30) AS char(30) CHARSET utf8) AS `Asst_Locn`, and CAST(LEFT(`assets`.`AssLocation`,
constraint failed virutalquery
Hi, With the code below : //---- Ouverture de la tables des paramètres (L_PARAM_AS is a TUniTable component on L_PARAM_AS table in attach file) L_PARAM_AS.Open; //---- RequeteParametreDispo is a TVirtualQuery with L_PARAM_AS in source dataset RequeteParametreDispo.Sql.Text
SQL Statement Parsing Error
Greetings; In version 10.1.0 of UniDac I have a problem in type conversions with PostgreSQL, this problem was not present in the previous version. Example: "SELECT id, name::text FROM customer" In the example SQL statement I get an error in the "name::text"
Solution for .NET entity framework database connection using web API
We have a windows .NET application which is built using Entity framework and WCF. Looking for Database connectivity tool to stablish secure connection with SQL Server Database using web API
Firebird - RETURNING not working
Hello. I'm having problem in Firebird with RETURNING value with latest Unidac 10.1.0 on Delphi 11 update 3. Problem occurs when "same" query is used for SELECT and INSERT/UPDATE. I've attach db.txt with sample table T1 with three fields (ID,f1,f2). Here
UniDAC loading and saving Delphi TMemo
How can I load and then save a Delphi TMemo contents into an sqlite table?
Entity Developer and Composite Keys
Hello, Is there are way within Entity Developer, prior to code generation, to flag attributes, and remove the warnings e.g. Northwind db (image) so my generated code mappings won't have an issue. Thanks.
performance of simple "select count(*) from ....."
I run a simple "select count(*) from mytable", but it is quite slow. sqlite3 database. If I do it with sqlitestudio 3.3.3 I get the answer instantaneous. 264000 records. With unidac it takes 6 secs, when I set unidirectional = false or it is much worse
GetDate() error for Dynamics ODBC Driver
I'm getting an error message when I use GetDate() in a SQL query I'm writing using the ODBC driver. Basically I only want to pull records created today. Has anyone run into this issue and found a work around? Thanks
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
ItemInventory missing custom fields in QuickBooks Desktop
I'm trying to select from ItemInventory with a python script and I'm finding that the table structure is different, when I use the DevArt driver rather than the QODBC driver. Particularly, the custom fields are missing. I'm not seeing any settings in
Next Page