In UMRA, you can
connect to a wide variety of databases (SQL server, Oracle, etc.) using
an OLE DB connection.
Establishing a connection
To establish a
connection, click the Configure
button
in the Configure
database connection
section and select the OLE DB connection you wish to establish. You will
need to provide details regarding the source database name and other parameters.
Once you have established
a succesfull connection, the connection string will be displayed in the
Database connection
string window. A
connection string includes the source database name and other parameters needed for the initial
connection. The default value is an empty string.
Changing the connection
string
In some cases you may wish to customize this connection string (e.g.
when there is no OLE DB provider for your specific database or if you
wish to add certain keyword values for an existing connection. In the
table below you will find a list of valid names for keyword values within
the ConnectionString.
Name
Default
Description
Application Name
The name of the application, or '.Net SqlClient
Data Provider' if no application name is provided.
AttachDBFilename
-or-
extended properties
-or-
Initial File Name
The name of the primary file, including the full path name, of an attachable
database.
The database name must be specified with the keyword 'database'.
Connect Timeout
-or-
Connection Timeout
15
The length of time (in seconds) to wait for
a connection to the server before terminating the attempt and generating
an error.
Current Language
The SQL Server Language record name.
Data Source
-or-
Server
-or-
Address
-or-
Addr
-or-
Network Address
The name or network address of the instance
of SQL Server to which to connect.
Encrypt
'false'
When true, SQL Server uses SSL encryption
for all data sent between the client and server if the server has a certificate
installed. Recognized values are true, false, yes, and no.
Initial Catalog
-or-
Database
The name of the database.
Integrated Security
-or-
Trusted_Connection
'false'
When false, User ID and Password are specified in the connection. When
true, the current Windows account credentials are used for authentication.
Recognized values are true, false, yes, no,
and sspi (strongly recommended), which is equivalent to true.
Network Library
-or-
Net
'dbmssocn'
The network library used to establish a connection to an instance of
SQL Server. Supported values include dbnmpntw (Named Pipes), dbmsrpcn
(Multiprotocol), dbmsadsn (Apple Talk), dbmsgnet (VIA), dbmslpcn (Shared
Memory) and dbmsspxn (IPX/SPX), and dbmssocn (TCP/IP).
The corresponding network DLL must be installed
on the system to which you connect. If you do not specify a network and
you use a local server (for example, "." or "(local)"),
shared memory is used.
Packet Size
8192
Size in bytes of the network packets used
to communicate with an instance of SQL Server.
Password
-or-
Pwd
The password for the SQL Server account logging
on (Not recommended. To maintain a high level of security, it is strongly
recommended that you use the Integrated Security or Trusted_Connection
keyword instead.).
Persist Security Info
'false'
When set to false or no (strongly recommended),
security-sensitive information, such as the password, is not returned
as part of the connection if the connection is open or has ever been in
an open state. Resetting the connection string resets all connection string
values including the password. Recognized values are true, false, yes,
and no.
User ID
The SQL Server login account (Not recommended.
To maintain a high level of security, it is strongly recommended that
you use the Integrated Security or Trusted_Connection keyword instead.).
Workstation ID
the local computer name
The name of the workstation connecting to
SQL Server.
