I'm going through the Beginning ASP 3.0 book at the mo, and i'm well stuck.
I can see you've had people write in about this problem before unfortunately the suggestions and help answers given don't get me any further so i've come to you.
Chapter 12 page 475, where you make your first connection to a SQL data store. I want to use the SQL connection rather than the Access one but the connection string in the book code is just wrong. When i setup an instance of MSDE it needs a password. Even if i put 'setup BLANKSAPWD=1' at the command prompt to make a password-free instance it still doesn't work.
It looks like you've figured it out from your last post but the stuff about first setting up OLEDB for SQL through admin tools can't figure out.
I need the following hand-holding:
1. Exactly what should i type in at the command prompt to create my
2. Where should i place the database (MovieMSDE.mdf) file.
3. Exactly what should i type as the connection string in the file
Connect.asp where it currently reads:
objConn.Open "Provider=SQLOLEDB;Persist Security Info=False;" & _
"User ID=sa;Initial Catalog=Movie;" & _
"Initial File Name=C:\MSSQL7\Data\Movie2000.mdf"
Thanks in advance cos this is doing my nut in.
Aaagh F***ing Computer!