Adding a DSN file automatically adds the DSN to the remote machine. (The application
must take the file DSN into account or adding the DSN using this technique might not work.)
MANAGING WINDOWS IN A NEW WAY 391
Although every database uses a different configuration strategy, the file DSN is always a text file
with a DSN extension. It??™s essentially a form of INI (initialization or configuration) file. Here??™s an
example file DSN for an Access database.
[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
DriverId=25
DefaultDir=G:\Access
DBQ=G:\Access\db1.mdb
Notice that this DSN includes such information as the database driver and the user identifier. It
also includes the location of the Access database and other information to control access to it. You can
easily create such a file using the ODBC Data Source Administrator utility, make any required changes
to the text file for the remote system, and then copy it to the remote system??™s file DSN directory.
Managing Windows in a New Way
You??™ll work with data in many ways as an administrator.
Pages:
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931