How do I access tables on different databases on the same server?

Article ID: 775
Last updated: 05 Feb, 2008
Article ID: 775
Last updated: 05 Feb, 2008
Revision: 1
Views: 3263
Posted: 26 Jun, 1997
by Dean J.
Updated: 05 Feb, 2008
by Dean J.
Problem


How do I access tables on different databases on the same server?


Action


It is possible to access tables on different databases on the same server using DBTools.h++. The user must provide the complete name of the table when creating an instance of RWDBTable.

Example:

   RWDBDatabase RWDBManager::database("SYBASE","S1002","user","pwd","DB1");
RWDBTable myTable = database.table("DB1.user.tableName");

NOTE: This syntax applies for Sybase and may require some modifications for other databases.

This article was:   Helpful | Not helpful
Report an issue
Article ID: 775
Last updated: 05 Feb, 2008
Revision: 1
Views: 3263
Posted: 26 Jun, 1997 by Dean J.
Updated: 05 Feb, 2008 by Dean J.

Others in this category