DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to install driver from provided installation folder(s).
This is the more complex version of DB_Connect
Will execute SQL statement if caller provided sSQL, saves output into oRS object, saves 1 or 0 into DB_Connect settings, also saves count of returned rows into LastTableCount setting if caller set sSQLCount statement.
Used in most of Excel-VBA-based tools where database connection is needed, used to be named DB_Connect_AndOr_Fix

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net

Optional sSQL = "", Optional sSQLCount = ""

Views 1,571

Downloads 441

CodeID

DB ID

Database

ANmarAmdeen
702

Attachments

DB_Connect_Install.zip

Revisions

v1.0

Tuesday

March

24

2020

Tags

sql db database select driver connection connect msi msifile install installation x64 x86

Needs

See code ...{$CRLF$}'{$Tab$}mMain module with public variables{$CRLF$}'{$Tab$}SettingRead SettingSave IsThere oShellRun1{$CRLF$}'{$Tab$}Settings (see code) ...