Versions Compared

Old Version 7

changes.mady.by.user Rashmi Likhite

Saved on

compared with

New Version 8

changes.mady.by.user Sumeet Tribhuvan (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Celoxis JDBC Probe is a java program that helps understanding of connection issues with your database server. 

...

productone of the following:
oracle (for Oracle), postgresql pgsql (for Postgresql 9.0), mssql (for SQL Server 2008, 2012, 2014)
nameThe name of your database
user/passwordThe username and Password to be used to connect to the database.
NOTE:  In case of SQL server, the login and database must be configured to use the SQL Authentication mode (or Mixed mode), not Windows authentication mode only.
hostThe machine name of the server where the database is running
portThe port of the database server. This is an optional field and when unspecified the default port will be used. 

...

Understanding the Error Messages

Common errors for Oracle

ERROR MESSAGEPOSSIBLE CAUSES
The Network Adapter could not establish the connection
  • The host name cannot be resolved by the DNS server.
  • Database server is not running on the host.
  • The database port on the database server is inaccessible because of a firewall 
Invalid username/password; logon deniedUsername or password is incorrect
Connection refused(DESCRIPTION=(TMP=) (VSNNUM=153092352)(ERR=12505) (ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
  • The database name is incorrect
  • The user doesn't have privileges to logon to the database

...