<% Set conn=Server.CreateObject("ADODB.Connectiion") Con.Pro

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

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

Question Posted / thimmaiah

2 Answers
4268 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the Difference B/W Onclick() and Oncommand() in ASP.Net? If Possible Explain with Realtime Example?

3086

how can we delete cookies by coding part . so pls help me

2193

What is server control

1959

What is the difference between the value-type variables and reference-type variables

945

How do I save asp file in notepad?

1087

How add insert options in datagrid control in footer row.

2377

we are doing Design of Placement Website as our academic project. Home page is in c#.net format and register page is in asp.net format. We met a problem in this.register page is not linked in home page. how i complete my project with out any change..?

2004

what is the default .net provider

2297

Explain the event handlers of session object?

1010

IN THREE TIER AMONG THREE LAYERS WHICH ONE IS INDEPENDENT LAYER AND HOW?

1909

i learnt .net and would like to know if there is any institute in hyderabad that gives real time knowledge.i worked on testing and planning to move on to .net putting same amount of experience in .net.kindly suggest me the institute and other details.

1778

What is classic asp application?

955

What are the function of attributes of the