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.
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.
Exception when generating diff report for PostgreSQL from command line
Evaluating schema compare tool using PostgreSQL 14.7 local databases. Can successfully generate HTML report from User interface, but same process is failing when generating via command line. We want to plug this into our build server pipeline, so command
Importing CSV with french boolean
Hi, I'm testing dbForge studio for PosgreSQL. I'm trying to impot CSV file with french boolean value in a column ('VRAI', 'FAUX')... but it fails How can I handle that ? (PS : I cannot change the source CSV file)
What is Query API for and what does SQL_ATTR_MAX_ROWS allowing you to do? I have ZOHO CRM
What is Query API for and what does SQL_ATTR_MAX_ROWS allowing you to do? I have ZOHO CRM
Oracle - Query Type class '____' cannot have primary key.
In the Oracle Entity Developer, I'm getting this error on some tables: Query Type class '____' cannot have primary key. The table does have a primary key in Oracle, but it is a varchar column. How can this table be used?
Mac DevArt -> Postgres connectivity issues
I've attempted to connect using the Devart Mac to Postgres driver. I've followed the instructions in the documentation. Upon hitting the test connection button I'm met with the error invalid activation key: I just downloaded the trial version on Friday
SOQL Query Syntax Issues
Trying to get all fields from our ACCOUNT table limiting it by 200 and getting an error in SSMS. Syntax: SELECT * FROM OPENQUERY(XXXX,'SOQL:SELECT FIELDS(ALL) FROM Account LIMIT 200') (where XXXX is the Linked Server) OLE DB provider "MSDASQL" for linked
MSSQL Managment Studio can link to Zoho CRM, I can see all the tables but I cannot access the fields
On the 2 ends Zoho and MSSQL I am the administrator with full privileges. -- [ZOHOCRM].[default]..[Users] contains no columns that can be selected or the current user does not have permissions on that object. GO Please see attached document.
Zoho CRM ODBC error when trying to update Subform
I am trying to update the values in a subform. The subform data is in a string field of the primary form's table, formatted as a JSON array of objects -- each object being a row of the subform table. When trying to modify the field via an Update query,
Unknown Database error when running initial migration
Connection string is: "Server=127.0.0.1;Database=MyDatabase;Uid=username;Pwd=secret;" Entity Framework Core 7 My SQL version 8.0.32 Initial migration is scaffolded using `add-migration`. However `update-database` fails with error: "Unknown Database MyDatabase"
Attaching dbForge to a new version of SQL Server
My company pushed SQL Management Studio 19.0.1 to my computer but left SQL Management Studio 18.5 also installed. I cannot install or uninstall any software on my own. I've tried re-installing dbForge SQL Complete, but it remains connected to the 18.5
Database Explorer does not show all objects, even if 'Show All Objects' option is enabled for the connection.
Hi Team! I faced an issue with Database Explorer View when it does not show all objects, even if 'Show All Objects' option is enabled for the connection. The problem seems relates to the fact that query: SELECT * FROM ALL_OBJECTS WHERE OWNER = 'MY_SCHEME'
SSIS package created with Devart cannot be opened in VS2017 after Devart Addon is installed.
SSIS package created with Devart cannot be opened in VS2017 after Devart Addon is installed.
SOQL Queries with Salesforce ODBC Driver
Hi, I have connected the ODBC driver as a linked server in MS SQL Server and can read/write Salesforce data. Is there a way to issue a SOQL query directly to Salesforce from SQL Server using the ODBC driver or does one have to rely on the ODBC driver
cant open View Table
My view table has quite a lot of lines and sub queries. Once i created it, i cannot open it via SQL, Editor or Generate script as CREATE. It just keep loading and eventually not responding. Kindly advise. below is sample query of how the view table looks
Oracle trial license key
Hi, After having installed and used DevArt Oracle driver for EF I tried to renew my trial license key without success. I uninistalled software (clean program files and program data folders) and installed again using dcoracle.exe downloaded from your site.
"Profile server events" tool require VIEW SERVER STATE permission
"Profile server events" tool require VIEW SERVER STATE permission. But at the same time the original ms "SQL server Profiler" perfect work under the same account without VIEW SERVER STATE permission
'Invalid parameter specified' on prepared query with a double
In our project we get an Exception: 'Invalid parameters specified'. We've determined that this is specifically when we use a double variable. In the scenarios below the first two instances of TPgQuery are executing properly, however on opening the third
Next Page