Recent Topics
How to send plain text ScSslClient
I want to start using ScSslClient to connect to my ICS component SslWSocketServer. Connection happens successfully. Issue is when I send some data it shows as junk (unicode characters) at the Server Side. Kindly let me know if I am sending text wrongly.
SDAC Support for 'Always Encrypted'
Hi Our Delphi application uses SDAC components (TMSConection, TMSQuery etc). I would like to know whether these support SQL Server 'Always Encrypted'? Thanks and regards Vinod A S
EntityDac save entity to mariadb - using FireDac
I use entitydac context. in Delphi12 and entityDac 3.3.0 var predpokladanaoperace := entitycontext1.CreateAttachedEntity<TTOrderWork> ; predpokladanaoperace.OrderId := 'zakazka000001'; predpokladanaoperace.TsLastchange := now(); predpokladanaoperace.TsCreated
unidac + oracle direct mode + non blocking mode
Hi, another question around non blocking mode. the actual working seetings - unidac + oracle db - direct mode - disconnected mode for me the non blocking mode doesn't work very smoothly as it blocks sometimes the entire main thread which the exact reason
monitoring evolution table
Hello, I have a schema table A which is populated , I want to compare it against another reference schema table B and recover all the data changes, is this possible with Dbforge compare? Thanks. Regards Damien.
Salesforce ODBC driver - select from ContentDocumentLink slow buggy
Hello! I am running this simple query in SSMS via a linked server against the ContentDocumentLink table. It its not only EXTREMEMLY slow, bit it does not respect the LIMIT clause and keeps slowly pulling more records into the output window maybe 30 seconds
MSAccess Direct Mode
Hi, With version 10.1.0 you add support of : MS Access data provider Added support for Direct mode How can I use it and is it working with old access database (.mdb) Regards,
Select and update
Hello I have a stored procedure that returns data and updates a table. How should I execute it to retrieve all the rows it returns and ensure that the changes are saved in the database? Thank you
where is trigger tab in table editor window ????
Hi where is trigger tab in table editor window ???? i see columns, constraints, Indexes, Options, Date but, triggers ???? Is it exists only in Database explorer tree ?
unidac, oracle, direct mode, disconnected mode, non blocking - cancel query
Hi, i am using unidac to connect to oracle in direct mode, disconnected mode, non blocking and i have sometimes SELECT queries which are last long. I want to cancel them. The query will be triggered from the main/ui thread. How to do this? Do you have
SQL Server Source Control - which Git client is needed?
SQL Server Source Control - which Git client is needed? instructions state Git client for windows must be installed. We use DevOps for our Visual Studio / C# code. I was unsure exactly which Git client to install, and was skittish about changing any existing
where is window splitting for procedures and package window ?????
where is window splitting for procedures and package editor window ????? is this possibility a big technical problem ?
VirtualQuery DataMaping Unidac 10.0
Hi, I use the code below : try //---- Création TableP_MESURES := TUniQuery.Create(Self); try //---- Création WQ := TVirtualQuery.Create(Self); //---- Source de données TableP_MESURES.Connection := FicheModuleDonnees.Connection; WQ.SourceDataSets.Add(P_VLC,
Error message since version update
We are using Delphi 10.2.3, wth WIndows 10 Since today, Securebridge 10.2.1 worked fine. But today, we updated to 10.3.1, and since then, the previous sftp connections are not working. I checked the application, which was compiled yesterday, with the
SecureBridge "Trial expired" right after install
Newly-downloaded SecureBridge is giving "Trial period has expired" message. I just downloaded SecureBridge for Delphi 12 and installed it. (2024-02-09) I loaded and compiled demo SFTPClient and ran it. In the SSH configuration area I filled in server
Can´t compile x64 Package dacsbridge280
Hello, i can´t compile the x64 Package for Securebridge 10.3.1 in Delphi 11. The Error are [dcc64 Fataler Fehler] CRSSHIOHandler.pas(10): F2084 Interner Fehler: URW7676 I reinstal the SBridge and try also the latest Version as Trial -> Same The Path are
How to add the activation key to SQL Server without Visual Studio
Hello. We have SSIS Dataflow Components for SalesForce installed on an SSIS SQL Server. However Visual Studio is not installed. How can we activate the product without Visual Studio? I found one other thread on this topic that advised copying a .lic file
MAX number of connections reached
hi. I have a C# .net WebForms app with several hundred users. it is running on windows server 2016. my connection string looks like this: value="direct=True;Min Pool Size=5;Max Pool Size=200;Validate Connection=true;Connection Timeout=5;Default Command
DDL Search works on comments on views but not stored procedures
As the title states, I can search comments left in views but not in stored procedures. For example we lable all sprocs and views with "author: [INSERT NAME HERE]", yet a search for author only returns the views and not stored procedures.
Data comparison - Req "treat null" option to be split
In Data Comparison tool, the "treat null and empty string as the same" option needs to be split into 3 options. Option 1, for strings: Treat null and "<string defined by the user - default = EMPTY STRING>" as the same value Option 2, for numbers: Treat
Unable to attach the Transact-SQL debugger.
I just started getting this error about 5 days ago, I have no idea why? I used to be able to debug my T-SQL using the "play" button, now I can't?? I was following this thread here until you moved forums a few days ago. What I don't understand is that
Package load exception after upgrading to Visual Studio 17.4.1
I just upgraded to VS 17.4.1 and now I am getting a 'devart code compare' did not load correctly.
ORA-01745: invalid host/bind variable name when using the same variable multiple times in EF7 query Where()
Hi, were are currenly using Devart.Data.Oracle.EFCore v10.1.134.7 in combination with EF7 on net6.0. Whenever we use a query that uses the same variable 2 times or more in a Where() method we get an ORA-01745 exception. Example: var today = DateTime.Today;
support rad 12
need support for rad 12
Salesforce ODBC - Update Record
Whats the best way to update a record in salesforce using the ODBC driver? I have this setup as a linked sever in SQL Server Management Studio, and would like to update a salesforce record from a local table.
dbForge Studio for PostgreSQL
does dbForge Studio for PostgreSQL Data Editor allow you to update bytea columns?
Connection lost
Hello all, I moved the databe from Windows to Linux. And after this move my application is getting lost connection error. Is there an option in MyConnection component to handle such a problem? After loosing the connection all queries are getting problems...
SecureBridge for Delphi 12
Hello, When is the plan to release Secure Bridge for Delphi 12? Regards, Bojan
dbexpsda doesn't works with fields with space
Hi, My dbexpsda.dll gives an error using table fields with space like [Num. Registro] in SQL Server . Anyone can help me?
Problems with Batch Updates
Even in the latest version of mydac I have problems with batch updates. (I told you already on the old forum) The problems started when you released a "faster" and "optimized" batch update ;) Now I can reproduce the error in my app. I have a main app
SSIS package task error with HardDelete
I've created a Devart SalesForce Destination task with the HardDelete action. When I attempt to execute, it throws an error of: "...failed with error code 0x80131500 while processing "input"... ." The regular Delete action works just fine. Are there special
IBDAC and multithreading
From FAQ "Are the IBDAC connection components thread-safe? Yes, IBDAC is thread-safe but there is a restriction. The same TIBCConnection object cannot be used in several threads. So if you have a multithreaded application, you should have a TIBCConnection
UniDAC 10 Data does not get written to PostgreSQL DB
I'm using PostgreSQL 15.1, Delphi 11.2 I have a simple application (64Bit, if that matters) that uses a connection, the PosgresProvider, TuniTable and a Datasource connected to a dbgrid and dbedit and the With 9.4.0 everything worked. With 10.0.0 I can
Replacing long server nams with an alias in tabs' captions
Some of my server names are very long. For example managed instances names end with 'database.windows.net' They make the tabs very wide and harder to read. Is there a way to instead of using $Server$ in the SSMS Caption setting to use an alias? So instead
quick question about Connection Lifetime
I have a asp.net webforms app with several hunderd users, and I would like to shorten the connection life time. currently it is set to 1800, which is 30 minutes. I am wondering if setting "Connection Lifetime=300" is too agresive. that is 5 minutes of
dispose datacontext
I am disposing dc like this: private void DisposeDB() { if (DB != null) { if (DB.Connection != null) { DB.Connection.Close(); DB.Connection.Dispose(); } DB.Dispose(); DB = null; } } I am 100% sure I am a always uysing the "using" C# keyword to instentiate
performance monitor
may I use windows performance monitor to watch dotconnect oracle connections? I am using direct mode to connect to database. I would like to add some counters for dotconnect conections. do I have to install dotconnect on the server in order to use the
Performance Counters Support
hi. I would like to use performance monitor tool to monitor IIS connections on the server. how may I create counters for dotConnect for oracle? do I need to install dotconnect on the server? thank you
Czech accent characters
Hi, I have an issue with dotConnect for Oracle and Czech accent characters. I do not understand why on one computer I need "Unicode=true" settings in the dotconnect connection string (without it the Czech accent characters do not work) but on another
BUG UniDAC v10 : @@rowcount is incorrect
Hi, - Delphi 11.3 - UniDAC v10.0.0 - MS SQL 2022 "select @@rowcount" is incorrect with update, insert and delete. no problem with UniDAC v9.3.0 Update of 44811 rows : Deleting a row that does not exist : Thank you in advance Regards
Next Page