11
Team,
I constantly keep getting this error message:
Error Type:
Provider (0x80040E14)
One or more errors occurred during processing of command.
/asptestpa.asp, line 36
whenever I try to run asptestpa.asp:
------------------------
<html>
<head>
<title> Time Check </title>
<!-- #Include File="ADOVBS.INC"-->
</head>
<body>
</script>
<script language = "vbscript">
<%
' Write out a the current server time' Response.Write "<p>The server time is now: "
Response.Write Time
Response.Write"</p>"
Dim objConn
Dim objCommand
Set objConn = Server.CreateObject("ADODB.Connection") ' This line creates the ActiveX Database Object
Set objCommand = server.createobject("ADODB.Command")
objConn.ConnectionString = "Provider=ADsDSOObject;Password=abcde;User ID=plateau;Encrypt Password=False;Data
Source=GTMSP;Mode=Read;Bind Flags=0;ADSI Flag=-2147483648;"
objConn.ConnectionTimeout = 1
objConn.CommandTimeout = 1
objConn.CursorLocation = adUseClient
objConn.Open 'This commands the database to open
objCommand.ActiveConnection = objConn
objCommand.CommandText = "select * from pa_student"
objCommand.CommandTimeout = 1
set oRS = objCommand.Execute
For i = 0 to oRS.fields.count - 1
Response.Write oRS.Fields(i).Name & ", "
oRS.MoveNext
next
oRS.Close
set oRS = nothing
set objCommand = nothing
objConn.Close
set objConn = nothing
set objConn = nothing
%>
All I am trying to do is query off the pa_student table!!
