SProcs using ODBC for QurickBooks
I'm trying to execute a sproc via a trigger to create a record in QuickBooks.... I'm getting "OLE DB provider "MSDASQL" for linked server "BT_QB" returned message "[Devart][ODBC]Optional feature not implemented". Doesn't the ODBC drivers for QuickBooks
In Version 6.0.3 is impossible to run transaction RO
Dears according to information provided by you I am starting read-only transactions by this command KPTrans = KPSessionName->BeginTransaction(5); It works perfectly till version 6.0.2, but the last version 6.0.3 doesnt work, and stay in RW transaction.
connectionstring, connnection properties and localdb
Hello, have con.ConnectString:='Provider=SQLNCLI11.1;Integrated Security=SSPI;Initial Catalog=somedatabase;Data Source=(localdb)\mssqllocaldb'; this works correctly. When i want to set this values as properties of object con (TMSConnection), i did not
Delphi 11.2, AnyDac 9.3.0, ReportBuilder 22.0
Hi. Trying to compiler rbUniDAC.dpk using Delphi 11.2 / AnyDac 9.3.0 / ReportBuilder 22.0 got the error message below: [dcc32 Fatal Error] daUniDAC.pas(21): E2411 Unit ppPDFDigitalSignatureDlg in package rbRCL2228 refers to unit Vcl.CustomizeDlg which
DBGrid Postgres
Hi, I've a problem to show some string in DBGrid Column number 3 si not show I have (MEMO) instead. My query : RequeteRapportAEnvoyer.Sql.Text := 'SELECT A.IN_TYPE,A.S_ID,A.IN_ID,A.IN_DATE,CAST(TRIM(CONCAT(CONCAT(B.T_PRENOM,'' ''),B.T_NOM)) AS VARCHAR(100))
firebird 4
from what version can i connect firebird 4 i have the version 4.2.3 wil wok
Firebird 4
from what version can i connect to firebird 4
User defined functions in Entity Framework Core 7.0
Hello. I'm porting my code from "classic" Entity Framework 6.4 to Entity Framework Core 7.0. What is replacement for the following code (User defined functions setup)? Most classes doesn't exist in both Devart.Data.SQLite and Microsoft.EntityFrameworkCore
Assert error in UNIDAC
Hi Connecting to postgres through UNIDAC. Query is taken from DB monitor. Insert to same table with same fields works fine. query : update eeli_1.t1009_packages("t1009_id","fd","td","t1002_id","t0106_id","package_name","start_sn","stop_sn","bar_code","user_id","in_date","comments","unit_name","s_id","pd_id","del_user_id","del_in_date","min_unit_name","code","min_unit_count")
.Net 7 support
Do dotConnect for Oracle support .Net 7? If not when will you will support it? Thanks.
Devart.Data.MySql & .NET 7 support
Hello, .NET 7 is out and we would like to upgrade our projects. Unfortunately the Devart.Data.MySql.EFCore package seems to not be compatible with it. Do you plan to have a compatible version any time soon ? Regards
SLOW START DELPHI APPLICATION
Hello, My Delphi Embarcadero application uses TUniQuery, to access 2 Interbase Tables, and TUniTable to access 2 DBF Tables. The application is getting slower and slower and slower when starts, more than 2 minutes. Every day is slower than the day before.
PostgreSQL 15.x support
Does anybody use the current version with the latest PostgreSQL 15.x versions? I'm still using 13.x and I have to migrate a server. So I just want to be sure, if there may be any issues UniDAC - PostgreSQL 15.x? When will there be a release with offical
Firebird ODBC driver can't open table using with BDE on Delphi11.2
When open database I tested Firebird ODBC driver using with BDE on Delphi11.2. I get error when openning TTable, "Dynamic SQL Error. Column unkown ID at line 1, column 8." I create database on Firebird 3.0.10, then create OBDC DataSoure using ODBC administrator
BigQuery ODBC driver | Data truncation
Hello, My company has recently purchased and installed the ODBC Driver for Google BigQuery. We are pushing data from BigQuery into a SQL Server database. It is working well for small datasets, however when we try to query for large datasets (e.g. 2 million
The new forum is awful and totally unreadable.
Hello, The new forum is totally unreadable. - posts are mixed between components, - number of post about UniDac since the new forum started seems to no showing all posts (only few posts) , - the topics are not organized i table (ie no columns for viewers,
Deployment issue, System.TypeLoadException
We recently updated our web application from dotConnect for MySQL 8.17 to 9.0.0 (with EF5). Everything works fine on dev machines but not when deployed to the web server (Windows Server 2012): System.Data.EntityCommandCompilationException: An error occurred
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
Next Page