Ad:

ASP Discussion Thread
Unsolved
Views: 26406

Permalink

Jun 28th, 2006

How i Can connect Sql Server with ASP

Expand Post »

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

Sushil ..

Similar Threads

How to connect sql database in asp.net using VB? in ASP.NET
connect SQL Server by button in C#
How to Connect to an SQl server using C language in C
SQL Server, Images and DataGrid in ASP.NET in ASP.NET
How to connect ASP with sql server ? in Community Introductions

kapilver

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Mar 2006

Permalink

Jun 29th, 2006

Re: How i Can connect Sql Server with ASP

Hi Sushil,

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

ASP Syntax (Toggle Plain Text)
<%
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
%>
<%
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
%>

Last edited by Ezzaral; Jun 11th, 2010 at 1:22 pm. Reason: Added code tags. Please use them to format any code that you post.

sandeep.kharat

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jun 2006

Permalink

Aug 4th, 2009

Re: How i Can connect Sql Server with ASP

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?

Zero13

Reputation Points: 120

Solved Threads: 134

Practically a Master Poster

Offline

620 posts
since Jan 2009

Permalink

Aug 11th, 2009

Re: How i Can connect Sql Server with ASP

Hi Sushil,

connect ASP wtih SQL Server.

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.

Egypt web

Reputation Points: 12

Solved Threads: 0

Newbie Poster

Offline

19 posts
since Aug 2009

Permalink

May 7th, 2010

Re: How i Can connect Sql Server with ASP

i donot know about how to set drivers. plz tell me the name of drivers of sql

kiran gaba

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since May 2010

Permalink

May 26th, 2010

Re: How i Can connect Sql Server with ASP

well i tried the above code to connect the SQL table, but it is always giving me an error and the webpage can not be displayed... any help please.. (btw i'm using SQL server 2008)

mohamed_r

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since May 2010

Permalink

May 31st, 2010

Re: How i Can connect Sql Server with ASP

please guys help me i want code to connect my asp code to the MSSQL SERVER
Please help me

maips

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since May 2010

Permalink

Jun 11th, 2010

Re: How i Can connect Sql Server with ASP

Have you tried doing it through the designer hence creating the connection for you automatically

donnybrasco

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2010

Permalink

Jun 11th, 2010

Re: How i Can connect Sql Server with ASP

It's doubtful. They evidently cannot even follow the most basic of instructions, search on their own for information that is available all over the net, or post detailed information about the problems they are experiencing.

Ezzaral

Moderator

Featured Poster

Reputation Points: 3239

Solved Threads: 839

Posting Genius

Offline

6,761 posts
since May 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: Is it possible to make process my form in two ways?

Next Thread in ASP Forum Timeline: Job site in ASP

DaniWeb Message

Cancel Changes

User Name
Password