14. februar 2001 - 16:59
Der er
1 kommentar og
1 løsning
DSN connection til ORACLE?
Jeg forsøger at åbne op til en aixserver med en Oracledatabase men følgende kode men jeg får denne fejl:
Microsoft OLE DB Provider for ODBC Drivers fejl \'80004005\'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12505: TNS:listener could not resolve SID given in connect descriptor
<%
Dim objConn
Set objConn = Server.CreateObject(\"ADODB.Connection\")
ObjConn.Open \"DSN=PPRIM;UID=min_user;PWD=mit_password;\"
Dim objRS
Set objRS = Server.CreateObject(\"ADODB.Recordset\")
objRS.open \"KAMP_VLOCK_TABLE\", objConn, , , adCmdTable
Do While Not objRS.EOF
Response.write objRS(\"PID\")
Response.write objRS(\"PLOCK\")
Response.write objRS(\"HOST_ID\")
objRS.movenext
loop
objRS.close
set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>
14. februar 2001 - 17:02
#1
Følgende fik jeg da jeg prøvede at åbne min connection via Microsoft Query?
***********************************************************************
Fatal NI connect error 12505, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=PPRIM)(CID=(PROGRAM=C:\\Programmer\\Microsoft Office\\Office\\MSQRY32.EXE)(HOST=TD171794)(USER=V02106)))(ADDRESS=(PROTOCOL=TCP)(HOST=PPRIM)(PORT=1521)))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.6.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.0.6.0.0 - Production
Time: 14-FEB-01 17:04:12
Tracing not turned on.
Tns error struct:
nr err code: 12204
TNS-12204: TNS:received data refused from an application
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
