I'm connecting to DBF files using Delphi 2009 ADO components and this connection string: Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mypath; If c:\mypath doesn't exist, and I run the application inside the debugger, my app hangs. No exception is raised. If I run the application without debugging, an exception is prope...
hi I am not a Delphi programmer, but I I got an old Delphi 7 application that I need to fix and it is using ADO. The database table (MS Accesss) contains +100,000 rows and when I set the ADOTable.Active=true it starts to load the entire table into RAM and that takes a lot of memory and time. How can I prevent ADO to load the entire ta...
I've been using cmd.Parameters.AddWithValue, and not specifying a DBType (int, varchar,...) to run queries. After looking at SQL Profiler, it seems that queries run with this method run a lot slower than when you specify the data type. To give you an idea of how much slower it is, here's an example. The query is a simple lookup on a...
Hi I have a Delphi 7 app using ADO/MSDASQL.1 provider and I wonder if it is possible to "log" the SQL queries sent to the DB in a easy way? Just like the SQL profiler in SQL Server? //Andy ...
Connection Code: set conx = Server.CreateObject("ADODB.connection") conx.Open Application("connectionString") set cmdx = server.CreateObject("ADODB.command") cmdx.ActiveConnection = conx cmdx.CommandText = "dbo.sproc" cmdx.CommandType = &H0004 set rsx = Server.CreateObject("ADODB.Recordset") rsx.open cmdx resarray = rsx.getrows Thi...
Hi all, I want to use the standard ADO connection string dialog box in MS Access. How can I do that? ...
Someone I know wants to use diconnected recordsets in an application. To me it sounds like if I have a ORM tool there would really be no need to even touch disconnected recordsets. The way I understand it with ORM the ORM takes care of not hugging connections for unnecessarily long amounts of time, solving the need for a disconnected rec...
I am starting to design a new application and what I am wondering is peoples opinions on Linq2SQL or Linq2Entities and what they feel is the better technology for rapid development. I am also doing some research into ADO.net data services. ...
Please note the Edit below for a lot more information, and a possible solution We recently modified a large Delphi application to use ADO connections and queries instead of BDE connections and queries. Since that change, performance has become terrible. I've profiled the application and the bottleneck seems to be at the actual call to...
I am trying to loop on a recordset returned from db2 using a .wsf file and vbscript . the vbscript libfile(lib.vbs) is as follows '*************** Const ADOCon="Provider=IBMDADB2.1;Password=*****;User ID=*****;Data Source=yourdatasourc;" '************************ 'ADO environment is Initialised here '************************* F...
HI, I am looking for some material giving introduction to DAO and ADO usage in VBA. Most of the material i came across give examples of how to use them. I am looking for a broader theory based definition of what they are and how they came about and the requirements for their usage. thanks regards tksy ...
I have a Delphi application that uses ADO to connect to a SQL server hosted on the Internet. The user running this application wants to access the SQL server through a proxy internally. How can this be done? ...
We have a bunch of VB6 apps at our company. We are trying to debug a random SQL timeout error and did a trace with SQL Server Profiler on the Audit Login event. We noticed that the connections were coming in as nonpooled. We use the SQLOLEDB provider with SQL Server 2000 & 2005. I searched the internet and everything I come across says t...
Assume the Stored Proc takes 10 minutes to run and returns no data. What is the proper way to call a stored procedure in SQL Server and have your code not wait around for the result? Is there a way to handle it from the T-SQL or the connection? Something that works in ADO.NET and classic ActiveX ADO? The only way I thought of is: 1) Cr...
On a form, I have a Quantum Grid and some db-aware editcomponents. When appending a new record in the grid, typing some editvalues both in the grid and the separate editcompoennts, I get an error: EOleException: Row cannot be located for updating. Some values may have been chenged since it was last read After some googling, I thin...
Is there any concept like RDS(Remote Data Services) in .net ??? ...
I am trying to retrieve an oracle field with datatype clob into a VB array without reformating the retrieval SQL string (simply SELECT * FROM my_table). I am using an ADO recordset. The clob values are lost when I close the connection or do any other action with the recordset. How can I achieve this. ...
In my application I do the follwing things: Open a Access database (.mdb) using Jet/ADO and VB6 Clear and re-fill a table with new data Close the database Start another process which does something with the new data. The problem is that sometimes the second process cannot find the new data. Sometimes the table is just empty, sometim...
I need to insert 800000 records into an MS Access table. I am using Delphi 2007 and the TAdoXxxx components. The table contains some integer fields, one float field and one text field with only one character. There is a primary key on one of the integer fields (which is not autoinc) and two indexes on another integer and the float field....
I'm making a fair amount of calls to database tables via ADO. In the spirit of keeping things DRY, I wrote the following functions to return an array of values from a recordset. Is this hare brained? I use it mainly for grabbing a set of combo-box values and the like, never for enormous values. Example Usage (error handling removed for...