EssVConnect

Description

Logs in to a server, application, and database.

Syntax

EssVConnect(sheetName, username, password, server, application, database)
ByVal sheetName As Variant
ByVal username As Variant
ByVal password As Variant
ByVal server As Variant
ByVal application As Variant
ByVal database As Variant

Parameters

sheetName

Text name of worksheet to operate on. sheetName is of the form "[Book.xls]Sheet". If sheetName is Null or Empty, the active worksheet is used.

username

Text name of a user on the server.

password

Text name of the password for this user name.

server

Text name of the server to connect to.

application

Text name of the application to connect to.

database

Text name of the database to connect to.

Return Value

Returns 0 if successful. A negative number indicates a local failure (see VBA Return Values). A return value greater than zero indicates a failure on the server.

Example

Declare Function EssVConnect Lib "ESSEXCLN.XLL" (ByVal sheetName As Variant, ByVal username As Variant, ByVal password As Variant, ByVal server As Variant, ByVal application As Variant, ByVal database As Variant) As Long

Sub Conn()
X=EssVConnect(Empty, "User1", "password", "Local", "Sample", "Basic")
End Sub