An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Solved
CreateParameter with varbinary
Posted on 2008-10-12
I am trying to create queries to store a MD5 encoded password in SQL server field with datatype varbinary(50)
I get the error "Application uses a value of the wrong type for the current operation. "
Below is the code. What's going wrong??
<%
Set cmdSetPassword = Server.CreateObject ("ADODB.Command")
cmdSetPassword.ActiveConne
cmdSetPassword.CommandText
cmdSetPassword.Parameters.
cmdSetPassword.Parameters.
cmdSetPassword.CommandType
cmdSetPassword.CommandTime
cmdSetPassword.Prepared = true
cmdSetPassword.Execute()
%>
I get the error "Application uses a value of the wrong type for the current operation. "
Below is the code. What's going wrong??
<%
Set cmdSetPassword = Server.CreateObject ("ADODB.Command")
cmdSetPassword.ActiveConne
cmdSetPassword.CommandText
cmdSetPassword.Parameters.
cmdSetPassword.Parameters.
cmdSetPassword.CommandType
cmdSetPassword.CommandTime
cmdSetPassword.Prepared = true
cmdSetPassword.Execute()
%>
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
>>store a MD5 encoded password in SQL server field with datatype varbinary(50)<<
Any reason to use varbinary? Why not use varchar?
What is the data type for the value you are assigning to the password?
Any reason to use varbinary? Why not use varchar?
What is the data type for the value you are assigning to the password?
At the moment I believe it is just a binary value resulting from the MD5 function
i.e....
varPassword = MD5(Password)
Should it be declared a specific way?
i.e....
varPassword = MD5(Password)
Should it be declared a specific way?
>>At the moment I believe it is just a binary value resulting from the MD5 function<<
Since there is no data type called "binary" in VB I would suggest you set it to variant when you pass it to a parameter in a stored procedure defined as varbinary. However I would suggest you instead define it as string and change the stored procedure and table to use a varchar data type.
Since there is no data type called "binary" in VB I would suggest you set it to variant when you pass it to a parameter in a stored procedure defined as varbinary. However I would suggest you instead define it as string and change the stored procedure and table to use a varchar data type.
Changing the datatype in the database to varchar and the parameter to the same works well. Is there any big difference or risk to doing it this way?
Thanks for the help.
Thanks for the help.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I have a large data set and a SSIS package. How can I load this file in multi threading?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses
Course of the Month4 days, 23 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.