Kevin, You could rename the current "dmUser, dmgroup and dmUserToGroup" to something else on the Farcry DB, then create 3 views - dmUser, dmUsergroup and dmUserToGroup". The views would join your external DB data (names, emails etc) with the FC tables ... This is easily done as long as the DB permissions are correct.
The result would be a combination of the data. The objectID and group stuff would look correct to FC, but the actual data could be coming from your other DB. Of course the devil is in the details and this might still require some bending on the part of FC or your other DB. You would need to make sure that the proper columns are returned for FC to handle - but to FC a view looks just like a table. You can even update a view - as long as you are updating only 1 table at a time within the view. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, October 31, 2007 3:51 PM To: farcry-dev Subject: [farcry-dev] External Authentication I currently have Farcry 4.0.3 installed using MS SQLServer 2000. Our client has a MSSQL Server database that contains all of their membership data (name, emails, usernames, passwords, etc.) We need to be able to use our client's database to authenticate members accessing info to the website if it is password protected. I saw the article "Authentication Using an Existing MSSQL Application", but this option requires three specific tables to be created in the external database (dmUser, dmGroup, & dmUserToGroup), we need the ability to use the eisting DB structure. I also saw info about setting up an Active Directory, but it was based on Farcry version 3. Any help in this matter is appreciated. Thanks. --Kevin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
