Connect to SQL2005 mdf file with classic asp

[44nato44]

Hi

I have been trying for a while to connect to sql2005 mdf file but it just will not do it.

I had to downgrade from sql2008 database to a sql2005 mdf file so we could use it with our provide.

Hope somebody can help

This is the code I have got :

dim dbconn,sql,dbcomm,dbread
dbconn=New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ShellMLLPtest.mdf;Integrated Security=True;User Instance=True")
dbconn.Open()
sql="select * from dimBusiness"
dbcomm=New SqlCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()

 

[foxbox]

a) check if the local firewall is blocking SQL (add sql to the exeptions)
b) You must connect to the local SQL server, not the file (as you do with access). It looks like you are using SQL Express?

go here:

http://www.connectionstrings.com/