469,883 Members | 1,119 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,883 developers. It's quick & easy.

Databasa connectivity

I want to connect ASP database with MS access.
Dec 20 '06 #1
1 1084
shweta123
692 Expert 512MB
<%
dim con
dim constr
dim rs

con=Server.CreateObject("Adodb.Connection")
constr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Northwind.mdb;Persist Security Info=False"
con.open
rs=Server.CreateObject("Adodb.Recordset")
sql="Select * from..........."
set rs=con.execute(sql)
%>


Shweta
Dec 20 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Axel Dachtler | last post: by
3 posts views Thread by Omegamon | last post: by
3 posts views Thread by junaid | last post: by
3 posts views Thread by Niks | last post: by
1 post views Thread by Darren McDowell via .NET 247 | last post: by
1 post views Thread by ohs | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.