Stack Overflow
Stack Overflow

Questions tagged [adoconnection]

The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database. If you want to access a database multiple times, you should establish a connection using the Connection object.

43 questions
10
votes
2 answers

Is Delphi's TADOConnection thread-safe?

I'm writing a Delphi 7 application which needs to access the same SQL Server database from many different threads simultaneously. Can I use a single shared TADOConnection, or must each thread create their own?
Blorgbeard
  • 101,031
  • 48
  • 228
  • 272
6
votes
2 answers

Ok to use TADOConnection in threads

I have created an TCPip server application. The application has one global TADOConnection. This global ado connection is used both for main thread queries and also within threaded processes. Is this ok? Does the ADOConnection have built in…
M Schenkel
  • 6,294
  • 12
  • 62
  • 107
6
votes
1 answer

Microsoft AlwaysOn failover solution and Delphi

I'm trying to make a Delphi application to work with AlwaysOn solution. I found on Google that I have to use MultiSubnetFailover=True in the connection string. Application is compiled in Delphi XE3 and uses TADOConnection. If I use Provider=SQLOLEDB…
Tiberius Cocarlea
  • 63
  • 4
5
votes
2 answers

Delphi 7 - ADOConnection unable to connect due to SQL "must change password" flag

I am having a problem that occurred in a specific circumstances in my Delphi 7 application. I have ADOConnection that goes to my MS SQL server with some username and pass - SQL authentication. The problem is that MS SQL login was created with "User…
Surrogate
  • 331
  • 3
  • 11
5
votes
1 answer

Connect to excel 2007 file using ADOConnection in Delphi7

I want to connect to an excel 2007 file(.xlsx) using delphi 7, so I used a AdoConnection and set its connectionstring property as: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test\qm\Results-summary.xlsx;Extended Properties="Excel…
Masoud
  • 8,020
  • 12
  • 62
  • 123
4
votes
3 answers

hide connection user password in memory in delphi TadoConnection

I have made a sample application in Delphi xe10 and make user id and password and database name encrypted and decrypt on connecting the problem is when I open exe process in memory by memory scanner I can find all of them easily by searching some…
dawood karimy
  • 179
  • 2
  • 13
4
votes
0 answers

ADOConnection cant get table names on SQL LocalDB

I have a SQL Database MDF file , I want to connect to that file with ADOConnection and SQL Client 11.0 as provider ADOConnection connects successfully but there is no Table ! ADOConnection.GetTableNames() returns "" My code is like this : …
Mahmoud_Mehri
  • 1,643
  • 2
  • 20
  • 38
3
votes
0 answers

Secure Handling of Connection String for Delphi's TADOConnection object

The Environment I have a 30-year-old Windows desktop application written in Delphi 10.4 (upgraded numerous times throughout its life). It has a TDataModule with approximately 100 TADOQuery, TADODataSetProvider, TClientDataSet, TDataSource, and…
Bond
  • 79
  • 4
3
votes
1 answer

thread in service application under delphi xe does not work

'MyThread' does not run. I do not know whether the problem happens on 'DataTransferServiceStart' procedure. I guess the 'DataTransferServiceStart' procedure does not execute. IDE is Delphi XE. Please help me, thank you very much. Thread's Unit: unit…
Rei Yau
  • 43
  • 1
  • 5
2
votes
1 answer

Working around ADO Error 3711: "Operation cannot be performed while executing asynchronously"

I am using the TADOConnection object in Delphi XE but this appears to be an ADO issue, not a Delphi issue: Scenario: I am trying to close and free a TADOConnection object connected to Sybase. The connection is waiting for a response from a remote…
Vector
  • 10,879
  • 12
  • 61
  • 101
2
votes
4 answers

delphi adoconnection econvert error

I have the following code wich is raising an EConvertError - "can not assign TAdoConnection to TAdoConnection" var wTmpADOConn : TADOConnection; begin // Result := nil; try Result := TADOConnection.Create(nil); wTmpADOConn :=…
RBA
  • 12,337
  • 16
  • 79
  • 126
2
votes
2 answers

Insert Unicode chars to MySQL with Delphi 2010

Trying to insert values with Unicode Chars into a MySQL-database using Delphi 2010 and TADOConnection with no luck. Connection with ODBC Provider=MSDASQL.1;Persist Security Info=False;Data Source=mysrc;Initial Catalog=mydb The SQL command: INSERT…
Bulan
  • 673
  • 1
  • 9
  • 24
2
votes
1 answer

Delphi ADOConnection connection timeout property does not work

I have a function to control server connection. If ado cannot connect in 5 seconds, it should give an error. But connectiontimeout property cannot work. Here is the code I am using : function AdoConnectionTester(strServerName, strUserName,…
Sayat Ertüfenk
  • 324
  • 1
  • 3
  • 11
2
votes
2 answers

Adoconnection asks for userid and password when opened Delphi

I am trying to open an ADOConnection component. The database is in MDB format. I use JET to access it. Whenever I use AdoConnection.Open in my code the window pops up and asks for userid and pass. I enter "Admin" for userid and leave password empty,…
Tofig Hasanov
  • 3,303
  • 10
  • 51
  • 81
1
vote
1 answer

Sharing database connection with threads, instead of creating new ones

I wanted to check into this before I attempt it. I am working on a couple threads which require fetching data from the database within the threads. Currently, based on all I've seen, I am creating a new database connection (TADOConnection) from…
Jerry Dodge
  • 26,858
  • 31
  • 155
  • 327
1
2 3