Hi Rae,
Have you updated the ColdFusion datasource information for this new
SQL Server 7 based DSN in the Administrator?
You will need to provide a user name and password to both the
Server's ODBC DSN (Control Panel > ODBC > System DSN > 'youruserdirectory' >
Configure > Next > Login ID & Password) to the SQL Server 7 database _AS
WELL AS_ the ColdFusion Administrator's datasources. This is because it is
not possible for ColdFusion to get access to your system's ODBC DSN login
information.
> -----Original Message-----
> From: Rae Bailey [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 28, 2001 3:11 AM
> To: Spectra-Talk
> Subject: UserDirectory Validation
>
>
> Hi everyone,
>
> You must forgive me for so many questions this is our first
> spectra build.
>
> We have CF Ent 4.5 SP 2, Spectra 1.5 all hotfixes applied, on
> WIN NT 4,
> Service Pack 5, IIS Web Server, MS SQL 7.
>
> The app is working perfectly on our dev server, and also on a
> laptop we use
> to transfer the files to the clients server.
>
>
> As requested by us, the clients server is a mirror of our
> configuration
> above.
>
> We have the original UserDirectory and a second UserDirectory
> for validating
> users, works perfectly on our dev server and on the transfer laptop.
>
> We ran scripts created on our dev server to upgrade the
> Access DB's to sql 7
> on the clients server. Prior to upgrading validation was
> working on the
> Access DB's. Once the db's are upgraded to SQL 7 validation
> fails. Has
> anyone had this problem before.
>
> The db's created in SQL 7 on client server are a mirror copy
> of ours on the
> dev server, because the scripts were created on our dev server.
>
> Site is due to go live mid July, we need to have this working by then.
>
> Thanks in advance,
>
> Rae
>
> Rae Bailey
> Internet Media Consultancy Group Pty Ltd
> 02 4963 7855
> 0411 447 430
> http://www.imcg.com.au
>
> Proud supporters of the James Craig Restoration
> http://www.seaheritage.asn.au/jamescraig
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
