Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
What to use for Oracle Server Name. (Read 6628 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
What to use for Oracle Server Name.
17.05.06 at 11:57:41
 
What should I used as Oracle Server Name when I try to connect to Oracle?
 
Bonnie from the USA asked the following question.
 
Question:
I have chosen to use the Microsoft OLE DB Provider for Oracle.
I add the database server name, type in the username and password, for the database/schema that I want to connect to, and click on "Test Connection", and this is what I get:
 
Test connection failed because of an error in initializing provider. Oracle error occurred, but error message could not be retrieved from Oracle.
 
Answer:
I think you are missing a proper configuration of the SQL*Net. You should type the database alias and not the server name.
 
Use the Oracle tools to create a so called TNS Name or TNS alias or database alias. This will create an entry in the tnsnames.ora. You should enter this name in the server name field.
 
As a test of your TNS name configuration you can use the following MSDOS command:
tnsping your-tns_name
Back to top
 
« Last Edit: 17.05.06 at 16:12:40 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1