Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help VBA SQLXL Database

Buy now

Download now

SQL*XL online help

 

SQL*XL API: Database Object

Database Object

SQL*XL
home

SQLXL    
  Database  
    Parameters

Description:

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.

 

Properties:

Name Data Type Description
Connected As Boolean Connected is True when SQL*XL is currently connected to the database and False when it is not connected.
ConnectionType As Long (ReadOnly) litOO4O for Oracle Object for OLE connections or litSQLXLADO for all ADO connections.
Database As String Name of the database of the current connection. If Connected = False this property will be "".
UserName As String The user who currently connected to the datbase. If Connected = False this property will be "".

Methods:

Name Parameters Description
Commit   Close the current transaction by saving the changes if any. Start a new transaction after the commit.
Connect 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.
DisConnect   Disconnects from the database. Use the Connected property to check whether SQL*XL is logged on.
Rollback   Close the current transaction by rolling back all changes. Start a new transaction after the rollback.

 

Example:

Issue a commit and disconnect from the database:

SQLXL.Database.Commit
SQLXL.Database.DisConnect

 

Example:

Connect to a database using ADO:

SQLXL.Database.InitialiseSQLXL
	SQLXL.Database.Connect UserName:="scott", Password:="tiger", DBAlias:="", ConnectionType:=litSQLXLADO, ConnectionString:="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=scott;Data Source="""";Extended Properties=""""", AllowTransactions:=True
        

 

SQL*XL ribbon in Excel