Using VS2010 I am adding a new data source (SQL Server for this app). The wizard asks if I want to include sensitive information (e.g. the password). In this case I answer "no" ecause I don't want the password showing up in the Config file (the rest of the string is fine).
View 6 Replies
Is it a good idea to store the database pasword in our code like below?If it is not why and which is the correct way to do it? I do not prefer the password to be inserted evrytime the application starts either
conn.ConnectionString = "Data Source=Z:LearningsMyDatabase#1.sdf;Password=abc"
Does anyone know how to store the connection string in a file rather than hard coding it in the application. For example i have declared this connection string in the form to connect to oracle database and it works. But i assume this is not the right way to go by if one is looking for more secured environment.
strcon = "Provider=MSDASQL;" & _
"Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
[code].....
I have a project where I added visually and successfully a datasource of MySql. I binded a datagridview with a table.
But, how do I change programatically the password, ip or user to connect with the MySql server? Because it can change at any time, so I can let the user change these values.
I am writing a program to be able to input a password and take that password and display a new password in a label. the new password will display the results as follows. Any vowels in the old password will be displayed as an x in the new password and numbers will be displayed as x's, and the last part it will display in reverse order so if I enter in timmy1 it should display zxmmxt. I do not know how to write the code to be able to reverse the string to be able to display the password backwards.
Option Explicit On
Option Strict On
Option Infer Off
Public Class frmMain
[code]....
How do I assign a My.Settings.Item connection string to cmd.Connection connection string value?
Dim cmd As New SqlCommand()
cmd.Connection = My.Settings.Item("csStaffHoursWorked")
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "spSaveDeltekImport"
I've been working with VB6, 2003, 2005 and 2010 and I've always hardcoded my database passwords. Recently we ran into a problem where we would like to change all our db passwords for audit purposes. The problem is passwords for different dbs have been hardcoded in all our programs. How can I create programs going forward without hard coding the passwords in? I think I should be using a config file of some sort, but not sure how or where to start.
View 1 RepliesI got this Error Message while I try to preview the records in Dataset Designer:"The connection string could not be found or Data provider associated with the connection string could not be loaded"
Here is my dataset.xsd code
<Connections>
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="loginConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="loginConnectionString1 (MySettings)"
[code]....
How To Editing The "Connection String" in the Configuration file by the Code in the Run time
View 1 RepliesIs there a way to display the connection properties dialog for connection string browsing(for database) in run time?
As I want the user to be able to connect to various database using the GUI.
I understand the possibilities for encrypting a connection string in .net v4. I have a win forms application that will be used by multiple people on different machines. I understand that I need to protect the connection string at time of the app being first run on the target machine. However I am concerned that for a period of time my connection string will be unencrypted. I am looking for advice in how to deploy my app with the connection string already encrypted or encrypted during installation. encrypting the connection string in a secure way?
View 1 RepliesI would really welcome some help with this issue. We have a php code that works and connects to the LDAP. When I try to connect using VB.NET 2010, it fails to bind with logon failure unknown username or bad password. Below is the connection information. When I talk to the folks who run the ldap server, they say I am binding sucessfully, below is the log file for the sucessful bind? If I continue and try to execute a search I don't get any results. The server is running openLDAP ver 2.3.39 on a linux server, server requires connection on port 636 for secure connection, or 389 for anonymous.
[Code]...
I'm developing an app in vb.net (visual studio 2008). I have a Teradata back-end that will be supporting multiple users in a production environment. I need to use variables in the connection string as the user/pass will be changed every 3 months.
For the gist of the application:
In it's most basic form - I have a search form which works correctly - it pulls results into a listbox and the user then double clicks the list box which will then open a form that is bound via table adapter to the back-end table (Teradata). My connection string is fine everywhere in the application. My problem is using a modified connection string for the "fill" function of the table adapter once the form is opened.
I'm using the code below for the on-load event and keep getting an "invalid connection string" - again, the connection string works fine everywhere else in the app, and the variables etc... are working correctly.
Private Sub adaptertest_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DBConnStr As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security
[Code].....
I'm facing a problem after installation any software setup that has a database in access(mdb file) How to I transfer file path in our connection string.
View 3 RepliesI am trying to connect DSN from my VB 2008 project. When i try using myoledb.connectionstring="DSN=myDNSname" I get the following error message An OLEDB provider was not specified in the connectionstring.
View 1 RepliesWhy doesn't an exception get thrown when this function is called when there is no ConnectionString set for the Connection? I just spent 15 minutes debugging and staring at it and finally figured out it needed the connection string. Shouldn't an exception get thrown?
Friend Function GetValues(ByVal TableName As String, ByVal FieldName As String) As DataTable
Dim cn As New SqlConnection
Dim cmd As New SqlCommand[code].....
I created a small database application using Microsoft Access, my problem is i dont know how to create a username and password.
here is the code
Imports System.Data.OleDb
Public Class Form1
Dim MaxRows As Integer
Dim inc As Integer
[code]....
I am currently adding my friend's SQL Server into my Application everything works fine, apart from his password table encrypts so the login form only works when you enter the encypted password in. Is they anyway i can make the password field to de-crypt a password code.
[Code]...
Imports System.IO
Public Class LoginForm1
Dim password_guardada As String
Dim user As String
[code]....
That also doesn't work.And the most odd thing about all this, is that the passwordtextbox is getting is value from pass_desincriptada.
I want to encrypt all users' password that stored in database, but also i need to able to decrypt them.How can i do that?Because i try using MD5 method and only get one way ticket
View 4 RepliesI have the Application program but I need an authentication program and password login program in VB 2008 , before starting my program.[URL]
View 2 RepliesHow can one obtain his/her database password with code while the admin privileges are proved to be sufficient by windows authentication?
View 1 Repliesis there a code for showing my system login/logon password?i am using visual basic express 2008 /Forms.
View 8 RepliesI made a password protected program, but I wanted to make a reset password via security code. I made this, but it will not work for some reason. It seems like it'll work for the first time, but then when you try to set the password, it stills shows that the password is there and when I go into the reset password form and do it again, but then it say its incorrect.
[Code]...
Is there a way to hide the password of your database inside the source code? [code] As you can see the password is exposed, increasing the risk for the database to be compromise. Is there anything you can suggest how can I work around this one?
View 5 RepliesLet's say I have the following string:"/encryption:aes128 /password:<PASSWORDHERE> /log:log.txt"
I need to write this to a log file but the password needs to be masked (replaced with asterisks for example).I can do this easily with String.IndexOf and String.Replace in a few lines of code but I'm interested in seeing how others would implement this so that the code is as short and concise as possible. A one line replace function would be best.
My goal here is to see/learn some new techniques of combining string functions.
Note that I am not interested in using a RegEx.
I have a problem with the code below as a SQL command string. Note: Using .Net Framework 4.0 in Visual Studio 10 Professional. Database is a Microsoft Access file. The idea is that this SQL command string will update a password within my database. Also note that I have tried the string below with and without the ";" at the end and it does not work either way. The problem is most likely extremely obvious, but I can't seem to find it. I have commented below the code what each part of the String is.
"UPDATE Users SET Password='" & tbx1.Text & "' WHERE Username = '" & sUsername & "';"
' Users is my Table name within the Database.
' Password is the field that I want to edit within the Users table.
' tbx1.Text is where the password is stored within a text box.
' Username is the field which I would like to compare with sUsername which is a variable within the code.
Solution was square brackets, Command string now looks like this:
"UPDATE Users SET [Password]='" & tbx1.Text & "' WHERE [Username]= '" & sUsername & "'"
all I want is a function like this:
[URL] but then with the option to provide username & password. I have managed to do this with the webbrowser, first logging in then go to webpage and get source code but this takes much longer than just getting the source code...
Is there any way to do this? I found this:
[URL]
I tried with &username=...&password=... in the URL but it didn't work
with the meaning of this snippet?
string conString =@"Provider=Microsoft.JET.OLEDB.4.0;" + @"data source=c:illing.mdb"; OleDbConnection conn = new OleDbConnection(conString); Conn.Open(); DataSet ds = new DataSet(); OleDbDataAdapter adapter =
[code].....
provide VB.net connection code to connect with sql server for adding,deleting and updating data.I'm new to .Net.I need to learn .VB.Please provide the code for this.Those who know the code please provide here.
View 2 Replies
