View Thread: Microsoft OLE DB Provider for SQL Server

Welcome Guest | Register | Login

Killersites.com Forum

Category: Programming

Forum: ASP - Active Server Pages

Thread: Microsoft OLE DB Provider for SQL Server

Quick Go »

No member browsing this thread

Thread Status: Active
Total posts in this thread: 2

[ ]

Author

This topic has been viewed 1786 times and has 1 reply

shalini
Stranger

Joined: Dec 3, 2008
Post Count: 1
Status: Offline


Microsoft OLE DB Provider for SQL Server

ASP Codes
Error Number -2147217900
Source code that caused the error
Category Microsoft OLE DB Provider for SQL Server
Error Occurred in /Employee/Insert.asp
Line Number 76
Column Number -1
Description Line 1: Incorrect syntax near ','.
Extended Description
===============
Using Code

<%@ LANGUAGE="VBScript" %>
<%
Option Explicit
'Buffer the response, so Response.Expires can be used
Response.Buffer = TRUE
%>
<html>
<body>

                   

</td>
</tr>

Time is <%=time()%>



 
 

</body>
</html>

<?xml version="1.0"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<% dim con, rst, rst1
Set con = Server.CreateObject("ADODB.Connection")
con.Open "Provider=SQLOLEDB.1;Data Source=156.0.3.3;Initial Catalog=helpdesk;uid=sa;pwd="
Set rst=con.Execute("Select * from Employee order by EmpId")
%>

<%

Session.timeout = 40

dim dtToday
dtToday = date
response.write(" Today is : " & Date)
response.write (" " )
response.write (" " )

' Get the information from the form fields
dim empid,totalleave,leavebalance,cas_leave,med_leave,leave_not_approved,no_of_days_required,reason_for_
leave

totalleave=Request.form("TotalLeave")
empid=Request.form("txtid")
leavebalance=Request.form("txtleavebal")
cas_leave=Request.form("txtcasleave")
med_leave=Request.form("txtmedleave")
leave_not_approved=Request.form("txtnal")
no_of_days_required=Request.form("txtnodr")
reason_for_leave=Request.form("txtreason")

rst.close

%>
Please help me ( for correct code)
----------------------------------------
[Edit 1 times, last edit by admin at Dec 3, 2008 8:13:12 AM]

[Dec 3, 2008 5:08:58 AM]