|
This is where you specify the string you use to
identify the database to which you are connecting (sometimes known
as a connect string), For example:
|
·
|
For Oracle over SQL*Net TCP/IP version 1, this would be of the
form: T:<machine_name>:<database_sid> |
|
·
|
For SQL*Net Version 2, this would be of the form: <machine_name><database_sid> |
|
·
|
For OLE DB/SQL Server, this would depend upon whether default
instances or named instances are being used (see Note below): |
|
·
|
If you are using a default instance, the connect string would
be of the form: <machine_name>:<database_name> |
|
·
|
If you are using a named instance it would be of the form:
<machine_name>\<instance_name>:<database_name> |
The Database field suggests a
database connection specification, if available in your
environment:
|
·
|
For Oracle, by fetching ORACLE_SID from the registry. |
|
·
|
For Sybase and OpenClient, by fetching DSQUERY |
|
·
|
For ODBC, by fetching Data sources from the registry. |
|
·
|
For SOLID, it will be "ShMem SOLID" by default. |
|
·
|
For Informix the last registry specification of SqlHosts. |
|
·
|
For DB2 the last found database name in db2cli.ini. |
See your RDBMS documentation
set for more information.
NOTE:
For OLE DB/SQL Server, you can use default instances or named
instances:
The default instance of the
SQL Server 2000 database engine operates the same way as the
database engines in earlier versions of SQL Server. The default
instance is identified solely by the name of the computer on which
the instance is running, it does not have a separate instance name.
When applications specify only the computer name in their requests
to connect to SQL Server, the SQL Server client components attempt
to connect to the default instance of the database engine on that
computer. This preserves compatibility with existing SQL Server
applications.There can only be one default instance on any
computer, the default instance can be any version of SQL
Server.
All instances of the database
engine other than the default instance are identified by an
instance name specified during installation of the instance.
Applications must provide both the computer name and the instance
name of any named instance to which they are attempting to connect.
The computer name and instance name are specified in the format
computer_name\instance_name.
There can be multiple named
instances running on a computer, but only the SQL Server 2000
database engine can operate as a named instance. The database
engines from earlier versions of SQL Server cannot operate as a
named instance.
|
