I was able to get the Access side of this to work without any problems. However I could not get it to access in SQL. I am using SQL Server 2000 sp4 Dev. I have set the permissions on sa and even tried using the anonymous login and still only recieved error 500.

Dim strDatabaseType
'strDatabaseType = "Access"
strDatabaseType = "MSDE"

If strDatabaseType = "Access" Then
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=C:\BeginningASP3\Movie2000.mdb;" & _
               "Persist Security Info=False"

Else
   objConn.Open = "Provider=SQLOLEDB;Persist Security Info=False;" & _
                "User Id=sa;pwd=CBR600rr;Initial Catalog=Movie;" &_
              "Data Source=C:\Program Files\Microsoft SQL Server\MSSQL\DATA\Movie2000SQL.mdf"

End If

I have Resolved this issue with the following.

First I had to setup the OLEDB in windows for SQL via the Administrative tools, second I had to go into the registry and reset the Authentication type as mixed for MYSQL, it was initially set as <default> or Windows Authentication only. Finally I had to change the connection string to the following

Else

  objConn.Open "Provider=SQLOLEDB;Data Source=<server>;Initial Catalog=Movie2000SQL;User Id=<Name>; Password=<Password>;"

End If
<server> = name of server in SQL
<name><password> = user defined name and password

I do appreciate the help though :)

Hi Josh,

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
         instance.
      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:

            Else
                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!