Recent Topics
Suggestion: add "Encoding" parameter to TIBCScript.ExecuteFile()
Hi, my database is all UTF8. If I load a script in UTF8 format(*) using TIBCScript.ExecuteFile(), all german "umlauts" are scrambled. Funny enough, if I set "UseUnicode" option of TIBCConnection to FALSE, then it loads correct. But then all other inserts
Find and replace dialog - look in All open documents
Hi, Find and replace dialog often suppose look in All open documents As for me it's very special case and most user will prefer Current Document by default.
current_schema ?
Hi, how to set current_schema ? Yes, i can make it using ALTER SESSION SET CURRENT_SCHEMA = but 1. It's not convenient 2. In database explorer tree view staying old schema I think this feature should be integrated in interface.
EntityDac save entity to mariadb
I use entitydac context. in Delphi12 and entityDac 3.3.0 var predpokladanaoperace := entitycontext1.CreateAttachedEntity<TTOrderWork> ; predpokladanaoperace.OrderId := 'zakazka000001'; predpokladanaoperace.TsLastchange := now(); predpokladanaoperace.TsCreated
Entity Developer - generated metadata error - Delphi and MariaDB
Hello, in table are BIT type fileds. After generate code are errors in datamodel.metadata.pas file now in source code: FKontrolamnozstvi := TMappedAttribute.Create(Self, 'Kontrolamnozstvi', etBoolean, False, 'KontrolaMnozstvi', False, False, 'b'0'', 'BIT
header of tab sometimes not in visible position !!!
Hi, sometimes the tab header is not in visible position after opening new tab and need to scroll tabs for finding it.
Insert into Sybase: The token datastream length was not correct. This is an internal protocol error.
I'm trying to insert data into a Sybase table, with Python, (with one column) through a procedure and I'm getting this error message. "The token datastream length was not correct. This is an internal protocol error." Below is the code I'm using: my_cursor
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?
Cannot find Datamodel.hbml file error NHibernate
I am following the instructions for database first creation. However, at the end, the template fails to find the hbml file in the appdata folders. This only happens with NHibernate templates.
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
Next Page