In the Try It Out exercise in Ch. 12 page 475, Connect.asp. I'm unable to get the exercise to work using either Access or SQL Server.

With Access, I get an error message "Could not find installable ISAM"


With SQL Server, I get and error message that user id sa is not associated with a trusted connection.

I using Windows XP Professional with SP2, MSDE 2000, and MS Office 2003.

Here is the code;

If strDatabaseType = "Access" Then
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "DataSource=E:\BegASPFiles\DownloadedSourceCode\Mo vie2000.mdb;" & _
  "Persist Security Info=False"
Else
  objConn.Open = "Provider=SQLOLEDB;Persist Security Info=False;" & _
  "User Id=sa;pwd=;Initial Catalog=Movie;" & _
  "Initial File Name=C:\Program Files\Microsoft SQL Server\MSSQL\Data\Movie2000.mdf"
End If

I have resolved the issue that I was having with the Access part of the exercise. It was a missing space between Data Source.

I created a different problem with the SQL Server MSDE part. I now get the error message the "login failed for user (machineName)\IUSER_(machineName).

How do I resolve this issue?

The MSDE problem is resolved. The code in the original post is missing the pwd= and Data Source parameters. The Initial File Name must be deleted.