Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Write registration data to additional databaseWrite registration data to additional database
Previous
 
Next
New Post
12/6/2006 3:30 PM
 
Yikes! I didn't know it would be that involved! I'm just a loley Network guy with very little programming experience.

OK...there has to be a simpler solution. Brainstorm with me on this. I just want to take a username and password field and pass it to a stored procedure that I created in the DotNetNuke database. This new sp formats the password the values into another database that runs my email server (hMail). Can't we think of a way to do this? I was able to insert an exec command in a stored procedure, but the password had already been encrypted at that point and did me no good. So what do you think?
 
New Post
12/7/2006 9:48 AM
 

OK, a diffeent approach: Is there a way to retrive a user's password using vbscript? Since I can't figure out how to correctly capture the username and password at the time of registration and pass it to a custom stored procedure, I am left with scheduling a task to execute a vbscript that will retrieve the usernames, userids, and passwords for all users and cross reference that with another db and update changes as necessary. Now, before anyone tells me that the psaswords are encrypted and can't be retireved, I found a little script that will do it. (I can't figure out how to post the code here, so if you want to see this script, I'll email it to you.)

So, any help would be greatly appreciated!!

 
New Post
12/7/2006 10:48 AM
 

Hey echo...trying your code above again, I'm still not convinced I have the right connection string.  Below is my connection strings from my web.config; what would you make the connection string in that code snippet you posted?

  <connectionStrings>
    <!-- Connection String for SQL Server 2005 Express -->
 <add name="SiteSqlServer" connectionString="Data Source=robinson-c8b57r\SQLExpress;Integrated Security=True;Initial Catalog=DotNetNuke" providerName="System.Data.SqlClient" />
  </connectionStrings>

  <appSettings>
    <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules   -->
 <add key="SiteSqlServer" value="Data Source=robinson-c8b57r\SQLExpress;Integrated Security=True;Initial Catalog=DotNetNuke" />

 
New Post
12/7/2006 11:46 AM
 

I beleive this would access the current connection string in the web config file. Since it's in the same database, it should work.

Dim sConnStr As String =  ConfigurationManager.ConnectionStrings("data").ConnectionString

 
New Post
12/7/2006 11:57 AM
 

Nope...tried that, didn't work.  Of course, not sure if it is the code, or what since I can't really "see" what is going on.

Here's what I got:

   Dim sConnStr As String =  ConfigurationManager.ConnectionStrings("data").ConnectionString
   Dim cnBKTest As New SqlConnection(sConnStr)
   Dim cmdTest As New SqlCommand("DotNetNuke.dbo.aspnet_Membership_CreateUser_Email", cnBKTest)

   cmdTest.CommandType = Data.CommandType.StoredProcedure

   'Create Parameters
   cmdTest.Parameters.Add(New SqlParameter("@UserName", Data.SqlDbType.VarChar, 10))
   cmdTest.Parameters("@UserName").Value = userControl.UserName
   cmdTest.Parameters.Add(New SqlParameter("@Password", Data.SqlDbType.VarChar, 10))
   cmdTest.Parameters("@Password").Value = userControl.Password

   cnBKTest.Open()
   cmdTest.ExecuteNonQuery()
   cnBKTest.Close()

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Write registration data to additional databaseWrite registration data to additional database


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out