New Datasource connection

[intrepid402]

I am trying to add the samples through the New Datasource connection.

I am using Oracle database and I use SQL*Net connect string which I got from tnsnames.ora

DEMODB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = demodb)
    )
  )



I used demodb in that field. and my content manager username as password. When I test the connection, I am getting "The IBM Cognos gateway is unable to connect to the IBM Cognos BI server. The server may be unavailable or the gateway may not be correctly configured.
Try again or contact your administrator."

After I try to add a new datasource, its like the BI server just breaks.

I think my IIS is configured properly. Does anyone one have any input in why when I am trying to add a new datasource, this breaks? I have stopped the IBM cognos services and restarted them, still no use.

Yesterday when I had the problem I ran the Cognos Configuration as administrator and started the service. Which solved the problem and was able to add the datasource. But I had to delete them and am trying to re add them and now I am unable to do it.

Any suggestions?

[sdf]

can you provide a more detailed picture of your setup?
e.g Is your set up 1 server ( Cognos and database )
      Are you using 32bit gateway etc.

Just a tip, in your TNS names. Change localhost to IPaddress or Hostname.

[intrepid402]

Thanks so much. Feds.

It was a 32 bit environment running on oracle. I tried so many different ways and methods. Using IIS 7, ISAPI and finally Apache. I don't know what differently I tried, but it was fixed using Apache 2.2. It just sort happened magically. Even using Apache I tried number of times but this one time just worked like charm and I didn't see that error message again.