Connection String Tool For Users Of Your Application?
Jul 9, 2009Is there a way that we can use that Add data source wizard that is in vs to our own apps?
View 2 RepliesIs there a way that we can use that Add data source wizard that is in vs to our own apps?
View 2 RepliesI haven't been doing a programming for awhile now. But, I was a VB programmer before. I will be creating a tool to log issues encountered by the users of our system. It will be a web based. I'm planning to create it in VB.Net. Any resources that you could share is greatly appreciated. I'm looking for a ready program that I could start with to speed up my programming.
View 1 RepliesI am trying to develop a tool to add users to the appropriate AD security group for their department (so that they have the right access to their network folders)I have a list of departments (e.g. A1, A2, A3, B4, Sec, DirGen) and there are 3 AD groups per department. One for Managers, one for secretaries and one for normal users. Each group grants different levels of access on the network folders.
So, I'm trying to decide the best method of presenting this data to the user (and, in turn, storing it in my application).At the moment, I have a Combobox for the department (with a fixed list of items) and a combobox for the user type (e.g. Manager, Secretary, User). Once these comboboxes are selected I populate a CheckedListBox with the relevant AD groups names.
[Code]...
I used to work only with asp.net websites before. I know that in ASP.NET website, the connection string is found in the web.config file. My problem is now I have started working with VB.NET applications which needed to be interfaced to a database. How is a connection string created and where should I put it?
[Code]....
1.I�d like to publish a free vb.net desktop application for the users to download and use meanwhile I�d like to collect usage information ex: user ip address, user�s registration information, used features, time spent� if the user allows the report to be sent back.
2.Also , in order for the user to be able to use the application, he�ll have to register it then, everytime, before the application loads, it gets verified online that it was registered, maybe validate the registration information or a valid user name and password, no critical personal information. The target of this step is for the application to be used exclusively by the registered user and maybe on his computer only.
1. I�d like to publish a free vb.net desktop application for the users to download and use meanwhile I�d like to collect usage information ex: user ip address, user�s registration information, used features, time spent� if the user allows the report to be sent back. 2. Also , in order for the user to be able to use the application, he�ll have to register it then, everytime, before the application loads, it gets verified online that it was registered, maybe validate the registration information or a valid user name and password, no critical personal information. The target of this step is for the application to be used exclusively by the registered user and maybe on his computer only. Any alternative way to achive the target is just fine.
View 1 RepliesHow 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'm trying to give my users the option to move their database to a different location, currently the datasource is set as an (Application Connection String) in the Project Settings, I know that when the scope is set to "Application" it cannot be modified but I'd like to know if there's a way for me to edit the location through code of my database in the application settings without crashing the program, can this be done? The purpose is to give whoever uses my application the freedom to choose where the database should be.
View 3 RepliesI want to create a client-server application, it means I just need 1 database on the server.I have a computer and a laptop. I set my laptop's IP to 192.168.1.1 and my computer's IP to 192.168.1.2.Now I place the database on my computer, the database name is db_transportasi.Problem is, how to connect my computer's database from my laptopSpecification :I'm using this string below for my connection :Data Source=ARVID-THEODORUSSQLEXPRESS;Initial Catalog=DB_TRANSPORTASI;Integrated Security=TrueI already setup my SQL Configuration Manager, enabled the TCP/IP, switch to the IP Addresses tab and set the IPAII Port Properties to 2301I turned off my firewall so I don't have to set any exceptionQuestion
View 4 RepliesI am trying to understand how a connection string obtains its value in a vb.net 2008 application. By stepping through code,I found that a connection string obtained its value from the following line of code:
RemotingConfiguration.Configure("Useall.Desktop.exe.config", false);
By doing a search on the .net application, I found the Useall.Desktop.exe.config file in the bin/debug folder of the application.Thus I am wondering if the connection string information is initally obtained from the Useall.Desktop.exe.config file or would it obtain its inital values from an app.debug.config file?Would you explain the .net remoting and configuration manager interdependency to me? If they are separate items?
I am trying to understand how a connection string obtains its value in a VB.net 2008 application. By stepping through code,I found that a connection string obtained its value from the following line of code:
RemotingConfiguration.Configure("Useall.Desktop.exe.config", false)
By doing a search on the .net application, I found the Useall.Desktop.exe.config file in the bin/debug folder of the application. Thus I am wondering if the connection string information is initally obtained from the Useall.Desktop.exe.config file or would it obtain its inital values from an app.debug.config file?
I have a VB.NET application that used LINQ To SQL. Right now, I am using a single server and it is working properly. My problem right now is that my application will be used in another branch and with another server. I have to make the application able to change the connection string according to their server IP
View 1 RepliesI have set the connection string of my dataset(typed) asData Source=MyHomeServerSQLEXPRESS;Initial Catalog=dbTestSharing;Integrated Security=TrueThis is going to be a client side application. I need to change the machinename in the connection string so it could connect with server.
View 1 RepliesI'm using vs2010 and can't get this to work. The same code has worked in earlier versions. What has changed?
config file:
<appSettings>
<add key="ConnectionString" value="Data Source=MikeLaptop;Initial Catalog=AdventureWorksDW2008R2;Integrated Security=True"/>
</appSettings>
Code:
Dim strProvider As String = ConfigurationManager.AppSettings("ConnectionString")
strProvider is always = nothing
How to do this now?
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 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]....
You can change the connection string at run-time like this. You make the connection string setting available for writing as a separate property inside the MySettings class:
Partial Friend NotInheritable Class MySettings
Public WriteOnly Property RunTimeConnectionString()
Set(ByVal value)
[code]....
Then, in some place when the application is being initialized (before using any table adapters of typed datasets), write something like:
My.Settings.RunTimeConnectionString = My.Settings.ProductionConnectionString
Where ProductionConnectionString is a simple String setting. It is a User Scope setting so every user can change it (by assigning a value to it, similar to the code above) and save it by calling My.Settings.Save()This code works well for connection strings which were initially created in the main project and stored in it's settings (= app.config file).
The connection string in the app.config actually has a longer name: MyApp.MySettings.MyConnectionString.When you have a connection string stored in the app.config in a class library project, and reference that project in the main project, the app.config files will somehow be merged, so the class library has it's settings.The thing that don't know how to do, is change a setting from the class library at run-time. I could copy the connection string setting from the class library to the main project's app.config. I must keep the same name, which looks something like: MyClassLibrary.My.MySettings.MyConnectionString.Can the same principle I showed above be somehow applied to this second connection string?
Ok I have a question about connection string in vb.net. Im using the string [Code] but here I am specifying the serverName by its name, now if I deploy my application and send it to another person to use it I see that server name is changing according to the name of the computer. Is there any way where by I can make my application to detect itself the Name of the server present in that computer and use it in connection string?
View 2 RepliesI have a little problem with application setting in VB.net 2008. I want to switch main server and backup server connection string with combobox. [Code] It did change the Application Setting connection string in the main form when combobox1 was changed. But the problem comes, when child form was called. On the child form there is DataGridView with Dataset using application connection string. Even the Backupserver was selected on the main form, child form dataset connection string doesn't change. I don't know how to pass the current connection string to child form dataset although it is set to use application setting.
View 6 RepliesI'm creating window application with VB.NET and flatfiles.the problem is how do i store the connection string in the app.config file that include the application.startup path?
<add name="cn" connectionString="provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "data;Extended Properties=text;" />
i got some error when writing to app.config.
"Missing attribute value on attribute 'Application.StartupPath'."
i m a vb.6.0 developer and now turned in vb.net. so i m new in vb.net.My problem is given below.i opened the word documents in webbrowser control and it is just showing a document page with rular. But my main problem is that i want to open whole word documents with tool &menu bar in webcontrol. i used the following code which is given below.
WebBrowser1.Navigate("C:dharmchandBlank.doc")i wrote this code in form_load events and when i run my application then it is showing just a page with rular. But not showing Menu bar & Standard or Formatting toolbar.
Is 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'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've searched high and low and cannot seem to find how to implement an application tool bar in VB.Net. I want to basically create a scrolling text banner, which docks itself on the top of the screen on which scrolls along a message. Pretty simple in VB6 but can find a VB.net alternative.
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 Repliesi am wondering if there are any case studies / white papers available comparing web applications to remote desktop applications on running on comparable hardware? What I am trying to get at is if a web application can support more users, as far as hardware resources go, than the same windows based application running on terminal services?
View 3 RepliesWe would like to know if there are any recommended tools in .NET that can scan through a VB .NET project & do an analysis.It should report on the Lines Of Code, provide no. of Routines, No. of 3rd party Tools, No. of Variables, Forms Diagrams, No. of Classes etc.
View 1 RepliesI'm trying to build a search tool for my application... I have a form with a bunch of criteria which the user may or may not fill in. The tool is looking up against one table in the database (OLEDB) so I wanted to pull in all the data from the table into a dataset (when the form loads) and perform the search on it. I'm not sure how to search through datasets... this is the code I have now:
Public Class TxnLookup
Dim daLookup As OleDbDataAdapter
Dim dsLookup As DataSet
Dim cbLookup As OleDbCommandBuilder
[code]....
but I get an error on the foundrows = line ("Value of type 1-dimensional array of system.data.datarow cannot be converted to system.data.datarow").... is there a better way for me to search the dataset?