DaniWeb Forum Index > Web Development > ASP

How i Can connect Sql Server with ASP

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2006

Posts: 5

Reputation: kapilver is an unknown quantity at this point

Solved Threads: 0

kapilver

Offline

Newbie Poster

How i Can connect Sql Server with ASP

Jun 28th, 2006

Hi friend, i am trying to learn ASP but i face problem to connect ASP wtih
SQL Server.
Anyone help me.

Sushil ..

•

Join Date: Jun 2006

Posts: 3

Reputation: sandeep.kharat is an unknown quantity at this point

Solved Threads: 0

sandeep.kharat sandeep.kharat is offline

Offline

Newbie Poster

Re: How i Can connect Sql Server with ASP

Jun 29th, 2006

Hi Sushil,

use this code to add data in a table using asp and sql server

<%
dim cn, rs
set cn=server.CreateObject("adodb.connection")
cn.Open "Provider=sqloledb;SERVER=localhost;DATABASE=your_database_neme;UID=your_database_login_id;PWD=your_database_login_password;"
set rs=server.CreateObject("adodb.recordset")
rs.open "Select * from table_name",cn,adOpenKeyset,adLockOptimistic
rs.addnew
rs(0) = "here_is_your_value_for_first_field"
rs(1) = "here_is_your_value_for_second_field"
rs.update
rs.close
%>

•

Join Date: Jan 2009

Posts: 102

Reputation: Zero13 is an unknown quantity at this point

Solved Threads: 16

Zero13

Offline

Junior Poster

Re: How i Can connect Sql Server with ASP

Aug 4th, 2009

Connect to SQL server with ASP needs ADODB connection.
This connection can extract data from database and insert data into database.
What problem do you face?

•

Join Date: Aug 2009

Posts: 15

Reputation: Egypt web is an unknown quantity at this point

Solved Threads: 0

Egypt web

Offline

Newbie Poster

Re: How i Can connect Sql Server with ASP

Aug 11th, 2009

Hi Sushil,

connect ASP wtih SQL Server.

 Help with Code Tags 
 asp Syntax (Toggle Plain Text) 
<%
dim con, Rs
set con=server.CreateObject("adodb.connection")
con.Open "Provider=sqloledb;SERVER=localhost;DATABASE=database_name;UID=login_ID ;PWD=login_password;"
set Rs=server.CreateObject("adodb.recordset")
 
%>
<%
dim con, Rs
set con=server.CreateObject("adodb.connection")
con.Open "Provider=sqloledb;SERVER=localhost;DATABASE=database_name;UID=login_ID ;PWD=login_password;"
set Rs=server.CreateObject("adodb.recordset")

%>

Last edited by peter_budo; Aug 11th, 2009 at 2:28 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

http://www.egyptwebsolutions.com
Egypt Web design
Egypt Web Hosting
Egypt Web Maintenance
Egypt Search Engine Optimization