Forums

SQL AND DATABASES

This topic is locked

SQL ODBC connection eror

Balu T

Posted 03 Nov 2008 14:05:14

has voted

Vote

03 Nov 2008 14:05:14 Balu T posted:

Here is the error I getting uniquely on this page; I looked evrywhere and could not find the origin of this error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.

/JKI/nikhil/emp_detail.asp, line 56

----------------------------------
Server Name: IBM
Data Base: fennerpms
User name: sa, Password: password
----------------------------
<html>

<title>Employee Authorization</title>

<% if session("user_id"

="0" then
response.redirect("ktp/jki/login/login_frm_pms.asp")
end if
%>

<body link="red" text="#000000" bgColor="#FFFFFF" leftMargin="0" topMargin="0"
marginheight="0" marginwidth="0" >



<%

dim ps
dim ps1
dim ps2
dim s1
dim rs1
dim connection
dim recordset
dim recordset1
dim rs2
dim rs3
dim rs4
dim rs5
dim rs6
dim rs7
dim rs8

set Connection=Server.CreateObject("ADODB.Connection"

connection.open "FILEDSN=fennerpms;UID=sa;password=password"

set recordset = Server.CreateObject("ADODB.recordset"

set rs1 = Server.CreateObject("ADODB.recordset"

set rs2 = Server.CreateObject("ADODB.recordset"

set rs3 = Server.CreateObject("ADODB.recordset"

set rs4 = Server.CreateObject("ADODB.recordset"

set rs5 = Server.CreateObject("ADODB.recordset"

set rs6 = Server.CreateObject("ADODB.recordset"

set rs7 = Server.CreateObject("ADODB.recordset"

set rs8 = Server.CreateObject("ADODB.recordset"

s1= "select * from kra_part_a1"

ps="select * from kra_pers_dtl where emp_cd = " & session("emp_cd1"

& " "
recordset.open ps,connection

s2="Select * from kra_part_a1 where emp_cd ="& session("emp_cd1"

& " and year_of_appl= ' " & session("tcd"

& "' "

s3="select * from kra_personal_attr"

s4="select * from kra_appr_rec"

s5="select * from kra_yearly_couns"

s6="select * from kra_comp_asmt"

s7="select * from kra_trg_dev"

s8="select * from kra_potential_asmt"

rS2.Open s2,Connection

If NOT rs2.EOF then %>


<h4 align="center">Click here <a href="main.asp" target="_parent">KRA Menu</a></h4>

<% else %>

<%

rS1.Open s1,Connection, 1,2
rS1.Addnew
rS1("emp_cd"

= session("emp_cd1"

rS1("year_of_appl"

= session("tcd"

rs1("flag1"

= 0
rs1("flag2"

= 0
rs1("flag3"

=0
rS1.Update

rs3.open s3,connection, 1,2
rS3.Addnew
rS3("emp_cd"

= session("emp_cd1"

rS3("year_of_appl"

= session("tcd"

rS3.Update

rs4.open s4,connection, 1,2
rS4.Addnew
rS4("emp_cd"

= session("emp_cd1"

rS4("year_of_appl"

= session("tcd"

rS4.Update

rs5.open s5,connection, 1,2
rS5.Addnew
rS5("emp_cd"

= session("emp_cd1"

rS5("year_of_appl"

= session("tcd"

rS5.Update

rs6.open s6,connection, 1,2
rS6.Addnew
rS6("emp_cd"

= session("emp_cd1"

rS6("year_of_appl"

= session("tcd"

rS6.Update

rs7.open s7,connection, 1,2
rS7.Addnew
rS7("emp_cd"

= session("emp_cd1"

rS7("year_of_appl"

= session("tcd"

rS7.Update

rs8.open s8, connection, 1,2
rs8.Addnew
rS8("emp_cd"

= session("emp_cd1"

rS8("year_of_appl"

= session("tcd"

rS8.Update

%>

<%
end if
%>

<form method="POST" action="emp_register.asp">


<table border="2" width="100%">

<th colspan="3" >Registered Successfully!!! 
PERSONAL DETAILS</th>

<tr>
<td align="left" valign="middle" width="50%">

Name Of The Appraisee- 
<td width="36%"><% = response.write(recordset("emp_name"

)%> 

<td rowspan="20" align="center" valign="middle" width="5%">
<img src="/jki/nikhil/images/starman.jpg" width="89" height="118" >
</td>

<tr>
<td>Employee Code 
<td width="36%"><%= session("emp_cd1"

%>
<tr>

<td>Designation 

<td width="36%"><% = response.write(recordset("Designation"

)%> 
<tr>

<td>Position 
<td width="36%"><% = response.write(recordset("position"

)%> 
<tr>

<td>Level 
<td width="36%"><% = response.write(recordset("emp_level"

)%> 
<tr>

<td>Date of Entry Into Present Designation (MM/DD/YYYY)

<td width="36%"><% = response.write(recordset("DOP"

)%> 
<tr>
<td>Department Name 
<td width="36%"><% = response.write(recordset("Dept_name"

)%> 
<tr>

<td>Qualification 
<td width="36%"><% = response.write(recordset("qualification1"

)%> 
<tr>

<td>Additional Qualification after Joining

<td width="36%"><% = response.write(recordset("qualification2"

)%> 
<tr>
<td>Date Of Joining (MM/DD/YYYY)

<td width="36%"><% = response.write(recordset("DOJ_JKTI"

)%> 

<tr>
<td>Date Of Joining in JK EZ

<td width="36%"><% = response.write(recordset("DOJ_KTP"

)%> 

<tr>
<td>Date Of Birth (MM/DD/YYYY)

<td width="36%"><% = response.write(recordset("DOB"

)%> 

<tr>
<td>Name Of The Appraiser

<td width="36%"><% = response.write(recordset("appr_name"

)%> 
<tr>
<td>Appraiser's Designation-

<td width="36%"><% = response.write(recordset("appr_designation"

)%> 

<tr>
<td>Name Of Reviewer 
<td width="36%">MR. AK MAKKAR 
 

<tr>
<td>Reviewer's Designation-

<td width="36%"><% = response.write(recordset("rev_designation"

)%> 

<tr>
<td>Name of Functional Superior(where applicable)

<td width="36%"> 
<tr>
<td>Functional Superior's Designation

<td width="36%"> 

</td>

</right></div>
</table>

</form>

 
click here
<a href="main.asp" target="_parent">KRA Menu</a> 


</div>

</body>
</html>

Reply to this topic

Latest Extensions

App Connect Summernote File Upload Upload different files in Summernote Editor
App Connect Summernote Simple, yet powerful and modern WYSIWYG Editor
Bootstrap 4 Dynamic Table Generator 2 Automatically generate dynamic data tables
Bootstrap 4 Dynamic Form Generator 2 Auto generate perfect Bootstrap 4 dynamic forms in seconds
App Connect Bootstrap 4 Dynamic Paging Generator Auto generate awesome dynamic Bootstrap 4 paging in seconds
App Connect Event Calendar The most powerful full-sized event calendar for Dreamweaver
DMXzone App Connect Next generation client side framework for data-driven web sites and apps
DMXzone Database Custom Query Create advanced, complex custom SQL queries with ease

Latest Videos

Using App Connect Autocomplete Learn how to add autocomplete functionality on your page, using the App Connect Autocomplete
Creating Custom SQL Queries Learn how to create custom SQL Queries with DMXzone Database Custom Query
Restricting Access to Your Pages Learn how to restrict access to your pages, using DMXzone Security Provider 2
Adding Log Out Functionality with DMXzone Security Provider 2 Learn how to add log out functionality to your page with DMXzone Security Provider 2
Creating a Log In Page with DMXzone Security Provider 2 Learn how to create a log in page with DMXzone Security Provider 2
Setting Up Site Security Settings Learn how to setup your site security, using DMXzone Security Provider 2
Generating an Update Record Form Learn how to create an update record form, using the Bootstrap 4 Dynamic Form Generator 2
Generating an Insert Record Form Learn how to create an insert record form, using the Bootstrap 4 Dynamic Form Generator 2