I am storing encrypted password in registry and using it then to log on my
application. However, my objConn.Open(st r_connecton_str ing) crashes the
application if I use the encrypted password.
My connection string works fine with an unencrypted password and looks like:
str_connection_ string = "data source=XXXX;ini tial catalog=dbname; user
ID=username;pas sword=encrypted password;connec tion timeout = 5"
Any help will be appreciated.
--
Dino Buljubasic
Software Developer http://rivusglobal.com 7 5179
Hi Dino,
I hope you are decrypting the password before sending it to the database.
Cheers
Benny
Dino M. Buljubasic wrote: I am storing encrypted password in registry and using it then to log on my application. However, my objConn.Open(st r_connecton_str ing) crashes the application if I use the encrypted password.
My connection string works fine with an unencrypted password and looks like:
str_connection_ string = "data source=XXXX;ini tial catalog=dbname; user ID=username;pas sword=encrypted password;connec tion timeout = 5"
Any help will be appreciated.
Hello,
"Dino M. Buljubasic" <di************ *@rivusglobal.c om> schrieb: I am storing encrypted password in registry and using it then to log on my application. However, my objConn. Open(str_connec ton_string) crashes the application if I use the encrypted password.
Decrypt the password before passing it to the 'Open' method.
Regards,
Herfried K. Wagner
--
MVP · VB Classic, VB.NET http://www.mvps.org/dotnet
Hi Herfried,
I will check if there is a way to decript it. I am using MD5 and as I know
it is one way encryption, did not know I can decrypt it, too.
However, I am not decripting the passwords when I get them from database and
everything works just fine. The problem is when I get the encrypted
password from the registry only.
Regards,
--
Dino Buljubasic
Software Developer http://rivusglobal.com
"Herfried K. Wagner [MVP]" <hi*******@m.ac tivevb.de> wrote in message
news:uY******** ******@tk2msftn gp13.phx.gbl... Hello,
"Dino M. Buljubasic" <di************ *@rivusglobal.c om> schrieb: I am storing encrypted password in registry and using it then to log on my application. However, my objConn. Open(str_connec ton_string) crashes the application if I use the encrypted password.
Decrypt the password before passing it to the 'Open' method.
Regards, Herfried K. Wagner -- MVP · VB Classic, VB.NET http://www.mvps.org/dotnet
You cannot decrypt MD5 hashes. When you use MD5, you produce a hash, which
is irreversible.
--
HTH,
-- Tom Spink, Über Geek
Please respond to the newsgroup,
so all can benefit
"Maybe it's a game called 'Punish the User'"
"Dino M. Buljubasic" <di************ *@rivusglobal.c om> wrote in message
news:Zl******** ***********@new s1.telusplanet. net... Hi Herfried,
I will check if there is a way to decript it. I am using MD5 and as I know it is one way encryption, did not know I can decrypt it, too.
However, I am not decripting the passwords when I get them from database
and everything works just fine. The problem is when I get the encrypted password from the registry only.
Regards,
-- Dino Buljubasic Software Developer http://rivusglobal.com
"Herfried K. Wagner [MVP]" <hi*******@m.ac tivevb.de> wrote in message news:uY******** ******@tk2msftn gp13.phx.gbl... Hello,
"Dino M. Buljubasic" <di************ *@rivusglobal.c om> schrieb: I am storing encrypted password in registry and using it then to log on my application. However, my objConn. Open(str_connec ton_string) crashes the application if I use the encrypted password.
Decrypt the password before passing it to the 'Open' method.
Regards, Herfried K. Wagner -- MVP · VB Classic, VB.NET http://www.mvps.org/dotnet
Hello,
"Dino M. Buljubasic" <di************ *@rivusglobal.c om> schrieb: Yes, I found it out, too.
A hast can not be decrypted. So, any idea how to solve the problem?
I don't really understand what's your problem. You cannot use the encrypted
password, you need the original password.
Regards,
Herfried K. Wagner
--
MVP · VB Classic, VB.NET http://www.mvps.org/dotnet
The problem is following:
- to connect to my application I use a registry password.
- once connected, users do various things and their passwords are stored in
a datatable on an SQL Server.
If hashed, the passwords stored on SQL Server data table work just fine.
If hashed, the password stored in registry when sent to open method via
connection string property throws error 18456
I found what the problem is but have not found the solution to it. The
problem is that a user gets assigned a password when he/she is to be granted
permission to log on SQL server. That password has to match the password
stored in the registry on the machine where my application is running.
However, since I hash that password, it wont match the password I assigned
to that user on SQL Server inside LogIns Manager. One solution (possible)
would be to simply copy the hashed password ASCII string and paste it to the
user's password field on the SQL Server, but I think that is "ein ziemlich
schlampich Weg" to go for it.
Let me know if you have any idea, please. If not, I am just gonna leave it
as it is.
Thank you for the help,
--
Dino Buljubasic
Software Developer http://rivusglobal.com
"Herfried K. Wagner [MVP]" <hi*******@m.ac tivevb.de> wrote in message
news:e6******** ******@TK2MSFTN GP12.phx.gbl... Hello,
"Dino M. Buljubasic" <di************ *@rivusglobal.c om> schrieb: Yes, I found it out, too.
A hast can not be decrypted. So, any idea how to solve the problem? I don't really understand what's your problem. You cannot use the
encrypted password, you need the original password.
Regards, Herfried K. Wagner -- MVP · VB Classic, VB.NET http://www.mvps.org/dotnet
Well hashes are actually useful in the fact that no two hashes are the same,
if the input data is different. Which means, you hash the user's password,
then when he/she goes to type in the password, you hash the password that
was entered. If the hashes match, then the passwords match.
--
HTH,
-- Tom Spink, Über Geek
Please respond to the newsgroup,
so all can benefit
"Maybe it's a game called 'Punish the User'"
"Dino M. Buljubasic" <di************ *@rivusglobal.c om> wrote in message
news:9v******** ***********@new s1.telusplanet. net... The problem is following:
- to connect to my application I use a registry password. - once connected, users do various things and their passwords are stored
in a datatable on an SQL Server.
If hashed, the passwords stored on SQL Server data table work just fine. If hashed, the password stored in registry when sent to open method via connection string property throws error 18456
I found what the problem is but have not found the solution to it. The problem is that a user gets assigned a password when he/she is to be
granted permission to log on SQL server. That password has to match the password stored in the registry on the machine where my application is running.
However, since I hash that password, it wont match the password I assigned to that user on SQL Server inside LogIns Manager. One solution (possible) would be to simply copy the hashed password ASCII string and paste it to
the user's password field on the SQL Server, but I think that is "ein ziemlich schlampich Weg" to go for it.
Let me know if you have any idea, please. If not, I am just gonna leave
it as it is.
Thank you for the help,
-- Dino Buljubasic Software Developer http://rivusglobal.com
"Herfried K. Wagner [MVP]" <hi*******@m.ac tivevb.de> wrote in message news:e6******** ******@TK2MSFTN GP12.phx.gbl... Hello,
"Dino M. Buljubasic" <di************ *@rivusglobal.c om> schrieb: Yes, I found it out, too.
A hast can not be decrypted. So, any idea how to solve the problem?
I don't really understand what's your problem. You cannot use the encrypted password, you need the original password.
Regards, Herfried K. Wagner -- MVP · VB Classic, VB.NET http://www.mvps.org/dotnet
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Victor |
last post by:
In my mysql database, I've stored all the passwords using the PASSWORD()
function. Now I'm running a test and need to compare the password in my php
document to that saved in the database. I used the string
"Select name From users Where password = PASSWORD('$testPass')"
and ran mysql_query() using the string. But nothing was returned. ...
|
by: Jill Elaine |
last post by:
I am building an Access 2002 frontend with linked tables to an
encrypted Paradox 7 database. When I first create these linked tables,
I'm asked for the password to the encrypted Paradox database, and the
linked tables are successfully created. I use the data from these
linked tables in several forms.
All works great until I close the Access...
|
by: Fabrizio |
last post by:
(Sorry for the crosspost, but I really don't know which is the right
newsgroup!)
Hi all,
I try to change the password to a user that as to change the password at
first logon:
try
{
|
by: Andre Ranieri |
last post by:
I'm trying to create a login page for customers to log into our corporate
website, our presidents naturally wants the user and password fields to
populate from a cookie so the customer doesn't have to type their credentials
every time, this seems like a pretty common thing. However, when I try to
populate the password HTML textbox from the...
|
by: scorpion53061 |
last post by:
is it possible to set the database password that you can set in access for a
database from a vb.net application?
| |
by: David Garamond |
last post by:
I read that the password hash in pg_shadow is salted with username. Is
this still the case? If so, since probably 99% of all PostgreSQL has
"postgres" as the superuser name, wouldn't it be better to use standard
Unix/Apache MD5 hash instead?
--
dave
---------------------------(end of broadcast)---------------------------
|
by: Katash |
last post by:
Hello,
I am new to PHP and am working on a login system for my site,
currently supplied passwords are passed to MySQL and stored as md5 hashes,
my question is :- seeing as md5 is 1 way only what would be the best way to
implement a 'Forgotten Password' system whereby the user supplies an e-mail
address and the password is mailed to the user?...
|
by: julianmoors |
last post by:
Hey,
Currently I'm writing a VB.NET/1.1 app and I need to mask the input for
the password field. Does anyone know how to do this in VB? I've seen a
C# example, but wouldn't know how to convert it myself. Here's the URL:
http://www.codeproject.com/dotnet/ConsolePasswordInput.asp
|
by: DarthPeePee |
last post by:
Hello everyone.
I am working on a Password Strength Meter and I am running into 1 problem that I would like to fix.
When pressing the "Clear Password & Try Again" button, the password clears out of the text box, but the meter will stay at its current position until text is entered back into the textbox. Once text is re-entered, the meter...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |