Hi all.
I have problems with connection ASP and Oracle. I use Windows Server 2008 Enterprise R2 64 bit.
All this string connections not working:
cn.Open "Provider=msdaora; Data Source=ORCL; User Id=ROOT; Password=xxxxxx;"
Error:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed
cn.Open "Provider=MSDAORA.1;Password=xxxxxx;User ID=ROOT;Data Source=ORCL;Persist Security Info=True;"
Error:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed
cn.Open "Provider=OraOLEDB.Oracle;ORCL;UserId=ROOT;Password=xxxxxx;"
Error:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed
cn.Open "Provider=MSDASQL;DRIVER={Microsoft ODBC for ORACLE};UID=ROOT;PWD=xxxxxx;Server=ORCL"
Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][Driver Manager ODBC] Data source name not found and no default driver
cn.Open "Driver={Microsoft ODBC for Oracle};Server=ORCL;Uid=ROOT;Pwd=xxxxxx;"
Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][Driver Manager ODBC] Data source name not found and no default driver
Can you help me?
Many thanks
MR