Top "Ado" questions

Is there a way to retrieve the view definition from a SQL Server using plain ADO?

I'm successfully extracting column definitions from databases hosted on a SQL server using the ADO Connection OpenSchema() call in its …

sql-server view ado

Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect

I'm trying to connect various VBA projects to an Oracle 10g back end using ADO (2.8) and no TNS. After various …

excel vba oracle ms-access ado

Access-SQL: Inner Join with multiple tables

i have multiple tables in a database: tblOjt ID studentid courseid companyid addresseeid dateadded datestarted dateended ojthours 1 3 1 1 1 9/25/2013 500 tblStudent ID lastname …

sql ms-access vb6 ado

VBA, ADO.Connection and query parameters

I have excel VBA script: Set cоnn = CreateObject("ADODB.Connection") conn.Open "report" Set rs = conn.Execute("select * from …

vba ado

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

Getting "Multiple-step operation generated errors. Check each status value." error using ADO with SQL server 2008

We are in the process to migrate our SQL 2000 box to SQL 2008. But we ran into an issue; when a …

sql-server sql-server-2008 ado

Read and write to an access database using Javascript

first I want to mention that I am aware that in web interaction with databases should always be with server …

javascript database ms-access activex ado

How to properly add new records to empty recordset manually?

How to add new records to a new & empty ADODB.Recordset manually? Right now, here's what I'm doing that …

vb6 ado

How to check if an OLEDB driver is installed on the system?

How can I make sure that a certain OLEDB driver is installed when I start my application? I use ADO …

delphi oledb ado

Classic ASP - SQL Server 2008 Connection String using Windows Authentication

This should be painfully simple, but I cannot come up with a working connection string for a local copy of …

database sql-server-2008 asp-classic connection-string ado