| Author |
 Topic Search  Topic Options
|
chanzilla 
Newbie
Joined: 20 January 2004
Location: United States
Status: Offline
Points: 2
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Integrating Existing membership database?
Posted: 20 January 2004 at 5:06pm |
|
I'm shopping around for an ASP-based message board for a friend/
client. He already has members registered via an Access2000 db. I
like the format of your forums, but before I start downloading and
tinkering, I need to know if it is feasable to use an existing
membership database with your product. I don't want to start
tearing into his code/db too much. It is a simple database with
username,password, generic profile info, and level of
membership(tier) fields, nothing too fancy.
|
 |
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 January 2004 at 6:07pm |
Yes, it is possibel but it is not simple.
4-5 hours of work merging the database and editing register.asp.
|
|
|
|
chanzilla
Newbie
Joined: 20 January 2004
Location: United States
Status: Offline
Points: 2
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 January 2004 at 6:18pm |
|
Okay, if it's been done (successfully), I'll give it a shot. Any
documentation/notes available?
I'll post my efforts in this thread.
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 January 2004 at 6:39pm |
There's few posts around her by folk who have done it. I believe one of the issues that neede to addressed when merging/integrating is the encrypted passwords.
If you do a search, make sure you select the dropdown for searching message body. It defaults to searching the topic header.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 January 2004 at 6:39pm |
I've done it sucessfully twice with SQL Server. To my knowledge there's no documentation of the process. I use a join on the members table and update the register table to update the parts of the tables that cannot be updated via a join.
If you need any help, send me a PM and I'll do what I can
Edited by ljamal
|
|
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 January 2004 at 6:41pm |
[QUOTE=dpyers] There's few posts around her by folk who have done it. I believe one of the issues that neede to addressed when merging/integrating is the encrypted passwords. QUOTE]
Disabling the encryption is the best way to avoid that.
|
|
|
|
