Re: error to connect ASP page to Oracle

1. Yes. If you see Oracle in Orahome92 in ODBC Administrator, that means you have the Oracle ODBC Driver Installed.
2. You will not see Oracle OLE DB Providers in the list of ODBC drivers, as it is not an ODBC Driver. First of all, you should understand the fact that you should use ODBC driver in a scenario where you do not have any other choices. If you have a better Driver to connect to the DB, always use that..!
3. OLE DB is always better than ODBC by all means. With ODBC, you will be restricted to only certain DB specific tasks unlike the OLE DB driver. Speedwise, from my experience, OLE DB is always been better. Check that you have Oracle OLE DB drivers installed. Goto oracle universal installer, and in the section Oracle Programmer, you will see Oracle OLE db. Configure your tnsnames before you do anything. Make sure you are able to connect to Oracle from SQLPlus, or any other tool. If you are using ODBC, while you create a DSN, you will see an area where you have to specify TNS service name. Create this tnsname and make sure you are able to connect to DB, then proceed. Whatever drivers you are using, be it ODBC, or MSDAORA, or Oracle OLE db Provider, you need the net service name to connect to DB. Hope that helps

Brijesh Mathew Received on Fri Sep 23 2005 - 06:48:38 CDT