Search results 18

Sorted from new to old.

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

2018Dec25

Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

2018Sep1

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29

MySQL DB connection

Connects to MySQL database from Classic ASP All DB variables need to be ...

2018Jul29

DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

2018May31

1 2