Raymond - I checked the file and this is what I found:
[SmSampleUsers]
Query_Enumerate=select Name, 'User' as Class from SmUser Union select Name,
'Group' as Class from SmGroup order by Class
Query_InitUser=select Name from SmUser where Name = '%s'
Query_AuthenticateUser=select Name from SmUser where Name = '%s' and
Password = '%s'
Query_GetGroups=select SmGroup.Name from SmGroup, SmUser, SmUserGroup where
SmUser.Name = '%s' and SmUser.Id = SmUserGroup.UserId and SmGroup.Id =
SmUserGroup.GroupId
Query_GetUserProp=select %s from SmUser where Name = '%s'
Query_SetUserProp=update SmUser set %s = %s where Name = '%s'
Query_GetObjInfo=select Name, 'User' from SmUser where Name = '%s' Union
select Name, 'Group' from SmGroup where Name = '%s'
Query_GetUserProps=Name, Id, FirstName, LastName, TelephoneNumber,
EmailAddress
Query_IsGroupMember=select Id from SmUserGroup where UserId = (select Id
from SmUser where Name = '%s') and GroupId = (select Id from SmGroup where
Name = '%s')
[UserDirectory]
Query_Enumerate=select UserName as Name, 'User' as Class from Users Union
select GroupName as Name, 'Group' as Class from Groups order by Class
Query_InitUser=select UserName as Name from Users where UserName = '%s'
Query_AuthenticateUser=select UserName as Name from Users where UserName =
'%s' and Password = '%s'
Query_GetGroups=select Groups.GroupName as Name from Groups, Users_Groups
where Users_Groups.UserName = '%s' and Groups.GroupName =
Users_Groups.GroupName
Query_GetUserProp=select %s from Users where UserName = '%s'
Query_SetUserProp=update Users set %s = %s where UserName = '%s'
Query_GetObjInfo=select UserName as Name, 'User' from Users where UserName =
'%s' Union select GroupName as Name, 'Group' from Groups where GroupName =
'%s'
Query_GetUserProps=UserName, Description
Query_IsGroupMember=select GroupName from Users_Groups where UserName = '%s'
and GroupName = '%s'
-----
As you can see UserDirectory appears in brackets about the middle of the
file. Is this how the file should look?
Thanks,
Laura
----- Original Message -----
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "Spectra-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 5:02 PM
Subject: RE: Configuration Problem
> Check <cfusion install folder>\bin\smdsquery.ini and make sure there is an
> entry for UserDirectory
>
> =======================================================================
> Raymond Camden, Principal Spectra Compliance Engineer for Allaire
>
> Email : [EMAIL PROTECTED]
> ICQ UIN : 3679482
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -----Original Message-----
> > From: Laura McReynolds [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 23, 2001 5:31 PM
> > To: Spectra-Talk
> > Subject: Re: Configuration Problem
> >
> >
> > UserDirectory is in sc1 and I also tried rebooting. Am still getting the
> > error.
> >
> > Thanks,
> > Laura
> > ----- Original Message -----
> > From: "Kumaran Nallore" <[EMAIL PROTECTED]>
> > To: "Spectra-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, January 23, 2001 3:00 PM
> > Subject: RE: Configuration Problem
> >
> >
> > > Laura,
> > >
> > > Check if the UserDirectory is included in the Security Context SC1.
> > >
> > > Kumaran
> > >
> > > -----Original Message-----
> > > From: Laura McReynolds [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, January 23, 2001 12:12 PM
> > > To: Spectra-Talk
> > > Subject: Configuration Problem
> > >
> > >
> > > I had the problem with the ODBC error when configuring Spectra 1.5
(eval
> > > version). I got fed up with fixing this error so I decided to try to
> > > uninstall and reinstall Spectra. This time around the User Account was
> > > created successfully. However, I am getting the error I was getting
> > earlier:
> > >
> > > Testing Final Configuration
> > >
> > > Security Configuration Error
> > >
> > > The Spectra configuration wizard has detected a problem with the
> > ColdFusion
> > > Advanced Security configuration. Spectra cannot create a
> > security context,
> > > userdirectory, user or policy. The configuration wizard has
> > verified that
> > > advanced security is installed and enabled, so this is most likely a
> > > configuration problem. Please review the following knowledge
> > base articles
> > > for assistance:
> > >
> > > - Common Allaire Spectra Installation Issues
> > > - Search the Allaire Installation knowledge base
> > >
> > >
> > > The error message returned is:
> > > Cfa ()
> > > CFAuthenticate Tag Error.
> > >
> > > Internal Security Error.
> > >
> > >
> > >
> > > ----
> > >
> > > When I reinstalled Spectra, the old UserDirectory Access dsn was
> > reinstated
> > > in the ColdFusion Administrator ODBC and in the Control Panel's ODBC.
Is
> > it
> > > the Access database that is causing this error? If so, how do
> > you suggest
> > I
> > > go about fixing this problem?
> > >
> > > Thank you,
> > >
> > > Laura
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
