The answer is: it depends.
It depends on the programming language you are using and partially on the database you are using.
Most of the databases are services running on a web service. We can communicate with them using a special protocol, while we know the address and the port of the server where it runs. There are also databases stored in files, where we specify the target file.
Most of the programming lanugages and frameworks provide a "Connector" for databases, which allows us to communicate with the database. Of course you need to check if your programming language has a driver for the database type you want to connect to. Some frameworks or programming languaes also offer a higher level control structures called object-relational mapping, where the user can easily read or write some objects defined in the project.
When you create a database connection, it is appended to the list in the Database Manager dialog box.
To add a database connection:
1. In Workspace, select Tools, then Database Connection Manager.
2. Click New.
3. In Database Connection Name, enter a name for the database connection.
4. Select a data source type of Essbase.
5. In Server, add the Essbase Server Name and Port Number.
6. Re-enter the User ID and Password.
7.To add application and database names, click the magnifying glass, and make your selections.
8. Finally , click OK .
The database connection profile is appended to the list in Database Connection Manager dialog box.
Possible causes could be
-Bad configuration of TNSNAMES.ORA.
-No repository is located where is the service name identifier
The solution presented are:
-First Check TNSNAMES.ORA file of the database or the client you are using and check the settings, the most important are the HOST, SID and the ALIAS of the database, see if they match data from the computer that owns the database (server). The TNSNAMES is usually in a folder called Network or on NET80 in the case of some customers ORACLE.
A typical TNSNAMES of the database is as follows:
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server Name) (PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Service Name)
)
)
-Check that the service name matches the name that Windows provides, in the case of Oracle Database XE is always the XE service, other service facilities will be named as he was appointed at the time of creating the basis data.
This challenge is quite old, in the meantime a nice and elaborated solution for this problem has been described here
This is not a solution in the sense of tech screen - so don't rate it
CodeBeamer offers a webfolder that can be accessed with the help of the Windows Explorer. Connection to a server that’s located somewhere in the web can be done by using the wizard of connecting to network drives. Use “Extras” – “Connect to network drive”, which opens a wizard to connecting to computer in the local network. On the bottom of this wizard there are some more options. Here you can choose to “connect to a network server”, which starts a new wizard. Just go through the wizard, enter the URL of the codebeamer-server which is http://codebeamer.yourwebsite.at/cb/webfolder/ Then just save the connection, it appears under your “Networks” in the Windows Explorer and offers all of the server content in the convenient environment of the Explorer.