BV Commerce Forum
»
BV Commerce Support
»
How Do I? Questions
»
What stored procedure creates the bvin and salt?
Rank: Member
Joined: 1/23/2009(UTC)
Posts: 71
|
Hello,
I am attempting to create a new customer in BVC5 with data entered by a new user in another application. In this other application, I am creating a query (initially) calling on a BVC5 stored procedure to create a new customer record. I can't seem to find the stored procedure (and I'm assuming it's a stored procedure) from within BVC5 that creates a new customer record (starting with the bvin (in a sequence of lower case numbers and letters of 8-4-4-4-12) and later Salt with the same sequence) .
Any help with identifying this stored procedure would be greatly appreciated.
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
You won't be able to create the user directly in the database unless the password is unencrypted. You should use the builtin core code or web services to create a user with an encrypted password. The salt value is a GUID value created by the System.Guid class in the .net framework.
|
|
|
|
|
|
Rank: Member
Joined: 1/23/2009(UTC)
Posts: 71
|
Marcus,
Thank you for the quick reply. I am running a web application that creates a new user and an 8-character password. What I'm trying to do is take this newly created user (username and password) and pass this to BVC5 via a stored procedure. I thought I could create a stored procedure that passes these variables to the bvc_User table but I'm having trouble creating the bvin and Salt numbers.
Any help here would be greatly appreciated.
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
The BVIN and salt values are GUID (Global Unique Identifiers). You have to generate these from SQL or .NET code. They are special numbers that are (almost) guaranteed to be unique.
|
|
|
|
|
|
Rank: Member
Joined: 1/23/2009(UTC)
Posts: 71
|
Marcus,
Thank you. I'm using a T-SQL command called "NewID()" to generate a new GUID that I'll use for bvin and Salt.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.