Hi Sheldon, I'm the one that posted a message about using SQL Server 2000. I had some success but had also some quirky problems with v7 involving the odbcuser.dll. I suspect I didn't have the right version of the dll. After reading the responses to my post though, I decided to scrap the database and use the internal registry method.
For me, I liked that you could look up a users password in the table. Not that I snooped but I found it helpful when supporting users who forgot their password. Other than being able to look up passwords, I can't find a compelling reason to use SQL Server. My better sense also tells me that it's not good to have passwords in plain text. -Gary --------------------------------------------------------- Gary Jorgenson, RN President, Robin Technologies, Inc. 12 Westerville Square, Suite 159 Westerville, OH 43081 Phone: 614.895.2020 Fax: 614.899.1580 Dublin Office: 614.652.3142 email: [EMAIL PROTECTED] web: http://www.robintek.com --------------------------------------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sanford Whiteman Sent: Tuesday, October 02, 2001 12:58 AM To: Sheldon Koehler Subject: Re: [IMail Forum] MS-SAM vs SQL database Sheldon, I can't imagine why you would use the SAM, a.k.a. NT Domain, method if you don't have an NT domain. The Registry method is faster and much more scalable. Theoretically, the SQL userbase has the highest user count limit, but you'd only need its capacity as you approach 100,000 accounts, it's slower than the Registry in my experience, and it generally requires a separate machine (but also lets you share/query the userbase with/from other apps). That's my take, Sandy Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
