Consultor Eletrônico

SUMMARY:

A FILE DSN created by means of the Data Source ODBC Administrator can be modified, using a text editor, for use with a different database or to change the options. A FILE DSN may also be created manually via a text editor.

EXPLANATION:

By default, the FILE DSN is kept in c:\Program Files\Common Files\ODBC\Data Sources\filename.dsn.

-- This sample of a FILE DSN for SQL-89 explains the various commands:

[ODBC]

DRIVER= MERANT 3.60 32-BIT Progress

UID=User ID
PWD=User Password
DB=Database name to which you want to connect
OIDP=Specifies the protocol to connect Progress driver to
Open Interface Driver (OID)
OIDS=Service name for the Open Interface Driver (OID)
OIDH=The host name of the machine where the Open Interface
Driver is running
DBAM=(Direct/Via Server) Specifies how the OID access the database
DBPR=When database access is Via Server, specify the protocol to
connect OID to database server
DBS=Service file name or port number for the database when access
is Via Server
DBH=When access is Via Server, specify the host name of the server
where the database resides
ASC=Determines case sensitivity for values in a character column
and comparisons made to them
When set to 0 - not case sensitive
When set to 1 - case sensitive
SR=Determines whether the logon ID (UID) is required in the string
Default is 1; UID required
GST=Determines whether serializable transactions are allowed.
When set to 0 - serializable transactions are permitted
When set to 1 - serializable transactions are not allowed

-- Sample of a FILE DSN for SQL-92:

[ODBC]
DRIVER=MERANT 3.60 32-BIT Progress SQL-92 v9.1B
UID=SAROSS
DB=sports2000
PORT=srdbsrv
HOST=pcsaross

-- Sample of a connection SQL-89 string:

DSN=PROGRESS;DB=SPORTS;UID=SARAH;PWD=ZIGGY;
OIDP=TCP;OIDS=SRDBSRV;OIDH=PCSAROSS; DBAM=VIASERVER;

DBPR=TCP;DBS=SPORTSDB1;DBH=PCSAROSS2;ASC=0


References to Written Documentation:

http://www.datadirect-technologies.com/download/docs/odbc/odbcref/rprogess.htm