Welcome to WebmasterWorld Guest from 54.161.209.240

Forum Moderators: mack

Message Too Old, No Replies

Connecting Classic ASP to Sql Express

     
8:08 am on Mar 9, 2009 (gmt 0)

New User

5+ Year Member

joined:Sept 8, 2008
posts: 9
votes: 0


Hi basically i am .net developer ,recently my PM told me to develop existing project in classic ASP and Sql Express,here is the problem because as far as i know you don't have sql express interface unless you are using .Net.

Can someone please help me to find way to create tables in Sql Express and connect it to classic ASP

2:09 pm on Mar 9, 2009 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Jan 29, 2002
posts:980
votes: 0


ASP uses ADO to connect to databases. You just need an OLEDB connection string to connect to Sql Express. Something like:

Provider=SQLOLEDB.1;Data Source=*yourserver*;Initial Catalog=*yourdatabasename*;User ID=*youruserid*;Password=*yourpassword*;

And use ADO like:

<%
Const DB_CNN = "Provider=SQLOLEDB.1;Data Source=*yourserver*;Initial Catalog=*yourdatabasename*;User ID=*youruserid*;Password=*yourpassword*;"
Dim cnn,rst,sql
sql = "SELECT * FROM MyTable;"
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open DB_CNN
Set rst = Server.CreateObject("ADODB.Recordset")
rst.Open sql, cnn
'
'do stuff with recordset
'
'IMPORTANT: always clean up afterwards
rst.Close
Set rst = Nothing
cnn.Close
Set cnn = Nothing
%>

Download SQL Server Management Studio Express to create and manage your database and tables.

6:33 am on Mar 10, 2009 (gmt 0)

New User

5+ Year Member

joined:Sept 8, 2008
posts: 9
votes: 0


thanx mattur for ur help.....i started working on it...