DATABASE_CONNECTIONS

Java, PHP, Python, R, SAS, and VBA Scripts to connect to file level (SQLite, MS Access) and server level (MySQL, SQL Server) databases using various modules and ODBC drivers.

REQUIREMENTS:

1. Java (8+) - jdbc sqlite, mysql, ucanaccess, and sqlserver drivers;

2. PHP (5+) - sqlite, mysql, and sqlsrv PDO extensions;

3. Python (3+) - sqlite3, pymysql and pypyodbc modules;

4. R (3+) - RSqlite, RODBC, and RMySQL libraries;

5. SAS (9.2+)

6. VBA (MS Office 2010+)

7. All above - ODBC/OLEDB drivers and user-created DSNs;

GETTING STARTED

Download needed generalized script(s) and amend to project needs, making sure to enter proper database credentials (hostname, database, username, password).