ODBC

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

Contents

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