Re: XSQL-007: Cannot acquire a database connection to process page.

Dean,

I'm not sure if I'm reading your error properly, but it looks like you are generating the following error:

   ORA-12505 TNS:Listener could not resolve SID given in connect descriptor

   Cause: The SID in the CONNECT_DATA was not found in the listener's tables.

   Action: Check to make sure that the SID specified is correct. The SIDs that are supported can be obtained by typing LSNRCTL STATUS SERVICE_NAME and matching the SID specified in TNSNAMES.ORA with one of the SIDs displayed in the services summary

You'll have to configure your LISTENER.ORA file to listen for the appropriate SID you are connecting to.

HTH,
Brian

Dean Pullen wrote:
>
> Hi,
>
> I've setup an Oracle database on a Windows 2000 system and installed the
> XSQL Servlet, but when I click on a demo XSQL file, I get the following
> error:
>
> Oracle XSQL Servlet Page Processor 1.0.2.0 (Production)
> XSQL-007: Cannot acquire a database connection to process page.
> Io exception: Connection
> refused(DESCRIPTION=(TMP=)(VSNNUM=135286784)(ERR=12505)(ERROR_STACK=(ERROR=(
> CODE=12505)(EMFI=4))))
>
> What do I need to do to resolve this?
>
> Dean.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================