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 Commands

Buy now

Download now

SQL*XL online help
 

SQL*XL: Connect command

Connect command

SQL*XL
home

Syntax:
CONNECT user_name/password@database[,connection_string];

Description:
Connects to a database. It will do exactly the same as if you would use the connection dialog. Use the same details as you would use on the connection dialog and use the same provider as is listed there.

user_name:User name to login with
password:password to authenticate the user
database:database alias as used in the connection dialog
connection_string:ADO connection string. If ommitted an OO4O Oracle connection is attempted.

Examples:
connect scott/tiger@myora8i;

See also:

SQL*XL ribbon in Excel