473,657 Members | 2,409 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Where is the location of System DSN Password?

233 New Member
I am having an issue with a system running Windows XP Pro. I have created a System DSN, tested the connection successfully, yet the application that uses the System DSN errors out stating that the username exists, but the password is incorrect. I can view the System DSN information in the registry, HKLM\Software\O DBC\ODBC.INI\<D SN name>, but I am uncertain where the password is stored. Even if I knew the whereabouts of the password, I would not think it would be in plain text. The user of the system has domain and local admin privileges, and the configuration of the System DSN is typically straightforward as I have never had an issue like this. Any help on this issue would be appreciated.

**edit**
I think I found the answer I was looking for in another thread. When using SQL authentication, the password for the System DSN is not stored. The password needs to be included in the connection string for the application.
Feb 2 '11 #1
1 23350
Chr Boc
1 New Member
Hello,

Yes, include the PASSWORD in your connection string :)

If you're wondering why, it's because the PASSWORD is hashed. Then, SQL authentication compares the hash (passed over a network). If they are a match, you connect :) In this way, the password is kept safe. i.e., it is not clear text.

P.S. There are also ways to keep the password safe inside your code or application configuration file. You could use a SecureString, or the more complicated (albeit safer) encryption in a configuration file. Here is a link to get you started: the language is C#: http://www.codeproject.com/KB/securi...igWinApps.aspx
Feb 3 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
1767
by: ruflicks | last post by:
Hi all, i may be flamed but did not find anything on that. I have zope 2.7 running on windows 98 and I really like it. Problem is when i use the zope help system I am asked to give a login and password to get access to some sections (python scripts API reference and zope API reference). I tried my standard admin login but hey it didn't work with that one. I am a python and zope nubee so i was thinking it could help me reading that doc. I...
21
3031
by: puzzlecracker | last post by:
Guys - Is it possible to find which way system stack grows? Perhaps, I am not precise enough: When a function is called, the return address of (callee) function is put on the stack. Thus, the question is the direction where that stack heading (address increasing or decreasing). How would you implement this in cpp? any suggestion.
3
17941
by: pontifikas | last post by:
I'm pretty damn sure there should be a System.Math library somewhere around .Net. But I cannot find it. What is the name of the reference for it? Any Ideas? What could I be doing wrong? *-----------------------* Posted at:
0
864
by: Saso Zagoranski | last post by:
Hi group! I've spent the last few days trying to make a simple WS-Transaction (using ..net 2.0). After using google for a few hours I saw the solution: the System.Transactions.WsTx namespace,with a few classes, with which you can (hopefully easily) make a WebService Transaction (the kind from the WS-Transaction specification).
3
17608
by: groovyjman21 | last post by:
Hi, I am using FXCop on my c# project and it is complaining about signing the assembly with a strong name key. All the documentation I can find says to do: using System.Reflection; .... namespace Foo Which is fine, except that I need to add a reference in my Project to the System.Reflection.dll assembly and I can't find it. I have .NET
3
16154
by: Marco Shaw | last post by:
I've got some C# code to create a custom PowerShell cmdlet with these statements: .... using System.Collections; using System.Collections.Generic; using System.Collections.ObjectModel; .... My compile fails using csc.exe:
4
4855
by: bobby | last post by:
Hello group, I just wanted to know where are system standard include and libraries directories in Ubuntu? I searched in usr/include and usr/local/include and I could not find any header?!! I appreciate it if you send me the list of the directories the gcc looks for the header files and libraries for compilation in Linux Ubuntu. Also what does it means if we insert sys before a header file like
4
10219
by: hon123456 | last post by:
Dear all, I try to type using system.linq in Visual studio 2005. But it complains that no namespace of System.ling is found. Maybe I need to add reference to System.linq. How can I add System.Linq Namespace in Visual Studio 2005 Csharp. Thanks.
8
2693
by: DevInCode | last post by:
I'm working on a site that has been left to die for a few years. There is a login to access a certain part of the site. I can't figure out where this password is stored. When the private html page is accessed the box pops up asking for credentials. It says 'A username and password are being requested by http://www..com. The site says: "Restricted Area"' If incorrect credentials are supplied it gives a 401 error. Suggestions? If it...
8
18772
by: kini113 | last post by:
I want to update my database every night at 10pm. I have a Macro that runs all of the queries needed to update the database (which is also saved as a VBA module) and an AutoExec Macro to runs the "Update Inventory" macro. I also scheduled the task to run every night a 10pm. The problem i have is that in order to run the "Update Inventory" macro I have to enter my ODBC password and there is no way to save the password. This there a Macro...
0
8310
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8826
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8605
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7330
agi2029
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6166
isladogs
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5632
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4155
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1615
bsmnconsultancy
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.