dbForge doesn't recognize null. It has to be "null"
I am having several issues when importing from a json file when using dbForge version 6.4.7 - I have the setting to ignore errors yet dbForge imported nothing. - I attached the log file. The file mentions Row: 201. If it read 200 rows successfully, why
I'd like to ask you to cancel my subscription
Hello. The automatic renewal was checked at the time of purchase last year, so the product that was not scheduled to be used this year was automatically paid. I'd like to cancel my subscription, can I know how?
Slow connection using Dbeaver and ODBC <> BigCommerce Connection
We're looking for a solution to connect to BC using ODBC for my team. We managed to get the connection working but its unbelievably SLOW. Like 2-3 minutes for a select statement. We have enterprise BC so we shouldn't have any rate limiting issues, is
Unidac 9.3.0, Delphi XE2 ver 16.04, Oracle EE with TDE, ORA-00600
Hello, I am using UniDac version 9.3.0 with Delphi XE2 Version 16.0.4504.48759 on an oracle database 19c Enterprise Edition with TDE configured. I have a table with two columns crypted. Here the script I've used: ALTER TABLE utenti MODIFY (USERNAME ENCRYPT
Multiple Query
Hi I have a following problem: trying to utilize multiple query feature but getting error about incorrect sql syntax (ORA-00933). I want to pass few sql queries into one command, then execute reader, fetch data from first query, then call NextResult and
Cancel Subscription
I'd like to cancel my annual subscription for MySQL Database COmponents. Where can I do this?
How to make Code Compare Ignore closing/opening braces openings or endings?
facing issue as Cannot describe stored procedure arguments
Hi Team, we are facing the same issue which is mentioned in below link, this is created around 2 years ago. Do not find any solution/fix provided. please help in understand the resiolution required. For reference we are adding the Procedure for reference.
Unable to create entity model
Hi, Using Visual Studio; When I try to add a new Devart Entity Model; I can create a model using the thick client app and open it in Visual Studio but the entities are not generated and I do not see Run Custom Tool.
Как правильно работать 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:
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.
Next Page