ado

ADO Database Table Boolean Column

Hello everyone. I am having a bit of trouble with ADO. I have deployed a database application, which uses Access. With the release of different versions database tables have different fields, some added others deleted etc. What I can't get to work is how to add a BOOLEAN field in the database. For upgrade purposes I use the standart sq...

Row cannot be found for Locate?

Hi, I'm converting existing Advantage Database Server application to SQL Server 2005 using D2009, dbGo (ADO). Sometimes i experience the error row cannot be found for locating. I had googled it, according to results i needed to set Update Criteria property of each ADOTable and set cursor location to dynamic. I did so, but sometimes i sti...

How do you compare dataset structure in ado .net?

I need to compare the table structure of two datasets to check for any discrepencies, is this possible? I had though of converting to XML and comparing but is there a better way? Thanks ...

ADO Error: Automation error - The specified module could not be found

My VB6 application which runs successfully on many machines is producing the above error on just 1 users machine. Machine has Vista SP1 which means the MDAC installer will not work since MDAC 2.8 is already included. Code that leads up to the error: 'Temp file to users temp directory: FileName = C:\DOCUME~1\nmiller\LOCALS~1\Temp\TmpPr...

Accessing XML stream from ADO against SQL Server 2008.

We are migrating ASP code that used ADO to connect to SQL Server 2000. For the most part the code migrated without a hitch to SQL Server 2008 after defining the connection, but one type of query is throwing an error that puzzles me. Against SQL 2000, we would use code like this: set oCommand = Server.CreateObject("ADODB.Command") oComm...

SQL queries taking too long

I'm using ADO to save data to an MS Access database. It was taking quite a while to save the data to file (about 7 seconds - which is too long for our purposes). I looked at the number of SQL queries being run, and it's about 4200; although there isn't a whole heap of data. The database connection seems to be the bottleneck. Do you know...

How to emulate Edit/Update mechanism of ADO for SQLite in C++?

I have a C++ application that uses ADO to talk to an Oracle database. I'm updating the application to support an offline documents. I've decided to implement SQLite for the local side. I've implemented a wrapper around the ADO classes that will call the appropriate code. However, ADO's way of adding/editing/deleting rows is a bit diffic...

First was RDO, later ADO and more later ADO.NET, now LINQ. ¿Is LINQ the next standard or I should wait?

In my humble opinion, Microsoft is changing rules about database managing each four or five years. I remember old days when RDO was the solution to connect to SQL server. I refresh my knowledge to use ADO because RDO was obsolete. ADO was very good and effective, but not so long ago, I found myself programming and refreshing again my kno...

How to retrieve a value from a recordset that is not a return value or output parameter using vb6

I have a stored proc on an existing 3rd party application (SQL 2005) that I wish to interact with. It is an insert statement followed by a select statement as follows; Set @CustomerId = Cast(SCOPE_IDENTITY() As [int]) Select @CustomerId Using VB6 how do I access the value of @CustomerID? set rs = cmd.Execute is not ret...

Is it possible to create a deadlock with read-only access?

I have a VB6 application accessing a single table on a MSSQL2000 server via ADO. I'm using read-only access (adOpenStatic, adLockReadOnly) There are other applications in the network which do make changes to the table. For some reason I'm getting errors about my application being chosen as a deadlock victim. I'm really confused: Why c...

SQL through classic ADO - Undefined Function 'Round' ?

I'm working on a legacy product and i have some SQL being executed through ADO, to an Access database with linked tables to SQL Server. I'm getting the error 'Undefined function 'Round' when i execute the SQL but if i take the query and run directly in Access it works fine. I know that EVERYTHING is correct and that this is a machine s...

ADO SQLServer dbGo generates a EAccessViolation

Hi, I have a program that is filling a DB in a single thread. I Use one connection for all queries. Thats so i will be able to run them all in transactions. Every second I get a new set of files that has to be entered into a SQL Server 2005 Express. The Application can run for 24 to 36 hours and than suddenly get a "EAccessViolation" ...

Efficient way of uploading xls records to DB

Hi, What would be the most efficient way to upload records from an excel file to a table in the database. I am not allowed to use DTS/ SSIS. So I would like to know if there is a better alternative than reading records sequentially from the file and firing commands. Thanks. ...

Stored procedure time out - but fine when run from SSMS

I have a stored procedure which is erroring with "Timeout expired". The code involved is ADO/VB6. The stored procedure itself is not a problem, you can run it in a query window and it takes less than a second. The code used to get the connection etc is also modularised and in use all over a huge application. It is only in this one pla...

DAO vs ADO in HTA over wireless

I've written a small (8-10 laptops) point-of-sale system running over a wireless network, as an HTA that reads from/writes to an Access MDB located on a network share. I need to use ADO - GetString and the user roster are not available with DAO. I also need to use DAO - the MDB cannot be compacted with ADO. I know that: 1) If the databa...

retrieve the value of a timestamp field with adodb - how to read a byte array from classic asp

I'm working with asp and adodb, querying a database (ms sql 2005) I have a field named stamp, of type timestamp in asp I get the following field.ActualSize: 8 field.DefinedSize: field.Name: Stamp field.Type: adBinary (128) field.Attributes: 528 (adFldFixed (16) + adFldRowVersion (512) ) (so adFldLong is NOT turned on, so I can't u...

Multiple Oracle Clients

If I have multiple Oracle clients installed on a given workstation (i.e. Oracle 9 and Oracle 10), how do I specify which one is used by ADO? Is there a way to swap between the two clients? I am currently using the Oracle Provide - oraoledb, not the Microsoft provider. ...

How to SQL insert a raw/Binary field value from bytes/integer array using VBScript (orVB6)?

Does anyone know how to pass a several bytes into a Binary (or varbinary) field using SQL and ideally in ADO (classic) & VBScript (or Visual Basic 6)? I wish to encode 10-20 (maybe more) bytes of data and have this data stored in a SQL db field. (Its not MS-SQLSVR, but I'm hoping that a standard SQL supported format will work!) The byt...

Detect time of last change on a Microsoft Access database table

Does anyone know of a way to detect when the last time a Microsoft Access table has been changed (inserted into or updated)? We used OLEDB via ADO COM to communicate with an access database programmatically and were looking for a way of detecting changes to specific tables. We don't need to know what those changes are, just that change...

MS Word Ole Automation, ADO and foreign characters

I'm trying to export WideString texts from the database (ADO / MS Access) to the MS Word document (Delphi 7), but foreign characters are not correctly transferred (i.e. "è" instead of "č"): while not ADOQuery1.Eof do begin WordApplication1.Selection.TypeText(ADOQuery1Text.AsVariant); // TWideStringField WordApplication1.Selection.Ty...