Query - ParamByName
Hello. RAD 11.3 / Unidac 9.4.0 / Windows 10 Pro version 22H2 I have problem with ParamByName in Query component. Field in Table is defined as CHAR(1) SQL: Select * from <table> where <field> LIKE '%A%' If the code is Q.SQL.Add('SELECT * from <table> where
Error Log Recorded
We are getting a lot of security alerts from our SQL Server that triggers from dbForge Studio 2019 Express for SQL Server. It spams our SQL logs for failed log in attempts (currently from one user that uses this application) very frequently through the
Connecting Postgresql with certificate
Hello We need to connect to the Postgresql database with a digital certificate, how do we do it?
UniDac ilink32 warning
Hello. RAD 10.4.2 / Unidac 9.4.0 / Windows 10 Pro version 22H2 I am getting the warning below: [ilink32 Warning] Warning: Duplicate string: ID 102; File C:\PROGRAM FILES (X86)\DEVART\UNIDAC FOR RAD STUDIO 10.4\LIB\WIN32\DBACCESS.RES string kept: "Password";
Parameter.AsString for an integer field results in a "record not found" error
Hi, With Delphi 5 + V6.11.23 of SDAC components + request : select * from TABLE where KEYFIELD = :Key + ParamByName('Key').AsString := '123' with Key integer field evrything works fine with SQL Server 2016 with SQL Server 2008 (or 2012, not sure), error
Urgent: Does DBForge Source Control Support Azure SQL MFA Authentication & Object Locking in Shared Mode ?
Does DBForge Source Control Support Azure SQL MFA Authentication & Object Locking in Shared Mode ?
Closing UniDac VERY slow
I have been using UniDac for years, currently in Delphi XE10.3.2 with Firebird 3 and for one particular UniDac query I have come up with a (to me) strange problem. It is taking about 8 seconds to close. The query is fairly simple (basically just a SELECT
type mismatch for field ‘xxx’ expecting string actual widestring
Hi all, I'm using SDAC 10.3 on Delphi 11.3: I got the above mentioned type mismatch, as I had created my SQL tables with NVarChar, and had persistent fields in my MSTables on the form. I found a description for the problem and a solution on this forum,
How and where do I set UseUnicode in sdac 10.3
Hi All, I have asked this question in a previous topic, but with another angle and more complex description. The simple question is: How and where do I set UseUnicode to False. I'm using SDAC 10.3 in Delphi 11.3 Regards Soren
Automatic choice of provider
Hello, We're wondering about the algorithm that chooses the provider to use to connect to a SQL Server instance when the Provider property is set to prAuto. According to the documentation (and the UniDac's source code), the Native Client is prefered over
NTDLL.DLL error when calling mstable.open, from an inherited form
Hi All, Using SDAC 10.3 and Delphi 11.3: I have a form, with 2 MsTable, which it has inherited from a standard form. On the standard, the Connection is pointing to a DB module with the MSConnection, but no tablename. In the inherited form, I set the tablename
Error during Installation of TCRSSLIOHandler for macOs
Hi, Delphi 11.2 / Windows 11 64bit I installed MyDac 11.3.0 and SecureBridge 10.3.1 with success for macOS and Win32 platforms. I'm trying to install the TCRSSH[L]IOHandler from ...\Documents\Devart\MyDAC for RAD Studio 11\Demos\TechnologySpecific\SecureBridge.
UniDAC object was open
I am migrating a project from Delphi XE with UniDAC 4.5.10 to Delphi Alexandria with UniDAC 9.2.1 and I am getting a few errors on Query.Open. These are the errors and I don’t have them in the old project. 1. illegal constraint expression 2. object was
How to Renew my dotconnect Oracle
How do I renew my licenses key of oracle dotconnect because I am facing the following error. Error : LicenseException: Feature is not supported. This error is thrown by Devart .NET Standard assemblies if license key validation fails. Possible reasons:
Missing Methods in Toolbox
Hello, I'm having an error when trying to access the ZohoConnection with the dotConnect, it hits me with a missing method error and im a little lost on where to go from there.
Export DataSet To JSON
Tell me, is it possible to export the dataset to JSON format? If not, is there a plan to do so?
ODBC for DBASE
hi, i dont see an option to imply a decryption key, dbf databases are encrypted, is here a function to be able to access them ? Thanks a lot.
Unable to uninstall. Error that SSMS is open, but it is not.
Hi, I'm unable to uninstall. I have restarted the PC, so nothing was running.
Heterogeneous queries
Hello, Does it exists a way to do Heterogeneous queries, off course on Firebird Dabases + TMemDataSet (= really powerful), like it is possible to do it with Firedac ? https://docwiki.embarcadero.com/RADStudio/Rio/en/Local_SQL_(FireDAC)
Lots of issues updating to version 6.1.134 of dotConnect SQLite Free in the Visual Studio 2022 community.
When upgrading to version 6.1.134 of dotConnect SQLite Free the Visual Studio 2022 community app stops working. Is it possible to roll back dotConnect version 6.0 for Microsoft Visual Studio 2022?
Error when writing to database
Driver does not support this function State:IM001, Native:0.Origin: [Microsoft][ODBC Driver Manager] even though we purchased and applied the license, when we attempt to use it to write to our database it connects perfectly but we keep getting this error
Virtual table transfer to another
Hello, When I use the code below to transfer a table to another table, all fields with non-English names appear as question marks. What should I do to keep the field names as they are? Var MM : TMemoryStream; T1,T2 : TVirtualTable; Begin MM := TMemoryStream.Create;
TScHttpWebRequest.GetResponse When an exception occurs, the object is freed , Result.Free adjust to FreeAndNil(Result) is it better ???
function {$IFNDEF SBRIDGE}TCRHttpWebRequest{$ELSE}TScHttpWebRequest{$ENDIF}.GetResponse(CancellationToken: TScCancellationToken = nil): {$IFNDEF SBRIDGE}TCRHttpWebResponse{$ELSE}TScHttpWebResponse{$ENDIF}; function StatusIsTimeout(StatusCode: integer):
DotConnect for Oracle express edition version 9.14 cause serious memory leak!
I have this code to open Oracle connection: private OracleConnection _OpenDBConn() { bool successed = false; OracleConnection conn = new OracleConnection(ConnectString) { AutoCommit = false }; try { conn.Open(); successed = true; return conn; } finally
connection with ssh problem
I'm trying to access with ssh private key, but I get the following error Connections using insecure transport are prohibited while --require_secure_transport=ON. The connection is fine with mysql workbench.
Integer[] value cannot be inserted into a PostgreSql database with LinqConnect
Hello, We have a column with datatype integer[] in one of our database tables. Using repository pattern, when we run this code: OurTableEntity entity = new OurTableEntity(); entity.OurColumn = "{-1,-1,-1,-1,-1}"; ourTableRepository.Add(entity); unitOfWork.Save();
Subscribtion
Hi, Just got message I paid for subscription for IBDAC and SDAC. Can you explain what's going on, I mean I didn't order that and what kind paymanet way it happened. It doesn't mean I don't want to prolong subscrubtion, but it was beyond my knowledge.
ODBC PostgreSQL: Data Source Error "Object not found"
Hi Community We use the DevArt ODBC PostgreSQL Connection on a daily base in order to connect Microsoft Excel directly to our Postgre-DB. All has been working fine until a few days ago. If I try to use an existing connection or create a new one, regardless
MsSQL New transaction is not allowed because there are other threads running in the session
Dears, we are trying to move large project from Delphi 11.2 ADO to Delphi 11.3 UniDAC. We use Firebird and MsSQL. We use main DbConnection and separate DbConnections for specific actions. We open forms with main DbConnection and we often use SpecificOptions.Values[FETCH_ALL]
SQL Complete - Copy and Paste from Execution History preview window in SSMS
Is it possible to copy and paste highlighted text from the Execution History preview window? I see that it's possible to copy the entire script to the clipboard from the top pane in the Execution History tab, but I find myself frequently wanting to copy
DevArt SSIS Components for Salesforce - Support of Later Salesforce API Versions
Hi, It looks like the latest supported version of the Salesforce API is version 52. Is there a way to get the DevArt SSIS Components for Salesforce to connect using a more recent/higher API version number, as I need my SSIS package to have access to some
ORA-01745: invalid host/bind variable name when parameters are reused in the linq query version 10.0.1.134.7 & EF7
Using 10.0.1.134.7 & EF7 When in .net the same variable is used more than once in a linq query, the bind variable in the query is rendered the second with 2 time ':' thus ::p__query_varname eg. excerpt: qry = qry.Where(z => z.DidoDocDosVersies.Where(y
dotConnect for Oracle and Entity Framework guide
Hello, I would like you to guide me about dotConnect for Oracle and Entity Framework configurations for the project I described with the following keywords. This help can be a sample project already exists, a post explaining the configuration, or a help
DB schema comparison script fails but Studio reports it has finished normally
I had made some alterations in the structure of a database, so i executed a schema comparison with another similar DB. I generated the differences script and executed it from within Studio. It said it had "finished successfully", but when i re-compared
Right Align Keywords?
I've created custom formatting for MySQL that makes reading the code a lot easier, but I'm not seeing any options to right align keywords? I see this is a feature in SQL Server Tools, but I don't believe it is an option in MySQL settings. Is there any
How to get the MySQL table structure
I am developing a MySQL database table structure synchronization function. The client will request the structure of the specified table on the server and receive it through the Json string. Then the client will compare whether the local table structure
Demo SFTPClient - Error "cannot send data to server"
Use demo SFTPClient When I upload a 25gb file after uploading 2gb an error occurs "cannot send data to server". The same error occurs when using the method ScSFTPClient.WriteFile --------------------------------- Embarcadero® RAD Studio 10.3 Version 26.0.36039.7899
TScWebSocketClient Negotiate/NTLM authentication
Hi I'm trialing SecureBridge library. I have a websocket server (based on c# HttpListener with AuthenticationScheme = AuthenticationSchemes.Negotiate | AuthenticationSchemes.Ntlm I have a websocket client written on Delphi using WinHTTP with such option:
ScSFTPClient - How to get the file size without having to download it?
Currently, I'm using ScSFTPClient.DownloadFile to download a file from a server to a local file. I'm then checking the file size post-download. Is there a way to get the file size of the targeted file without having to download it?
How to setup dedicated server in ODAC direct mode
Hello, we have implemented the use of 'direct mode' in our applications with ODAC, which is very useful to us. However, we would like to know what the equivalent of 'Dedicated Server' TNS connection type would be in ODAC direct mode
Next Page