Ok,
First off I admit I'm completely new to this and am currently working through the book. I'm using vb 2005. I loaded the project tracker and have an issue with my connection string i'm guessing.
Not sure if I need to add a user to the database or what... any suggestions? Whenever I try to login I get the following exception in the dbPortal.vb file
:InnerException = {"Cannot open database "SECURITY" requested by the login. The login failed.
Login failed for user 'LAPTOP\user'."}
Thanks for the pointers and sorry for such a basic question.
By the way, I searched for an answer first, but never found one yet.
I don't think your connection is the immediate cause of your difficulty, but I can't really tell since you didn't post a copy of it.
You didn't mention how you're trying to run the PTracker application, but I'm thinking you're running it with a Remote Data Portal (either with Remoting or with Web Services) rather than utilizing a Local Data Portal. If that's the case, the problem sounds a lot like not having ASP.NET properly configured to work with IIS and/or SQL Server.
While not specifically relating to CSLA, you might want to take a look at this thread posted at Wrox's p2p Forum: http://p2p.wrox.com/topic.asp?TOPIC_ID=44653 especially starting with Imar's posting almost halfway down the page. As a side note, my first introduction to Rocky was through his book on Business Objects with VB6, which was published by Wrox.
Hope this helps,
Allen Anderson
sorry I didn't include the connection strings... here they are
<add name="PTracker" connectionString="Server=(local);Database=PTRACKER;Integrated Security=true"
providerName="System.Data.SqlClient" /><
add name="Security"connectionString="Server=(local);Database=SECURITY;Integrated Security=true" providerName="System.Data.SqlClient" />
I'll definately look at the link you suggested... thanks so far... hopefully I can get things up and running today.
Thanks again!
***EDIT
Stupid mistake... sorry... when I attached the db it had the name 'SECURITY.MDF' my connection string was looking for 'SECURITY'
It works now... thanks again!
Copyright (c) Marimer LLC