Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #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"
  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

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

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.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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

All times are GMT -4. The time now is 03:45 PM.

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