Recent Topics
[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.
TRttiUtils : Documentation
Could you please provide the documentation for the TRttiUtils class and an example of use TIA
STRING_TO_ARRAY
i'm getting an "error" while trying to format a document SQL1.sql: Error (6,5): Unexpected symbol 'STRING_TO_ARRAY'
UniDac 64-Bit MySQL
When linking a 64-Bit C++ project with MySQL UniDac support we get the following error, Unable to open file 'myprovider280.lib' To correct the problem, we have to copy, Devart\UniDAC\Lib\Win64\myprovider280.a to Devart\UniDAC\Lib\Win64\myprovider280.lib
Cann't get autoinc primary key value after UniQuery.Post when SQL include ORDER BY
Select * from table order by col1, Simple SQL like this are fine. Select table1.*, table2.xxxxx from table1 left join table2 left join table3 ORDER BY xxxxxx. When it is such a complex SQL statement, the self-incrementing primary key value is Null after
Change sqlite version
How to update sqlite version? For now sqlite 3.40 is newest but it's 3.36 in devart 6.0.x package.
9.3.0 - Virtual Table Errors
Hi, I detected errors in VirtualTable object. Sample application and information as follows: Delphi: Delphi 11 Unidac: 9.3.0 (nightbuild version) OS: Windows 11 There are 2 problems. One of them is that when we load data into the VirtualTable object at
Features supported
1. Does the driver use the postgres binary or string protocol? 2. What is the level of support for Arrays and PostGIS datatypes? 3. I understand that the driver connects directly, does it support connection using SSL? Thanks
query using "for json"
Hello, I use SDAC 10.0.2 with delphi 7, When I try follow query that return one row & one field (actually is TMemoField) and get field value as string I get part of actual data (2033 bytes). Can anyone knows what is wrong? select * from customer for
Sample size while mapping
Hi I am trying to import a large dataset from a csv. When using the wizard, it is eventually setting the type and the max. lenght of each column, using a sample of 100 (?) lines. How can I tell the wizard to use a larger sample, like 10.000 lines?
SOLVED - UNIDAC 9.1.1 - PostgreSQL 12 - 15 Digit Problem
I started seeing a bug I reported earlier in version 9.1.1 again. Can you help with this? Information: Delphi 11 PostgreSQL 12...15 Unidac 9.1.1 Before Report: https://forums.devart.com/viewtopic.php?f=28&t=54306 ScreenShot: Thanks.
Tmytable not drop
Hello, how do I make it so that a TMyTable that is active cannot be deleted with DROP TABLE ?
Next Page