pc:DatabaseExists

Determines whether or not a database exists at a connection. In Oracle terms, "database" designates the collection of tables (if any) stored in the database account of the user by the name of "database".

Returns a <yes> tag with properties of the database if it exists, or a <no> tag with existing sibling databases if it does not exist.

Syntax

<pc:DatabaseExists

rdbms="oracle"

connectstr="connectstr"

database="database"

owner="owner"

pwd="ownerpassword"

dba="dba"

dbapwd="dbapassword"

All attributes are required. rdbms must be oracle. connectstr must be the full database connectstring (as opposed to the short alias you can declare in "tnsnames.ora"). database must be the database user name of the database account that contains the database tables. The combination of owner and pwd must be a successful DBA login that is required to get confirmation that the database exists. The combination of dba and dbapwd must be a successful DBA login that is required to get the list of existing schemas. This list is only returned if dba has the 3 lowercase letters sys as its name, or as part of its name.

Example

<pc:DatabaseExists
    rdbms="oracle"
    connectstr="
        (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=L3100100247.usoft.com)(PORT=1521))
        (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)))"
    database="USD91_TRAVEL"
    owner="sys"
    pwd="manager"
    dba="sys"
    dbapwd="manager"
/>

If the USD91_TRAVEL database account exists and the owner/pwd username/password combination is a successful login for finding out about it, the return value looks like this:

If the USD91_TRAVEL database account does not exist but the dba/dbapwd username/password combination is a successful login for finding out about existing database accounts at the connection, the return value looks like this:

Syntax

<pc:DatabaseExists

rdbms="sqlserver"

connectstr="connectstr"

database="database"

dba="dba"

dbapwd="dbapassword"

The required rdbms must be sqlserver. The required connectstr must be the string identifying the Server Name in terms of Microsoft SQL Server Management Studio. This is the same database connect string that you use in USoft Binder to access application data, except for the database suffix introduced by a colon. The required database must be the database name. Compare the following example string in the two cases:

USoft Binder	USoft Blend, pc:DatabaseExists
MYSERVERNAME\SQLEXPRESS:MYDATABASE	connectstr="MYSERVERNAME\SQLEXPRESS"
MYSERVERNAME\SQLEXPRESS:MYDATABASE	database="MYDATABASE"

The combination of dba and dbapwd is a username/password combination that allows you to access the required database information using SQL Server Authentication. This combination is optional if you are connecting to the database server using Windows Authentication, and required if you are using SQL Server Authentication. In either case, this username/password information is returned in the return XML string if the database exists.

Example

This example only works if you have access to the database server using Windows Authentication:

<pc:DatabaseExists
    rdbms="sqlserver"
    connectstr="P6400100200\SQLEXPRESS"
    database="USD91_TRAVEL"
/>

If the USD91_TRAVEL database account exists, the return value looks like this:

<yes

connectstr="Server=L3100100247\SQLEXPRESS;Integrated security=SSPI;database=USD91_TRAVEL2"

usoftconnectstr="L3100100247\SQLEXPRESS:USD91_TRAVEL2" />

If the USD91_TRAVEL database account does not exist, the return value looks like this: