Database 56 To deal with database and maintain it

Card image cap
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

Card image cap
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

Card image cap
LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

Card image cap
ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

Card image cap
DBMySQLVBA API

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

dbmysqlvbapi.zip

Card image cap
DB Class

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

Card image cap
Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

Card image cap
Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

Card image cap
Arabic SQL+ASP

Enable Arabic in MSSQL DB, the correct way, as of Sep 2018 Tested in Alwah and ...

Card image cap
RandomRecords

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

Card image cap
MSSQL DB Connection

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

Card image cap
MySQL DB connection

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