Saturday, February 13, 2010

Could not resolve service name /vdir/filename.asp , The Oracle(tm) client and networking components were not found asp connection oracle

When trying to connect to Asp to oracle the following error messages may come.

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Oracle][ODBC][Ora]ORA-12154: TNS:Could not resolve service name /vdir/filename.asp, line NNN.


OR

The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.

You will be unable to use this driver until these components have been installed.


To find out the reason and solutions for this error follow the following steps

1. Try a test connection in oracle's sql plus utility. If the connection fails you have a bad installation or configuration of oracle client components.

2. If the oracle is first installed on IIS you should reboot at once.

3. If theire is multiple copies of OCIW32.dll you have to make sure that there is only one copy of OCIW32.dll which should be in /Bin folder of the oracle home folder.

4. Add the IUSR_machine name account and the IWAM_machine name account to the Oracle home folder. Give both accounts full control.

To do this, right-click on the Oracle home folder in Windows Explorer. Click Properties, and then click the Security tab. Add the appropriate accounts and then give them full control. Restart your computer. IDShop – ID Card Printers, Biometric, Security Systems in Dubai, UAE Cloud Based Card Printing Software UAE ID Card Printer Supplier Dubai | Plastic Card Printer in Abu Dhabi, UAE ID Card Printer

No comments:

Post a Comment