Oracle 10g and ASP under Encryption mode

[nsung]

Recently we upgraded to Oracle 10g and added encryption on the server.

I used to access the database tables via Active Server Pages with the following connection string: MyConnection.op en "DSN=eisreport; Uid=eiu_sung;Pw d=xxxxx"

After upgrading to 10g it stop working with the following error message.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified
/reports/reports.asp, line 47 (the line indicates the above connection string)


The following three lines were added to 'sqlnet.ora' when upgrading the oracle client.

SQLNET.ENCRYPTI ON_TYPES_CLIENT = RC4_256
SQLNET.ENCRYPTI ON_CLIENT= required
SQLNET.CRYPTO_S EED=LDFKANTEJTE 8232AFDFDEDFD

So I think the problem may related to the encryption feature.
I have no idean where to fix. Can I still use ASP? or Do something in IIS???
Any assistance would be greatly appreciated.

[debasisdas]

Are you able to connect to server from client ?

[nsung]

Are you able to connect to server from client ?

Yes. I can. I can even connect and link the remote Oracle db tables from within MS-Access. But not from ASP :(

[nsung]

Yes. I can. I can even connect and link the remote Oracle db tables from within MS-Access. But not from ASP :(

Problem was solved!
I tried the same ASP code in a new IIS 7.0 server and it worked.
There may be a difference between IIS 6.0 and IIS 7.0. Thanks!!!