• Error while accessing foxpro tables from sql server as linked server

    Provider OLE DB "MSDASQL" for linked server "XXXX" returnes the message "[Devart][ODBC][xBase]Cannot open file "c:\temp\table.dbf". Unable to access file. The file is being used by another process". Message 7350, level 16, status 2, procedure test, row

  • Weird Issue, happening once in a while...

    hello, once a month or so, one user (out of 100) faces issues to login into one schema (out of 50 in the average) of one database (out of 100). Happens suddenly without any change to this user, schema or database. This 'lock' disappears after a few hours,

  • How to make a Order and Order Items report

    I have two tables: Orders: OrderID Name Address etc. Order Items: Item ID Item Name Qty etc. How do I make a report that shows the Order and then all the Items on the Order? In the Detail Band, I can only see one record, not all the records in the Order.

  • Read-only mode for Salesforce driver

    Hi I noticed this old post from around 4 years ago - Is there a plan to support the above? Thanks.

  • executeScalar() isn't recognized using sqliteCommand

    I'm trying the dotconnect for sqlite trial. I've defined a sqliteCommand &I'm trying sqliteCommand.executeSalar() but executeSalar() isn't coming up when I type .e after the command instance.

  • Full-text index support in dbForge Studio 2022 for SQL Server

    Are there any plans to add support for full-text indexes in dbForge Studio 2022 for SQL Server as found in SSMS?

  • ODBC SalesForce Error state: 'HY000'. Native Error Code: 0. [Devart][ODBC][Salesforce]Access violation at address 1875A1E3 in module module 'DevartODBCSalesforce.dll'. Write of address FEC50020

    Hello, the last month we opened a ticket as we had this kind of error. They told us to update to 3.1, but we still have the same problem. Randomly, our SSIS process will stop, showing us that error. Our only solution so far is to be always aware of the

  • DBF Provider Deleted Flag

    Hi, 1. How can this be set to show/hide deleted records? 2. How can deleted records be identified in a table? Thanks

  • Help adding QuickBook invoice using DotConnect

    I receive the following error: System.NullReferenceException HResult=0x80004003 Message=Object reference not set to an instance of an object. Source=BaptistTrumpetInvoicingV2 StackTrace: at EOL.BaptistTumpetInvoicing.GenerateSubscriptionInvoices.AddQBInvoice(Customer

  • Why is documentation so poor?

    Why is the documentation so bad? For example, on the page https://docs.devart.com/sbridge/, under Securebridge Alphabetical Object and Component List (at least I think that's what it is as the left hand side panel is too narrow to display long topic names)

  • How to pass a Parm to the Query

    I have a sales sheet. The Devart Qry brings in a table SMB_Budget. I want to filter that table on a salesman (smb_salesman). Is this possible, and if so, what is the approach I should use? The salesman number will be in a Cell in the excel spreadsheet

  • [Solved] Connect named SQL Server instance in Direct Mode

    Hello. I am currently testing the migration with SDAC from MS OLE DB to Direct Mode. When connecting to the SQL Server, I get problems when I try to access a named instance, such as "(local)\dunit". If I use only "(local)" then the connection can be established

  • How to get MySQL time fraction with Devart dotConnect Express MySQL?

    Assume that I have a table like this: CREATE TABLE `table1` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `date` date, `timestamp2` timestamp(2), `datetime3` datetime(3), `time6` time(6), PRIMARY KEY (`id`) ); Here's the sample inserts: insert into table1(`date`,`timestamp2`,datetime3,time6)

  • dbForge Studio for SQL Server on Manjaro

    Hi, Did anyone try running dbForge Studio for SQL Server on Manjaro or any other Linux distro using CrossOver? Thanks, Tom

  • Devart dotConnect for Oracle professional version

    Hi, we're using version 8.4.437 for our oracle 12 connections and it worked well. Recently we tested on oracle 19c and we're getting this error: ORA-64219 invalid LOB locator encounter Could be of version of dotConnect? thanks

  • Better support for DateTimeOffset

    Hello I would like to edit database fields in SQL Server of data type DateTimeOffset with SDAC. When I read these fields it works correctly, depending on the definition, no matter what timezone value is in the database. The local time is always read out

  • Unidac 9.3 - Lazarus

    I can't compile LiteDacprovider. has a error on rebuiild the lazarus. Iam using Lazarus Win-32 cross compiler Others providers are ok.

  • Securebridge SFTP error Undeclared identifier: 'TScSFTPFileAttributes'

    Steps to reproduce problem. (1) Create a new VLC project (10,4) (2) Drop a SFTP component (3) Double-click property Onin SetRemoteFileAttributes (4) Enter // for persistence (5) Compile Error: [dcc32 Error] Unit2.pas(14): E2003 Undeclared identifier:

  • Using the Devart.Data.PostgreSql.dll assembly in a PowerShell 7 script?

    I am trying to use a licensed Devart.Data.PostgreSql.dll in a PowerShell 7 script (there is no exe or dll file involved) It works with Windows PowerShell 5.1 without having to provide any addition license information but I cannot use the .NET Standard

  • Dbforge for MySQL Command Line interface

    Hi, Is there a way to save the command line output when running a batch file of the number of rows imported?

  • ODBC SalesForce Error error HY000 Access violation at address 177E7037

    Hello, We are using de ODBC Driver for SalesForce with Microsoft SSIS, and when we try to retrieve a couple of complete tables, we get randomly the following error: error HY000'. Native Error Code: 1. [Devart][ODBC][Salesforce]Access violation at address

  • Color correction in import

    I have two issues/question in Studio 2022 for SQL server. 1. Using "Visual Studio Blue" Skin, go to Data pump / Import external data / ODBC. In ODBC options, enter the necessary data, then go to "Destination". In there, when you select a table from Source

  • Error "wrong data format" when decrypting TStream in TScCMSProcessor

    Hi, Error "wrong data format" is always generated when decrypting a TStream in TScCMSProcessor. It works fine for files, but not for TStream. InStream := TMemoryStream.Create; InStream.LoadFromFile('Document.txt'); OutStream := TMemoryStream.Create; //

  • Generate Android 32-bit and 64 bit binaries -> Unit 'MyAccess' not found.

    Hello, If I set "Generate Android 32-bit and 64 bit binaries" to True in Project settings / Compiling, I get the error: "[DCC Fatal Error] Main.pas(18): F2613 Unit 'MyAccess' not found." This setting is required for Google Play upload. What can I do?

  • TNSNAMES not found on 21c

    1a) Install Oracle 21 XE into c:\oracle\product\21.0.0 on a machine without any other Oracle server or client installed. 1b) Install Oracle 18 XE into c:\oracle\product\18.0.0 on a machine without any other Oracle server or client installed. 2) Create

  • Robert Davis

    Is the issue with NexusDB provider fixed yet? I'm using the most current trial and it won't work. Says I need to recompile the NexusDBProvider. What is the problem? I'm running Delphi Professional 11.2 w/Update 2 (Alexandria). I'm not going to upgrade

  • Issue with Devart.SSIS.Salesforce.SalesforceLookup

    For the last couple of days we're receiving this errors when we tried to get data from salesforce. Could you please help us? Thanks a lot. Error Code: 0xC00490F7 Description: The managed pipeline component "Devart.SSIS.Salesforce.SalesforceLookup" could

  • ODBC Driver ZOHO SSL

    Today, im convert my Python Code for Connect into Zoho from (Windows Server 2012) to (Windows Server 2008) but there're error (On WS 2008) Error: ('HY000', '[HY000] [Devart][ODBC][Zoho CRM]The underlying connection was closed: Could not establish trust

  • TScHubConnection and ServerSentEvents Support

    Will TScHubConnection support transport type of ServerSentEvents in the future? I noticed that there is commented out code in ScSignalRHttpConnection referencing ServerSentEvents.

  • Raspberry

    Hi, I do not understand if it's possible use SQLite with Lazarus, but on ARM platform, like the RaspberryPi. In the source folders I see some Lazarus files and fpclinux64.o but not clear to me if compatible with ARM... Thank you

  • TscHTTPServer

    Hi: I'm using the TscHTTPServer to implement a Service Server for my programs. There is no documentation of using this component, but I realize this is close to the programming of a TIndyHTTPServer, but without some support procedures like the MIME List

  • Can I use Odac with Delphi Community Edition to Access Oracle 19c Enterprise Edition?

    is Delphi Enterprise edition is Must for Oracle 19c Enterprise Edition access? erkan

  • ODBC Driver for Salesforce

    My organization purchased the ODBC Driver for Salesforce and we are happily retrieving data from Salesforce BUT we don't seem to be able to write data back to Salesforce.  The log for both Salesforce and our application that is connected via Devart ODBC

  • Oracle error OCI-21500 and hard crash

    I'm raising this again here in the new forum as we are still receiving this error after upgrading to the latest oracle 19.16 client. have an application using the latest version of dotconnect which is crashing randomly and being terminated by the .net

  • Writing to Salesforce Objects - will it trigger Account history in salesforce

    Hello We are using ODBC driver to write to salesforce on Account object if needed.  We also have account history enabled in salesforce but noticing none of changes triggered by back end odbc process is recorded in salesforce account tracking -  is it

  • Devart Postres pgDataReader/PgDataAdapter Decimal value with Precision

    Could someone please help me with the following question... I migrated the Assembly Devart version to Postgres Express to version 8.0.0.0... after the changes the decimal value that is brought from the PgSqlDataAdapter is coming numerically with precision

  • VirtualTable/Query are empty after LOADED

    Hello I just bought the VirtualDAV (v12.2) Components for my Delphi 11.2 Attached a small demo program, that shows my problem. I load/assigned the data in the LOADED Methode, after i entering on the FormCreate Methode the vtElementGrafik VirtualTable

  • Avoid describing all source and target objects on data comparison

    Hello, we are planning a full DB migration, with lots of tables involved, that require us to define and execute different dbcomp files in order, as there's dependant data involved. dbForge does the job perfectly, however, we do see a major slowdown in

  • Error when opening EDML from VS2022

    Starting a few days ago, I am experiencing this error when opening the EDML within VS2022 that was working before:

  • Unable to connect SQL server database

    I write a code on databricks python notebook to connect My SQL server database through ODBC but it's showing error as in attached file.  Pls provide me solution ASAP.

  • Next Page

  • Most Discussed Topics

  • Invalid Typecast exception on Insert/Update blobs

    Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++

  • How do I show the Functions/Procedures within a Package

    I'll be respectful since I'm a user that has used Oracle Toad for probably 20+ years. The list below are features available within Toad and I don't see how to accomplish these tasks within dbForge Studio for Oracle. How do you display the Functions/Procedures

  • The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.

    I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created

  • Oracle - EFCore - Hints

    Hi, I am trying to use OracleFunctions.Hints("ALL_ROWS") in a project that is using Devart.Data.Oracle.Entity.EFCore. What is the recommended way to add Oracle optimizer hints in EFcore ?

  • Will dbForge for Postgresql filter out comments when submitting queries?

    Will dbForge for Postgresql filter out comments when submitting queries? If filtering is applied, it is recommended not to do so, as certain features of Alibaba Cloud Polardb may become completely ineffective. pg_hint_plan - PolarDB - Alibaba Cloud Documentation

  • Popular Topics

  • Invalid Typecast exception on Insert/Update blobs

    Hello peeps We're doing a migration from XE3sp2 to XE12.3 and I've stumble on an issue with saving blobs to an Oracle database. I've tried with and without direct mode but both resulted in a Invalid Typecast exception. Our previous implementation in c++

  • The problem of UniDac implementing SQLite database through multiple third-party encryption connections via TUNiconnect.

    I am building a Delphi application that can connect to SQLite databases, But because there are multiple DLL implementations for encrypting SQLite databases, At the same time, the encrypted SQLite database cannot know the type of encryption, So I created

  • Virus scanner alarm - Trojan found

    Hello, this morning I received an update message for the installed test version of SQLTools. After downloading the sqltoolsent.exe file from the download area at devart, I started the installation. Unfortunately, I received the following messages from

  • Advice on which Unidac components to use in android app

    I have a small personal android app which accesses a sqlite database with several tables. The app is single user, no db sharing. Only one table open at a time. Browse, add, edit, delete, search. I currently am trying out a TUniconnection, and a TUniQuery

  • Connecting to a PostgreSQL database using SSL when the server requires SNI

    Hello, We have a problem connecting to a certain cloud PostgreSQL database using SSL, because the server requires a server name indicator (SNI). We tried the both connection ways described in the "Connection to PostgreSQL through SSL in Delphi" manual

  • Popular Articles

  • How to Download and Install a Previous Version of the Product

    If you need to download and install an earlier version of a product, other than the latest release available on the website, follow these steps: Uninstall the Newer Version: To install a previous version available under your license, you must first ...

  • How to Connect to MySQL Server

    In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

  • How to Automatically Create a Dump File on Crash for Studios, Standalone Tools, and MiniTools

    If a crash occurs, you can configure the system to automatically create a dump file for debugging purposes. Follow the steps below to create the required registry keys for different products, such as dbForge Studio, Standalone Tools, and MiniTools. ...

  • Cannot Open Table ‘Case’ and ‘Order’ in SSMS with ODBC Driver for Salesforce

    When working with SQL Server Management Studio (SSMS) and the Devart ODBC Driver for Salesforce, you may encounter difficulties accessing certain tables such as Case or Order. Important Note on SSMS Behavior Queries in SSMS are first processed by SQL ...

  • How to Activate a Trial Version in dbForge Products

    Starting from release 2025.1, the method of using the trial version and Express Edition has been updated for all paid dbForge products. To help you get started smoothly, please follow the step-by-step instructions below. As of version 2025.1, ...