File DSN advanced

Creating a File DSN manually

You can create a file DSN which references an existing regular DSN (now called User DSN's) with notepad. Just create a file containing

[ODBC]
DSN=name of your DSN

where name of DSN is the exact name you gave the DSN in the ODBC administrator. Save the file in \windows\ODBC\Data Sources and give it an extension of .DSN.

You can also edit an existing file DSN using notepad to customize it. A typical file DSN looks something like

[ODBC]
DRIVER=KISAM 32 bit driver
SERVER=hal9000
DBNAME=LiveSystem

You can add any of the other keywords legal in connection strings. e.g.

[ODBC]
DRIVER=KISAM 32 bit driver
SERVER=nelson
DBNAME=Livesystem
SHCOL=Y
MODULE=PLSLNL
COMPANY=0107
LUID=pjc