Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2020-03-12 15:53:43 →
Size: 438
Editor: DominicRicottone
Comment:
← Revision 2 as of 2020-03-12 16:00:21 → ⇥
Size: 797
Editor: DominicRicottone
Comment:
Deletions are marked like this. Additions are marked like this.
Line 5: Line 5:
<<TableOfContents>>

----
Line 7: Line 10:
== ODBCConf.exe ==
== Create Connection ==

=== ODBCConf.exe ===

A (potentially deprecated) System32 batch script.
Line 15: Line 23:
== Connecting to ODBC == === 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'
}}}

----



== Connecting Applications to ODBC ==

ODBC

You poor, poor fool.

Contents

  1. ODBC
    1. Create Connection
      1. ODBCConf.exe
      2. Add-OdbcDsn
    2. Connecting Applications to ODBC
      1. SPSS

Create Connection

ODBCConf.exe

A (potentially deprecated) System32 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'

Connecting Applications to ODBC

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)