Database

Previous Next

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:

· Default 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.

· Named Instances

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.