I'm using VBA adodb to write INSERT statements in a SQL Server based on Excel row contents. I'm using parameterized queries, so my VBA code has the following form: sqlStatement = "INSERT INTO ...

I am trying to get some old VB6 code to work with SQL Server Compact. I can connect, open the database and all seems well. I can run insert select commands which work. However the ADODB.Records...

I would like to run SQL queries on tables all contained within a single Excel workbook. My VBA code uses ADODB to run these SQL queries. Opening connection fails when the workbook is saved in OneD...

I need to open an Access DB on OneDrive using Excel-VBA and ADODB connection or SQL. Until a month ago the object ThisWorkBook.Path give me the local path of the file store on OneDrive, nevertheles...

According to the Microsoft documentation for the DATETIME column type, values of that type can store "accuracy rounded to increments of .000, .003, or .007 seconds." According to their documentatio...

Dim rs as ADODB.Recordset set rs = ReturnARecordset 'assume ReturnARecordset does just that... 'do something with rs rs.Close set rs = Nothing Is it necessary to call rs.Close before setting it...

Is there any way to set the CursorType for an ADODB.RecordSet which I obtain from ADODB.Command.Execute? I know that it is possible if I do: rs = Server.CreateObject("ADODB.RecordSet") rs.Open(cm...

I am working on an Excel application that queries a SQL database. The queries can take a long time to run (20-40 min). If I've miss-coded something it can take a long time to error or reach a break...

I've having a problem with a VBScript connecting to an access MDB Database. My platform is Vista64, but the majority of resources out there are for ASP/IIS7. Quite simply, I can't get it to connec...

I need to join two tables on column, which in one table is defined as string and in other as integer. In both columns actual data stored is integers. This is given to me by design - I can't change ...

I'm having a problem using VBA to execute a SQL query and copy the results into an Excel worksheet. When the sub excecutes, it only copies rows that are multiples of 256 (so rows 256, 512, 768 etc...

I'm trying to read an ADOBD.Recordset object like this (my first time, so pardon my "noobness" :D): Presentation.Category categorySvc = new Presentation.Category(); ADODB.Recordset categories = ca...

I have a program that is supposed to read data from an SQL database and report back to Excel. It works as expected on a 32-bit machine, but since I moved over to a 64-bit work environment, the prog...

Visual Studio 2012 VB.Net .NET 4.0 Build Machine x64 Build Config AnyCPU msado27.tlb This project is not new and has been built 100s of times over the past 2 years. With in the past 3 weeks some...

I am trying to open a query, which is timing out. I have tried setting the timeout property, but it doesn't seem to want to accept it. The query takes 34 seconds to execute using MS-SQL Server Man...

I have been tasked to migrate servers. This includes moving over apps I did not build, a couple of which have an ADODB.connection that I cannot seem to fix on the new servers (I only get blank scre...

I'm getting an ADODB Recordset and I need to check the value of a nullable column in ASP Classic. How can I tell whether it's null? AFAIK IsDBNull doesn't exist in ASP Classic, and all the Null tes...

Below is the excel table i want to manipulate via SQL query in VBA. Please find my VBA code. Sub SQL() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset strFile = ThisWorkbook.FullName strC...

I'm programming Classic ASP against a MySql Database connecting with ADODB and MySQL ODBC 5.3 ANSI Driver, but I have some problems when setting the date in the where of a simple MySql query, when ...

I want to get both a return code and a result set back from a stored procedure in classic ASP. CREATE PROCEDURE CheckEmployeeId @EmployeeName nvarchar(255) AS BEGIN SET NOCOUNT ON; DECLARE @Exi...

I am copying an VBA code snippet from MSDN that shows me how to grab results from a SQL query into excel sheet (Excel 2007): Sub GetDataFromADO() 'Declare variables' Set objMyConn = New ADODB.C...

In .NET I simply use Application Name = MyApp inside the connection string, but when using ADO connection through VBA the Activity Monitor of the SQL Server Management Studio always shows Microsoft...

I have a data module with a global TADOConnection (with the default KeepConnection set the true). There are numerous datasets and queries in my existing application that use this global TADOConnec...

What is the difference between adodb and oledb? What is the relation between these two? Where does ado.net stands in context of adodb and oledb?

we switched our DB connection from ADODB to SQLSRV and I seem to have issues with it causing intermitent delays using sqlsrv_fetch_array. I do a query in my database that returns around 426 rows w...