- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
This is an Error generated by the Oracle Client when the Oracle Server can not
This error can be caused by several items:
Listener on the Oracle Server is not running. Check with an Oracle Administrator
The Oracle Server is off line. Check with an Oracle Administrator The
network connection to the Oracle server is not fully up and running. Check all
connection points between the Notes server and the Oracle Server A firewall
exists between the Notes Server and the Oracle Server, and is not configured to
allow access to both the Oracle Server's IP address and Port The ADDRESS
Parameter in the TNSNAMES.ORA file is incorrect. Use TNSPING (or TNSPING80 on
Oracle 8.0.x) to check the connection to the Oracle Server. Example of a
Utility for 32-bit Windows: Version 126.96.36.199.0 - Production on
Attempting to contact
(ADDRESS=(PROTOCOL=TCP)(HOST=DBSERVER)(PORT=1521)) OK (50 msec)
this is Not successful, check your Oracle Network Products Messages Manual to
resolve the errors that TNSPING points out.
well i found this from one
site .... hope u can read it and can solve your problem
Your SQL query does not look valid. Test the query in SQL Query analyzer, and then once it is working, copy it into your VB source. You will of course then need to make the query a string that VB will accept.
if it occurs after imported, it's because ctx'preferences was not imported. Try to get preferences from source (by reverse engeneriing or see with ctx_report.create_index_script package). You will get severals scripts to execute on target db