The Database object encapsulates all the functionality to do with the the database as a whole. This is mainly
connecting and disconnecting to the database and performing commits and rollbacks.
Connected is True when SQL*XL is currently connected to the database and False when it is not connected.
(ReadOnly) litOO4O for Oracle Object for OLE connections or litSQLXLADO for all ADO connections.
Name of the database of the current connection. If Connected = False this property will be "".
The user who currently connected to the datbase. If Connected = False this property will be "".
Close the current transaction by saving the changes if any. Start a new transaction after the commit.
UserName As String
PassWord As String
DBAlias As String
ConnectionType As Long
Optional ConnectionString As String
Optional AllowTransactions As Boolean
Connects SQL*XL to the database using the following connect string: username/password@dbalias. Set the ConnectionType to litOO4O or litSQLXLADO in order to make a connection using OO4O or ADO respectively. Check the Connected property to check whether the connect was successful. For ADO connections also use the optional ConnectionString parameter. The AllowTransactions parameter can be used to switch off transaction support.
Disconnects from the database. Use the Connected property to check whether SQL*XL is logged on.
Close the current transaction by rolling back all changes. Start a new transaction after the rollback.
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.