ASP 连接Oracle数据库的问题
conn.asp
第一种连接方式:
Set Conn=Server.CreateObject("ADODB.CONNECTION")
ConnStr="Provider=OraOLEDB.Oracle;data source=ES40;user id=TT;password=TT;"
Conn.Open ConnStr
错误:
OraOLEDB (0x80004005)
ORA-12640: Authentication adapter initialization failed
第二种连接方式:
Set Conn=Server.CreateObject("ADODB.CONNECTION")
ConnStr="Driver={microsoft odbc for oracle};server=ES40;uid=TT;pwd=TT;"
Conn.Open ConnStr
错误:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified