Top "Adodb" questions

Using "SELECT SCOPE_IDENTITY()" in ADODB Recordset

Using a VBA script in Excel, I'm trying to insert a new row into a table and then get back …

excel sql-server-2008 adodb recordset vba

Are multiple JOINs unavailable when using ADODB to query an Excel file in a VBA procedure?

I have 3 sheets with data formatted as tables. The sheets names are "Riesgos", "Eventos" and "EventosRiesgos". EventosRiesgo has information relating …

sql excel adodb vba

ADODB.Parameters error '800a0e7c' Parameter object is improperly defined. Inconsistent or incomplete information was provided

I'm primarily an PHP developer, but I have some old ASP one of our previous developers made that broke and …

vbscript asp-classic dllimport adodb

Create Entity-Relationship Diagram from MySQL Database

I am trying to create an Entity-Relationship Diagram by reverse engineering a MySQL database using a .SQL file. The process …

mysql reverse-engineering entity-relationship adodb entity-relationship-model

VB6 application ado connection for TLS1.2

I have to support a VB6 application that is still in production (ugh). A customer is specifying our software needs …

vb6 ado adodb tls1.2

How do you create an ADODB disconnected recordset in a VB.NET Windows application?

I'm using an OLEDB connection to a Sybase database, with ADODB.dll file version 7.10.6070.0 (which comes from the Sybase 12.5 package). …

vb.net sybase adodb

"Unspecified error" while opening an ADODB connection

I am facing "Unspecified error" in only one PC of my users. Run-time error '-2147467259 (80004005)': Unspecified error I am …

excel vba ms-access adodb oledbconnection

Inserting NULL values in a database from VBA code

I have 3 radioButtons ("YES", "NO", "UNKNOWN") wich matches a column from my database with 3 possible values (1, 0, NULL). When the radioButton …

vba adodb