Differences between revisions 3 and 5 (spanning 2 versions)
⇤ ← Revision 3 as of 2020-03-12 16:04:15 →
Size: 833
Editor: DominicRicottone
Comment:
← Revision 5 as of 2021-11-20 22:16:02 → ⇥
Size: 987
Editor: DominicRicottone
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
## page was renamed from ODBCSetup
Line 3: Line 4:
You poor, poor fool. '''Open Database Connectivity''' ('''ODBC''') is a database API almost exclusively employed by Microsoft.
Line 11: Line 12:
== Create Connection == == Connecting ==

There are a few ways to create an ODBC connection.
Line 35: Line 40:
== Connecting Applications to ODBC == == Usage ==
Line 47: Line 54:

ODBC

Open Database Connectivity (ODBC) is a database API almost exclusively employed by Microsoft.

Contents

  1. ODBC
    1. Connecting
      1. ODBCConf.exe
      2. Add-OdbcDsn
    2. Usage
      1. SPSS

Connecting

There are a few ways to create an ODBC connection.

ODBCConf.exe

A (deprecated and pending removal) Windows Data Access Components batch script. 

odbcconf.exe /a { configdsn "Microsoft Access Driver (*.mdb, *.accdb)" "DSN=DATABASE_NAME|DBQ=ABSOLUTE\PATH\TO\DATABASE.accdb" }

Add-OdbcDsn

A Powershell cmdlet. 

Add-OdbcDsn -Name "DATABASE_NAME" -DriverName "Microsoft Access Driver (*.mdb, *.accdb)" -DsnType "User" -SetPropertyValue 'DBQ=ABSOLUTE\PATH\TO\DATABASE.accdb'

Usage

SPSS

get data
 /type=odbc
 /connect='DSN=DATABASE_NAME;DBQ=ABSOLUTE\PATH\TO\DATABASE.accdb;'
 /sql='SELECT * FROM TABLE_NAME'
 /assumedstrwidth=255.

CategoryRicottone

ODBC (last edited 2021-11-20 22:16:07 by DominicRicottone)