Recent Topics
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
Relation Many-To-Many from Diagram Devart version 7
Hi all, I am working with the latest version of devart 7, with .net core 6 MVC, Visual Studio 2022 and with Sql server 2019. I need to relate two Many-to-Many tables and in the middle table I need to add more fields besides the two Ids of the related
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
On Save of a view the editor / formatter adds backticks (grave accents) around names - How do I stop this?
Hi guys, When saving a view, the auto formatted adds backticks (`) around object names eg. `ea`.`ParentEntityId` AS `ParentEntityId` I want to turn this off (unless necessary, like a name with a space) so the line reads like; ea.ParentEntityId AS ParentEntityId
SQL Query Hangs when adding anything beyond Select *
Using the Excel Add-in to pull and refresh BigCommerce sales data for orders with status = 'shipped' when selecting columns for a preview, the query executes fine. However, when adding any filters/order by logic, the query is stuck on 'executing query'.
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
MySQL 8.0+ : Compare and Generate Schema without Integer Display Width
As noted Old DevArtForum topic "Integer width deprecated" > In mySQL 8, there is a Warning, when creating a field with integer incl. precision. > "Warning: #1681 Integer display width is deprecated and will be removed in a future release." Can DevArt
Output the Search (Find a database object) to a file, table, excel, clipboard
After doing a "Search" (Find Database Object) thru my database, I'm unable to copy the results. Is this just not possible? Or, do I need to request a feature/enhancement?
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.
How i can know if specific File Exists on server?
Hello again, How i can know if specific File Exists on server with ScSFTPClient? I need to check if a specific file exists or not on the server. How can I do it?
Question/Problem dbForge keeps asking for an old connection when opening .sql file
In the past I have used another connection to work with dbForge. The connection has changed, I removed the old one from the database explorer and even when I'm using the new one, when opening a .sql file it keeps asking for the old one and I have to manually
SSH Connection with Public key not working
Hello, I am using dbForge Studio 2022 for MySQL Enterprise Edition 9.1.21 and trying to connect to a MariaDB server on a remote Arch Linux server via SSH. On that server, SSH is configured to accept public key authentication. When using the standard Windows
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
sFTP with Progressbar
Hello, I need a example of "ScSFTPClient1.DownloadFile" and "ScSFTPClient1.UploadFile" with a Progressbar do view the progress of file transfer. I Appreciate your attention.
Error in demo for SFTP
Hello, I'm trying to understand how the SFTP component is working, but í get some errors when running the demo. Please advice.
dbForge Enterprise via MySQL
Hi, I am on the process of migration using the copy database. Picture for reference. I am stuck with those red line that have percentage and not showing errors to troubleshoot. Btw, I am using a free trial and plan to buy license but i am testing it
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
create new database,user
Hello, i download dBforge studio for postgres and try to create database, table or user but there is no option for that as Mysql tool. so i missed something or it is limitation in this product? if it is limitation, are you going to develop it so that
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:
Next Page