Recent Topics
Как правильно работать c компонент Encryption Unidac Firebird3?
Добрый день Подскажите пожалуйста как правильно работать c компонент Encryption Unidac Firebird3? то что работал Ibdac перестал работать Unidac База Firebird 3 тип поля VARCHAR(2000) CHARACTER SET OCTETS COLLATE OCTETS В Ibdac работает но в Unidac после
Snapshot functionality or getting sqlite3* connection handle from SQLiteConnection
I need the snapshot functionality offered by SQLite as described here: https://www.sqlite.org/c3ref/snapshot_get.html but in context of a SQLiteConnection in turn used with Enity Framework 6. As far as I can see dotConnect for SQLite does not support
IndexFieldNames
Hi, I need "natural sort" as a sorting algorithm to use with IndexFieldNames. For natural sort see: https://en.wikipedia.org/wiki/Natural_sort_order I have an article number field as varchar. Some of my customers have article numbers with mixed letters
Is there a way to extract whole postgres schema without the data ?
Hello I am looking for a solution to extract all my postgres schema to a file. DDL format would be nice. Thank you for help!
Installation Questions
I am installing dcoracle101pro.exe on a server that functions as a development environment as well as a production web server. When I attempted the installation it said that it was going to remove any old versions and I told it to go ahead and then another
Export results from dbForge Search within SSMS
Hi I've done a search for the name of a table, and have a list of around 40 results. I need to go through each of these items and check / update some code. However, I'm not going to get it all done today, so I'd like to export the list of results to a
Automatic Timestamp Macro
Hi, I found this topic and I think this is still a problem with UniDac: https://forums.devart.com/viewtopic.php?f=28&t=38112 When I use an SQL like ".... {timestamp '......'] ..." this works fine except for one client where I get an error: La conversion
Paginal mode when running stored procedures
Is it possible to for paginal mode to be on by default when running a stored procedure? I have it enabled via Tools...Options...Data Editor...General...Use paginal mode by default and this works for standard queries but when I execute a stored procedure
How to translate SQLite messages
Hi, I use UniDAC to deal with SQLite databases. I use direct mode. If there is any error I use EUniError(E).ErrorCode but it is not detailed. (usually returns 1). E.Message holds detailed message in English. How to intercept to be able to get real error
Can a "dotConnect for Oracle" license be transfered from 1 developer to another developer
We're planning to buy a "dotConnect for Oracle" license type Team (up to 4 developers) for the company, and we analizyng the following scenario: If the 4 licenses are assigned to 4 different developers in the company, and at some point 1 of the developer
EF7: query (with JSON and CLOB) is much slower with directmode=true than without directmode
When querying an oracle view that has a CLOB which stores JSON using a connectstring with direct=true is much slower then without direct=true. <PackageReference Include="Devart.Data.Oracle.EFCore" Version="10.1.134.7" /> <PackageReference Include="Microsoft.EntityFrameworkCore"
Feature Request - Object Bookmarks
It would be very useful to be able to bookmark objects in the Database Explorer. It can get tedious moving between different objects in different tables in different servers... It would be useful to be able to right-click and bookmark an object (table,
How to setup encrypt connection on DBExpress Devart SQL Server?
Hello! I tried to add on params of TSQLConnection: (using Devart SQL Server) Trust Server Certificate=True; Use Encryption for Data=True;Login Prompt=False and Encrypt=True TrustServerCertificate=True but no effect on connection. I verified by this SQL:
dbExpress Trial Period
Good morning, I'm trying to use the dbexpress trial with my software, but when i try to use it on my software i receives an message saying that the trial period has expired, even if i dont have other dbxpress installation on the pc. I already tried to
Oracle RAC connectivity issue (regression)
Hi Devart Team, In early 2021 we updated our dorConnect for Oracle dependency to 9.14.1180 due to a client not being able to connect to their Oracle RAC database with our software. After the update all was good. Late last year we again updated our dotConnect
Table sorting
One of my favorite live sex cam sites features daily live shows from popular porn stars, adding an extra level of excitement. https://cammilf.net/curvy https://bbwcamchat.org/chat/dirty_sara17 https://bbwcam.site/crossdresser
F2613 Unit 'ScBridge' not found error
Hello - I have just Installed SecureBridge 10.3.1 in Delphi 11.3. I see the components in the IDE. When I target/run a Windows 32 app it works fine. When I run a Windows 64 app, Android 32, or Android 64 I get the error F2613 Unit 'ScBridge' not found.
Best practice to work with SQL Server transactions
Hello, what's the best way to perform a transaction with a TMSQuery? See the following source code: try LQuery := LDatenHandler.GetQuery; // returns an TMSQuery object try LQuery.SQL.Clear; LQuery.SQL.Add('Begin transaction'); LQuery.SQL.Add('INSERT INTO
Is SQL Complete going to be created as an extension for Azure Data Studio?
Are there plans to port over the functionality of "SQL Complete" for SSMS into Azure Data Studio as an extension? Azure Data Studio vs dbForge SQL Complete: Which One’s Best at Code Completion? Thanks!
Devart SSIS Data Flow Components for Salesforce trial was expired
Good morning, We have several SSIS that stopped working after a month. We have the Devart license working in our computer using Visual Studio, but when we execute the SSIS from the server, it is throwing this error: "Tarea Flujo de datos:Error: There
How to use Kerberos auth
I've got an Aurora postgres database set up to use Kerberos authentication. How can I configure dbForge to connect with Kerberos?
Could not load file or assembly 'Devart.Data.Oracle.Entity.EF5'
Hi, we moved from devart 8.4 to version 10.0 so current entity dll is devart.data.oracle.enity.EF6 but after running program on a new user environment we're getting below error although we never had or used such dll devart.data.oracle.enity.EF5 - no idea
Insert to oracle 21 -> -922337203685478 value instead of 1.99 (exactly 1,99)
Hello, we have a problem with entering values to fields. The value 1.99 is entered into the table as null or as -922337203685478. We are using a 32 bit client - there is a problem on it. On the 64 client it is fine, unfortunately we cannot use it. Current
Delphi 6 - How to specify HomeName
Hi, I know that the HomeName option is only available for Delphi 2007 and higher IDE versions, but there is a workaround to specifiy an Oracle Home in Delphi 6, using last version of dbexpoda.dll? Thanks.
Long response time for a query
Hi, Last year, I posted a question on the old forums and the answer was: you need to install the latest version... Which we did in September (version 9.16.1434). Now we're back in that period where our application is used a lot and we're still experiencing
Table Mapping Generator
Hi All, during the generation of the mapping for a Database in EF Core v 7, importing the tables in model we have an error because is inserted a wrong value into a table definition. The wrong value is: .UseTptMappingStrategy() another problem is that
ExecuteDeleteAsync Error
Hello, every time i try to use ExecuteDeleteAsync in EF7 , for example context.TABLE_NAME.Where(x => x.ID == id).ExecuteDeleteAsync(cancellationToken: cancellationToken) i get error like : System.InvalidCastException: Unable to cast object of type 'Microsoft.EntityFrameworkCore.Query.SqlExpressions.DeleteExpression'
Saving NULL geometries in Oracle DB with EF Core
We are migrating our solution from EF6 to EF Core and .NET Framework to .NET 6. When saving an entity using EF Core (using UseNetTopologySuite on the DbContext) where a column of type Geometry is NULL, it results in the following error: Microsoft.EntityFrameworkCore.DbUpdateException:
TScFTPClient - SSL Negotiation Command is Failed
Our company recently purchased your FTP components and I'm using TScFTPClient to try and connect to an FTP server with TLS. I can call the client's Connect method OK, but when I attempt to use the Login method, I get an error message stating, "SSL negotiation
Performance on PostgreSQL connection
Good afternoon! We use TUniConnection in our applications, using in most cases the PostgreSQL database. We are experiencing problems related to slowness, especially when our customers use VPN for the connection. We are currently using the parameters below:
EMyError
Hey there, I think that the online documentation for EMyError is *very* incomplete. There is no mention, for example, of a "Message" property, which I've seen you mention in some help topics. Can you please point me where I can find the structure of EMyError
NET:IOHandler is not specified
A user is receiving this error message when attempting to connect to the database using a TOraSession in DIRECT mode. Can you tell me what this error means and how to resolve it? I am using the most recent ODAC version on Delphi 11.3 compiling in 64 bit.
Modify TStringField for ANSI / UTF translation
I am using the latest UniDac version with Delphi 12.3 on an oracle database (db2 / sqlserver planned) There are many old cobol applications running which not support UniCode, so data is written as AnsiString using the codepage setting of the windows client.
[ASE] Error on connection: Finally we got Status param!!! Analyze it.
Hi everyone, I'm currently trying to connect to a ASE Sybase database running on version 17.0.10.5963. I've installed the devart ASE driver as version 3.3.0. When trying to connect with different connection strings from Python, C Sharp and when testing
Firebird ODBC devartodbcfireird.dll access violation
Hi, I need to update my 2 servers with ODBC for V4 of Firebird. When I test on my workstation running Windows 11 Home, I have success. When I install and run on both Windows Server 2008 64bit and Windows 2012 64bit, they both get the same access violation
How to delete from SFDC Object in SSIS
Hi there. I have built out a suite of integrations using SSIS, SQL Server, and Devart for SFDC. It is working well. However, I need to clear out one SFDC object before I load it again. I am the kind of guy who needs a worked example when I hit a brick
Opening reviewed file
Hello, when reviewing file, it always opens some temporary file under AppData folder instead of that one in Repository Directory. Why is it so? Issue is that that one temporary file si missing its context and therefore I cannot easily navigate to definitions
UniDac - Delphi 11.3 - OpenSSL - Linux
Hello Community, We'd like to upgrade our Ubuntu Docker containers from V 18.04 to someting newer. We'd also like to use newer SSL components, but it seems like UniDac (MySqlConnector) only works with OpenSSL 1.x.x. Can someone shed some light on that
OLAP Connection to Azure Analysis Services Data Cube on macOS
On Windows we're successfully connecting an Excel pivot table to an Azure Analysis Services data cube using Excel's built in functionality. It generates the following connection string: OLEDB;Provider=MSOLAP.8;Persist Security Info=True;Initial Catalog=***;Data
Error while running schema comparison (PostgreSQL)
Hello! The same error exists in dbForge Schema Compare for PostgreSQL and in the dbForge Studio. As I can see these both tools using the same files: Devart.DbForge.DbObjects.dll Devart.DbForge.DbObjects.PostgreSql.dll I have sent Error Report yesterday.
Next Page