Configuring Oracle Client Files Edit Oracle / Network's TnsNames.ora file Make sure there is a SID_SERVERID content. There is a management tool to generate. Connect Oracle Database in ASP
ODBC connection
Provider = msdasql; driver = {microsoft odbc for oracle}; uid = user; pwd = password; server = Your_tnsnames_alias
OLE DB connection
Provider = msdaora.1; data source = your_tnsnames_alias; user ID = user; password = password
or
Provider = oraoledb.racle.1; persist security info = true; user ID = user; password = password; data source = your_tnsnames_alias Note IWAM_ machine name permissions are changed to fully control.
In use, it is found that the data can be read data using ODBC. And use OLE DB in connection with an error
