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...
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...
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 ? ...
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...
Hi How to do the Update table operation in ADO entity framwork Thanks Sekar ...
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 ...
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...
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...
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....
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 ...
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." ...
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...
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...
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 ...
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? ...
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...
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,...
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. ...
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...
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....