Top "Adodb" questions

Accessing SQL Database in Excel-VBA

I am copying an VBA code snippet from MSDN that shows me how to grab results from a SQL query …

sql vba excel adodb

How do I run a VBScript in 32-bit mode on a 64-bit machine?

I have a text file that ends with .vbs that I have written the following in: Set Conn = CreateObject("ADODB.…

vbscript 64-bit 32-bit adodb provider

How to populate a ComboBox with a Recordset using VBA

There is some literature available at expert's exchange and at teck republic about using the combobox.recordset property to populate …

ms-access vba combobox adodb recordset

Excel VBA - connect to sql with a trusted connection (no uid/pwd)

Is there a way to have Excel connect to Sql Server using the current user's network windows authentication (trusted connection/…

sql excel vba connection-string adodb

VBScript & Access MDB - 800A0E7A - "Provider cannot be found. It may not be properly installed"

I've having a problem with a VBScript connecting to an access MDB Database. My platform is Vista64, but the majority …

ms-access vbscript oledb adodb

ADODB query timeout

I am trying to open a query, which is timing out. I have tried setting the timeout property, but it …

vba ms-access adodb

VB6 ADODB.Recordset RecordCount property always returns -1

I am trying to get some old VB6 code to work with SQL Server Compact. I can connect, open the …

sql-server database vb6 ado adodb

Using SQLDataReader instead of recordset

I am new to this and had this question. Can I use SQLDataReader instead of a Recordset. I want to …

vb.net adodb sqldatareader

VBA New Database Connection

How to change the code below to prevent what you see in the screenshot. I am running a macro with …

sql excel adodb vba

Finding The DSN To My Database?

I have an SQL database and want to connect to it using VBA in order to support some legacy functionality. …

sql vba adodb