how to connect asp with sql server.......?

Write some code for connectivity between sql server and ASP...

Answers were Sorted based on User's Feedback



how to connect asp with sql server.......? Write some code for connectivity between sql server an..

Answer / thimmaiah

<%
Set conn=Server.CreateObject("ADODB.Connectiion")
Con.Provider="sql Sever Repulication OLEDB Provider for DTS"
conn.Open "C:/Programfile/Personnel
Records/Switching_Employee.Mdb"
set Rs=Server.createObject("ADODB.Connection")
Rs.OPen "Employee",conn
%>

Is This Answer Correct ?    0 Yes 0 No

how to connect asp with sql server.......? Write some code for connectivity between sql server an..

Answer / abera

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html;
charset=windows-1252">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY
<%
Set conn=Server.CreateObject("ADODB.Connectiion")
Con.Provider="sql Sever Repulication OLEDB Provider for DTS"
conn.Open "C:/Programfile/Personnel
Records/Switching_Employee.Mdb"
set Rs=Server.createObject("ADODB.Connection")
Rs.OPen "Employee",conn
%>
<Form method="record.asp" action="post">
EmpID:<INPUT><BR>
Fname:<INPUT><BR>
Lname:<INPUT><BR>Position:<INPUT><BR>
Age:<INPUT type=char><BR>
Sex:<SELECT size=select one gender> <OPTION value=Male
selected>Male</OPTION>
<OPTION value=Female>Female</OPTION></SELECT><BR>
Date of birth:<SELECT size=1 date> <OPTION value=1
selected>1</OPTION> <OPTION
value=2>2</OPTION> <OPTION value=3>3</OPTION> <OPTION
value=4>4</OPTION>
<OPTION value=5>5</OPTION> <OPTION value=6>6</OPTION>
<OPTION
value=7>7</OPTION> <OPTION value=8>8</OPTION> <OPTION
value=9>9</OPTION>
<OPTION value=10>10</OPTION> <OPTION value=11>11</OPTION>
<OPTION
value=12>12</OPTION> <OPTION value=13>13</OPTION> <OPTION
value=14>14</OPTION>
<OPTION value=15>15</OPTION> <OPTION value=16>16</OPTION>
<OPTION
value=17>17</OPTION> <OPTION value=18>18</OPTION> <OPTION
value=19>19</OPTION>
<OPTION value=20>20</OPTION> <OPTION value=21>21</OPTION>
<OPTION
value=22>22</OPTION> <OPTION value=23>23</OPTION> <OPTION
value=24>24</OPTION>
<OPTION value=25>25</OPTION> <OPTION value=26>26</OPTION>
<OPTION
value=27>27</OPTION> <OPTION value=28>28</OPTION> <OPTION
value=29>29</OPTION>
<OPTION value=30>30</OPTION> <OPTION value=25>25</OPTION>
<OPTION
value=26>26</OPTION> <OPTION value=27>27</OPTION> <OPTION
value=28>28</OPTION>
<OPTION value=29>29</OPTION> <OPTION
value=30>30</OPTION></SELECT> Month<SELECT
size=1 month> <OPTION value=1 selected>1</OPTION> <OPTION
value=2>2</OPTION>
<OPTION value=3>3</OPTION> <OPTION value=4>4</OPTION>
<OPTION
value=5>5</OPTION> <OPTION value=6>6</OPTION> <OPTION
value=7>7</OPTION>
<OPTION value=8>8</OPTION> <OPTION value=9>9</OPTION>
<OPTION
value=10>10</OPTION> <OPTION value=11>11</OPTION> <OPTION
value=12>12</OPTION></SELECT> Year<SELECT size=1 year>
<OPTION value=1935
selected>1935</OPTION> <OPTION value=1936>1936</OPTION>
<OPTION
value=1937>1937</OPTION> <OPTION value=1938>1938</OPTION>
<OPTION
value=1939>1939</OPTION> <OPTION value=1940>1940</OPTION>
<OPTION
value=1941>1941</OPTION> <OPTION value=1942>1942</OPTION>
<OPTION
value=1943>1943</OPTION> <OPTION value=1944>1944</OPTION>
<OPTION
value=1945>1945</OPTION> <OPTION value=1946>1946</OPTION>
<OPTION
value=1947>1947</OPTION> <OPTION value=1948>1948</OPTION>
<OPTION
value=1949>1949</OPTION> <OPTION value=1950>1950</OPTION>
<OPTION
value=1951>1951</OPTION> <OPTION value=1952>1952</OPTION>
<OPTION
value=1953>1953</OPTION> <OPTION value=1954>1954</OPTION>
<OPTION
value=1955>1955</OPTION> <OPTION value=1956>1956</OPTION>
<OPTION
value=1957>1957</OPTION> <OPTION value=1958>1958</OPTION>
<OPTION
value=1959>1959</OPTION> <OPTION value=1960>1960</OPTION>
<OPTION
value=1961>1961</OPTION> <OPTION value=1962>1962</OPTION>
<OPTION
value=1963>1963</OPTION> <OPTION value=1964>1964</OPTION>
<OPTION
value=1965>1965</OPTION> <OPTION value=1966>1966</OPTION>
<OPTION
value=1967>1967</OPTION> <OPTION value=1968>1968</OPTION>
<OPTION
value=1969>1969</OPTION> <OPTION value=1970>1970</OPTION>
<OPTION
value=1971>1971</OPTION> <OPTION value=1972>1972</OPTION>
<OPTION
value=1973>1973</OPTION> <OPTION value=1974>1974</OPTION>
<OPTION
value=1975>1975</OPTION> <OPTION value=1976>1976</OPTION>
<OPTION
value=1977>1977</OPTION> <OPTION value=1978>1978</OPTION>
<OPTION
value=1979>1979</OPTION> <OPTION value=1980>1980</OPTION>
<OPTION
value=1981>1981</OPTION> <OPTION value=1982>1982</OPTION>
<OPTION
value=1983>1983</OPTION> <OPTION value=1984>1984</OPTION>
<OPTION
value=1985>1985</OPTION> <OPTION value=1986>1986</OPTION>
<OPTION
value=1987>1987</OPTION> <OPTION value=1988>1988</OPTION>
<OPTION
value=1989>1989</OPTION> <OPTION value=1990>1990</OPTION>
<OPTION
value=1991>1991</OPTION> <OPTION value=1992>1992</OPTION>
<OPTION
value=1993>1993</OPTION> <OPTION value=1994>1994</OPTION>
<OPTION
value=1995>1995</OPTION> <OPTION value=1996>1996</OPTION>
<OPTION
value=1997>1997</OPTION> <OPTION value=1998>1998</OPTION>
<OPTION
value=1999>1999</OPTION> <OPTION value=2000>2000</OPTION>
<OPTION
value=2001>2001</OPTION> <OPTION value=2002>2002</OPTION>
<OPTION
value=2003>2003</OPTION> <OPTION value=2004>2004</OPTION>
<OPTION
value=2005>2005</OPTION> <OPTION value=2006>2006</OPTION>
<OPTION
value=2007>2007</OPTION> <OPTION value=2008>2008</OPTION>
<OPTION
value=2009>2009</OPTION></SELECT><br/>
<input type="submit" value="Submit">
<input type="reset" value="Reset">
</form>


</BODY></HTML>

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More ASP Interview Questions

How do I save asp file in notepad?

0 Answers  


Explain the difference between sap r/2 and r/3?

0 Answers  


What are the attributes of the <form> tags?

0 Answers  


What is difference between server.transfer and response.redirect ?

2 Answers   CIStems Software, Effexoft, VebTel,


What is the Default ScriptTimeOut for Server Object? A. 20 Sec B. 30 Sec C. 60 Sec D. 90 Sec

1 Answers  






How can I see what assemblies are installed in the global assembly cache?

0 Answers  


What is a variable?

1 Answers  


What is http header?

0 Answers  


What is Application-scope?

2 Answers  


Is asp still used?

0 Answers  


Is asp classic dead?

0 Answers  


what is the need of a sealed class when we are having a structure

0 Answers   HCL,


Categories