ado

In Classic ASP, are there major performance consequences of having several connections open and close?

I have a code snippet similar to the one below that I would like to refactor into two different functions each with their own connection (for better maintenance): Dim Conn, Sql, RS Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open ConnString Sql = SELECT * FROM CLIENTS Set RS = Conn.Execute(sql) //'Do something with Cl...

ADO showing "hidden columns" with SQL Native Client

I'm working on a legacy application using VB6 and Classic ASP. We're using disconnected ADO recordsets to pass data back and forth. Normally this works. But what has started happening recently is for any inner/outer join, ADO is including these in the available records to choose from. So when were specifying a column to update (in th...

How to relay dataset/datatable from Tomcat to a .NET application ?

I need to provide data to a DataTable in a .NET application from a servlet hosted in Tomcat. It seems tempting to just stream back XML the .NET application can just pupulate using DataTable.ReadXML. Is that the proper road to go down ? And not the least; are there existing Java components that can help me with this on the Tomcat side ? ...

LDAP server access via VBscript/ADO

Can ADO access attributes other that ADsPath and Name when bound to an LDAP server? Below is the code I use to bind to and query a LDAP server on the internet: Set ado = CreateObject("ADODB.Connection") ado.Provider = "ADSDSOObject" ado.Properties("User ID") = "" ado.Properties("Pass...

Update operation in ADO Entity framework

Hi How to do the Update table operation in ADO entity framwork Thanks Sekar ...

Why does one ADO.NET Excel query work and another does not?

I'm working on a SharePoint workflow, and the first step requires me to open an Excel workbook and read two things: a range of categories (from a range named, conveniently enough, Categories) and a category index (in the named range CategoryIndex). Categories is a list of roughly 100 cells, and CategoryIndex is a single cell. I'm using ...

Delphi - Save DateTime Null to DB (ADO / MySQL)

Hi, i have a delphi form with some DB Controls on it. To represent a date I use the TJvDBDatePickerEdit (from JCL), which has a nice property ShowCheckBox := True; to allow the user to enter that no date is known (DBNull). I verify, that nulling the DatePicker works as expected by: procedure Tframe.adoQueryBeforePost(DataSet: TDat...

Why extremely occasionally will one of bof/eof be true for a new non-empty recordset

set recordsetname = databasename.openrecordset(SQLString) if recordsetname.bof <> true and recordsetname.eof <> true then 'do something end if 2 questions : the above test can evaluate to false incorrectly but only extremely rarely (I've had one lurking in my code and it failed today, I believe for the first time in 5 ye...

Intermittent ADO Recordset object error in Classic ASP script

I'm very infrequently seeing the following error logged on a website I manage: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another When I access the classic ASP page myself, I cannot duplicate the problem. Notably, the user agent is nearly always: ia_archiver (+http://www.alexa....

ADOQuery, trigger and requery bug

I have an ADOQuery that inserts a record to SQL Server 2005 table that has trigger inserting data to another table. I use following code to refresh the query and avoid Row cannot be located for updating (There are PKs on each table, UpdateCriteria property are set, Cursors are set to Dynamic, yet I still get the error sometimes. However ...

ADO Batch Update in Access VBA

I am trying to use batch updates in Access VBA. My code works fine when I update after every operation, but fails when I try to operate on multiple rows. The exception I get is "Run-time error '-2147217887 (80040e21)': Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." ...

How to export the results of a stored procedure directly to a MS Excel file?

I found a way to extract the contents of a MS Sql table directly (faster) to excel. But I do not know how to do this with a stored procedure that requires parameters. Is it possible to extract, directly, to an Excel File the results of a stored procedure? I know how to do it indirectly (using a data table) but it is too slow. Thank you v...

Forms bound to updateable ADO recordsets are not updateable when the source includes a JOIN

I'm developing an application in Access 2007. It uses an .accdb front end connecting to an SQL Server 2005 backend. I use forms that are bound to ADO recordsets at runtime. For the sake of efficiency, the recordsets usually contain only one record, and are queried out on the server: Public Sub SetUpFormRecordset(cn As ADODB.Connection...

Installing ADO on Vista

Hi, I need to develop a classic asp application on vista, and would like to know how to go about installing ADO on Vista Enterprise operating system. Thanks ...

Classic ASP adodb connection error on Vista

Hi, When my classic asp page gets to this line of code Dim cnn As ADODB.Connection it throws an error http 500. I suppose ado is not correctly installed Any ideas? ...

MSDAIPP broken on Vista by Update, missing in Win7Beta

I have some code I am working on that worked just fine until I installed Software Update for Web Folders (KB907306) into Vista SP1. I'm using ADO with the MSDAIPP.DSO provider for acess to WebDAV and FPSE/WEC servers. The same code works fine in a clean XP SP3 install, and worked before this update (but I will re-verify on a clean Vist...

Why do I get an ADO connection error while using classic ASP?

Hi guys, I am getting an error when running this classic asp script: Dim DB_CONNECTIONSTRING, rs, iRecordCount, strSQL DB_CONNECTIONSTRING = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=employee;Trusted_Connection=yes;" strSQL = "SELECT * FROM EmployeeProfiles" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open strSQL,...

Opening ADO connection to Excel Spreadsheet in VBA

How would I go about opening an ADO connection to an Excel 2007 spreadsheet? I am doing this in order to import the data into Access 2007. Rather annoyingly, the data needs to be fltered and pre-processed before being imported, hence why I want to open an ADO connection to read it. ...

Null values reading data from Excel using ADO

I am reading data from an Excel 2007 spreadsheet using ADO. Setting up the connection is easy: Dim ado As ADODB.Connection Set ado = CreateObject("ADODB.Connection") ado.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=myFilename.xlsx;Extended Properties=""Excel 12.0 Xml;HDR=NO;IMEX=1"";" ado.Open I can call ado.OpenS...

Updateing NText causing long delay/timeouts

I'm trying to update an NText field in SQL 2000 using Classic ASP. Here is the code I'm using to do it. Any one have any pointers on how to maybe speed it up? Or am I stuck with it. set Cnn = server.CreateObject("ADODB.connection") Cnn.ConnectionString = Application("Cnn_ConnectionString") Cnn.open set rs = server.CreateObject("ADODB....