Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP 3.0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 3rd, 2005, 12:55 PM
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ch. 12 Connect.asp

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


  #2 (permalink)  
Old August 5th, 2005, 02:22 PM
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?

  #3 (permalink)  
Old August 5th, 2005, 02:47 PM
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.



Similar Threads
Thread Thread Starter Forum Replies Last Post
CH 12 LoadTimeSheet() Problem chuck BOOK: Beginning VB.NET Databases 11 July 26th, 2012 11:48 AM
CH 12 login nightmare gegala BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 2 December 31st, 2007 09:34 AM
Beginning ASP 3.0, Chapter 12 (Connect.asp). Richard LaChance BOOK: Beginning ASP 3.0 4 July 24th, 2004 04:12 PM
Ch. 4 & Ch. 12 athena BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 July 23rd, 2004 10:54 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.