Demonstrate How DbConnectionStringBuilder Works With Connection Strings?
Jul 1, 2010
from [url] they write this:
This example includes a password to demonstrate how DbConnectionStringBuilder works with connection strings. In your applications, we recommend that you use Windows Authentication. If you must use a password, do not include a hard-coded password in your application.but if we do not hard-code the password then does it mean that we are supposed to retrieve the password from some other place? so is it correct to say that we should save the password in a file and then retrieve it when the app runs?
I've created a small DLL, an addin for Autodesk Inventor, this addin saves some information provided by the user and the program to an access(mdb)database.The whole idea behind this is that it allows users to quickly find drawings, assemblies and so on.The DLL works great on x86 systems however it has issues on x64 because I used ado.net.In a attempt to solve it I forced .net to compile it with the target x86 CPU settings.
However using this I'm unable register the dll (C:WINDOWSMicrosoft.NETFramework64v2.0.50727RegAsm.exe /codebase SavetoDatabase.dll )It says its not a proper .net dll file and therefore cannot be registered.
is there any other access-database connection provider (like dao or ado.net) that works on a 64 bit machine? Or do I need to change from mdb databases to another type (like mysql)? because sooner or later all machines its running on will be converted to x64.Or do I need to register the dll in another way?I've also tried to replace the conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0 with ACE, with no luck however
I have several programs I have written for my music studio/production company. Many dealing with inventory, customer DB etc. All of my programs are in VB6 and I have started to convert them all to VB.NET. I am getting proficient with VB.NET and connecting to DB using the very simple and generic connection strings, Example:
What is a dynamic MS Office Connection string? I have realized that each each version of MS Access has a unique Connection String. Now my concern is that if I use MS Access 2007, for example, it may haave compatibility/connection problems if an application is deployed in a machine with a different edition of MS Access. Is my understanding correct? If so, how to go around this hiccup?
I'm creating a program in VB.Net that heavily interacts with 2 large MSSQL databases. I do not know a ton of vb and I'm fairly new, but I would assume just having the connection strings in the code and releasing the program it would be quite easy for someone to reverse the program and get my connection info? correct me if I'm wrong. My question is I'm wondering if there is a safer way to use a connection string in my program. Would I just have to encrypt my app? Create a module or dll?
I have read and worked through all of the examples in the book "ADO.NET 2.O", but there is so much there with so many ways to handle data, I am having difficulty translating the examples into my own real life application. I am confused about creating runtime connection strings, connection strings in my app.config file, connection strings in the properties for a sql connection control, etc.
I have a midichildform with a datagridview control, and I use a table adapter to edit and update the SQL Server 2005 Express edition database. There is no problem there. However, I also have a button control that I want to use to "process" the data that has been updated with the table adapter. I want to open the updated table, read each record on at a time, manipulate the data and add a records to another table. Do I have to create a connection string and an oleDBconnection? Or can I somehow use the connection string that is in my app.config file? [Code]
I need a bit of advice. I would like to store secure connection strings somewhere safe in vb.net. How can I build the secure connection strings in what situation and what would be the best?
As I have done the little research and found that the secure connection strings would be encrypted the strings and input the strings in app.config, so I would have to make a change in the app.config[code]...
I have been struggling with the construction of an Access connection string. Here's the problem.My Visual Basic 2008 project is located in a disk partition on my hard drive that I have named S:. My Access MDB file is in the same location.When I deploy the application it obviously will not be in an S: drive on the user's machine. My concern is that if I construct the Connection String using the file designations on my computer as:
(Provider =Microsoft.Jet.OLEDB.4.0; Data Source =S:MyApplicationmydatabase.mdb; User Id =admin; Password =
The deployed application won't know where to look for the data file. I know there are some shortcuts that will allow me to construct the connection string, but I do not know either the designated names or where to find them.
I have two executables that access a DLL containing Data Access Layer objects Each exe can have a different config containing info on server and database name, connection string etc.How do I pass the config info to the DAL objects?
Obviously I can pass the config strings to the DAL objects every time I instanciate one, but that seems messy and repetitive as every class in the DAL will require Properties for the Config strings..if there is a way for the instanciated DAL objects to read some properties from the calling object without me having to pass them explicitly?
We decided to use the registry for handling our deployment with connection strings in our VB.net application.
The requirements are:
If the program cannot connect to the server, first check the registry for a connection string. IF not, create the folder and fill in the name, type, and data. Make sure its encrypted.
I have never edited or created anything in the registry.
I've just started ASP.NET for real, and I was wondering if it is possible to use connection strings from Data Sources instead of hard-coding them. I've added my connection in Data Sources and it works, and I can also drag a table to a page in design mode, but I can't figure out how to access it in code. Here's what I get when I drag it in:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">[code].....
In the past I've used a Singleton Pattern to load the connection string when the application starts via the global.asa file.
I have a project now where each user has a unique connection string to the database. I would like to load this connection string once. The issue is that the singleton pattern will not work for me since each user has there own connection string. Basically the connection string is created dynamically.
I do not want to store it is session. If anyway has a clever way of doing this in .NET let me know ?
I'm having trouble accessing the connection string from the app.config file. my connection string is: Dim sConnect As String = "Data Source=.SQLEXPRESS;AttachDbFilename=G:VB Level 1ProjectContactsDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
I using this string in a few different places, but I want to access it from the App.Config file. I've been at it for awhile and can't get it working.
I am using VB 2008 & MS Access 2007 Databases for my Windows Forms Applications.The Problem is my Connection strings have been disappeared from DataSource Configuration Wizards & now i am unable to edit any Connection String in DataSet Designer.I had tried to create a Macro in MS Access Data File but didn't know how to create & so desided not to save any & just quit from Access and came back to Visual studio. Since then only this prob. has started. Earlier to this everything was just fine.I have tried to uninstall MS Office as well as Visual Studio then Re-installed Visual Studio but the problem is still there.
1] Error while trying to Reconfigure Data Adapter in Dataset
I have a situation where I have a vb.net program that uses two connection strings. This program will be used on multiple web servers on multiple domains and the only difference for any of them is the two connection strings.What would be the best solution to read in these connection strings from a file separate from my actual .vb code?
Ideally I want to be able to drop the .vb and the connection string file into its own folder on any number of asp.net websites and not update anything else (for example add any connections to the web.config or anything) than the external file containing the connection strings, I assume something like xml would suffice?
I would like to store secure connection strings somewhere safe in vb.net. How can I build the secure connection strings in what situation and what would be the best??
As I have done the little research and found that the secure connection strings would be encrypted the strings and input the strings in app.config, so I would have to make a change in the app.config
The code have been built to a guy who known as Nick J. Fessel. I am not too sure if it very secure to use it so. Do anyone know that if the connection strings is secure or not?
info for the secure connection strings without being found out
The fact is I'm making an application, which users can install by using a Setup file...once installed the data in the database can be updated by a centralized server. To do this, they can insert a DVD/CD-ROM and export the necessary data towards it. I need to do it that way, because some of the users who really need this data will be using stand alone computers.The application gets it's data from a mdb-file and the connection remains open as long a person works with the application (maybe not the best way to do, but I know :-) )...when the user uses the application, he can perform an export...this exports the .ini-file and pictures (which works fine), but he also needs to export the mdb behind the application...I already tried connection.close() before and connection.open() after the System.IO.File.Copy...but that doesn't seems to work.
I have finished my program and now i am ready to deploy it. The only problem is it is a multi-user application. All i want to do is simply run the program with the database from a server, and have other local computers with the program access this same database. I know that you have to change the connection strings for the local computers, but how can i go along doing this?
I have upgraded my VB app from VB to VB.NET and its working fine. Now, I want to convert my existing DB connection strings from ADODB to ADO.NET so that I dont have to use MS Access on every client which runs this app. Currently the VB app looks up into an Access db to get the server ip, username, password etc. I aim to hardcode these values so that I wouldn't need the Access db anymore. Any inputs on how this could be done?
[i][b]I have always developed apps for desktops with an access database on one server for one company or sql server. I had one connection string. Now I am in a situation with multiple clients using my software on their own server. This means different connection strings can anyone suggest an efficient way to do this without changing connection strings for each server throughout the application?[/b][/i]
Say I have a List(Of Tag) with Tag being an object. One member of Tag, Tag.Description, is a string, and I want to make a comma-separated concatenation of the Description members.Is there an easier way to do this than to read the Description members into a List(Of String) and then use the Join function?
Our app allows admins to connect to a different database, which means we need to temporarily decrypt the app.config's connection strings, re-write them, then re-encrypt it. Here's my current 'simplified' code showing how we do all 3 tasks:
Dim config As Configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None) Dim section As ConfigurationSection = config.GetSection("connectionStrings")
'insert link sheet1.Hyperlinks.Add(sheet1.Range("P1"), "http://http://www.vbforums.com", "") the code of the button (ribbon)
[CODE]...
When I press the button, it connects to the web site. when the sheet1 is selected, it works, but when the sheet2 is selected, not works, why? the path is sheet1,What's wrong?
I am working on a UDP Client/Server, and currently i have them sending back and forth strings, which i convert to bytes, and then open the bytes to read. I want to now send an Object instead of those strings, which includes multiple unsigned integers and strings.
I have a list of strings. For each string in that list, I want to prepend another string. I wrote a method to do it, but I was wondering if there was something already in .NET I could use to do this. It seems like something that could be built in, but I was not able to find anything.
Here is the method I wrote:
Private Function PrependToAllInList(ByRef inputList As List(Of String), ByRef prependString As String) As List(Of String) Dim returnList As List(Of String) = New List(Of String) For Each inputString As String In inputList returnList.Add(String.Format("{0}{1}", prependString, inputString))
[code].....
It works, but I would rather use built in functions whenever possible.
I have been looking for examples to find the string between two strings. This top one works fine;
Public Sub ReadData(ByRef keywordStart As String, ByRef keywordEnd As String, ByVal filename As String) Using reader = New StreamReader(filename)
[Code].....
Now the first one is fine - Ext_Volume is result of the string between the strings <Volume> and </Volume>. <Volume> and </Volume> are unique so this is straight forward.
However the second one - "^FDExp:" is unique, but "^FS" is not unique. There are occurances of "^FS" before and after "^FDExp:".
How do I get the string to search AFTER the occurrence, not before etc?
