dotConnect for postgresql 8.0 not compatible with NetTopologySuite?
I used dotConnect version 7.17 with NetTopologySuite 1.14 + GeoAPI 1.7.4. I update dotConnect to version 8.0. Now I can't run my application: When I compile I have the warning warning MSB3277: détection de conflits non résolus entre différentes versions
Inconsistent metadata - Connecting to Firebird from SQL Server Management Studio using ODBC Driver for Firebird
We have a Firebird 3.0.8 database we want to add as a linked server to SQL Server Management Studio. We downloaded the 'ODBC Driver for Firebird 3.3' and created a ODBC Data-Source: The database used in this test is a clean firebird 3.0.8 database with
Is it possible to convert back from EDML to EDMX?
Is it possible to convert back from EDML to EDMX? If so, what are the steps? I'm in a situation where I have to change one of our applications back to just using ODP .NET Data Provider and Entity Framework 6 default in Visual Studio.
Setup Linked Server in MSSQL Server with ODBC MySQL driver
Hi, currently I'm trying to setup a linked server connection in Microsoft SQL Server 2019 to access a MySQL Database via the ODBC driver. I've followed Connecting SQL Server Management Studio to MySQL via ODBC (devart.com) & Windows DSN Configuration
How to ensure TScSSHClient and TMyConnection both open and / or close at the same time
I like the way opening a TMyQuery automatically opens the TMyConnection that it is connected to. Does TScSSHClient do the same thing? ie if I have TMyConnection. IOhandler -> TScFileStorage.Client -> TScSSHClient will calling TMyConnection.Connect automatically
How does the securebridge demo know which key is the one downloaded from the server?
I have eventually managed to get the securebridge demo (Documents\Devart\MyDAC for RAD Studio\Demos\TechnologySpecific\SecureBridge\Demo) working after deleting references to IdeVer.inc. I am now trying to understand how it does the things the sample
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,
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.
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
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
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.
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
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
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
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
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
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
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
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 ?
ODBC Connection SQLSERVER to HUBSPOT
Next Page