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 Trouble Shooting

Buy now

Download now

SQL*XL online help

 

SQL*XL: How do I know which database to connect to?

How do I know which database to connect to?

SQL*XL
home

The connect dialog in SQL*XL expects you to know the username, password and database alias for the database you connect to.


The database alias:

The database alias is a nickname for a database. You can specify an alias in the tnsnames.ora file directly or you can use the SQL*Net Easy Config Utility (from Oracle). Refer to the Oracle documentation about how to specify a database alias if you need further assistance.


If you use Personal Oracle then you can leave the field blank or use 2: or beq-local as database alias.


The username/password:

If you don't know the user name and password you cannot login to the database. If you do not have to specify a username and password you can login using a backslash (/) symbol in the username field and by leaving the password field blank.


If you use Personal Oracle, there are a few preset user names and passwords:

scott/tiger
po8/po8
system/manager

If you are in doubt or need further assistance please ask your DataBase Administrator (DBA).

See also:

SQL*XL ribbon in Excel