in my Few small projects i have been using this code for connection to database in every forms.
Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|YTCARGO1.mdb;Persist Security Info=True")
i would like to ask where is the best place to save a mysql connection string.i want to be able to change the connection string(host,username,password) during runtime so if the server changes IP address i can change it.
View 10 Replies1.is it possible to save the database connection string to the textfile so that user would be able to know where the database is stored?
2. Any way to let the user decide where the database is stored? Since usually we, the programmer write the database connection string ourselves..
I would like to enable my app to run from a central database, but I dont want to recompile should the DB server change. Are my only two options saving the connection string to an XML file or the registry?
If so I think the XML file will probably be the way I go at least for me. I dont really want to mess with the registry. I just wanted to check what my options are.
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 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]....
Currently I am saving data from my applications by saving a text file via a stream reader as a string. I have come to a problem. In my current application, I have an array of the following structure:
[Code]...
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 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 have a small application shared by 5 users. The application uses an Access 2007 database located on a local network server. My question is: Whenever a user logs into I save it's connection status on a table. When using OleDb is there a way of getting something like a unique "session id" for the user logging in?
View 2 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].....
in a winform how do i get one of those fancy windows "save file as" dialogues to appear so that the user can save a string as a file to a user-specified location on their hardrive?
View 4 RepliesFor my application, there is a login form in which users have the option for it to "save the login information" Kind of like MSN or other websites in which you go to a login page an the information is filled out. On my login form, I am using this code for my checkbox which is to "save login info"
Private Sub CheckBox1_CheckChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.Click
Dim s As New System.Text.StringBuilder
[Code]....
I have two website application,
first Application is located at:
MyApp/WebApp1
and the second at:
MyApp/WebApp2
is it possible WebApp2 get a Connection String from WebApp1 web.config?
Can you have a SQL database on a ftp server and connect to it from a windows application?
View 2 RepliesI want to save a string of text to a file every 1.4 seconds or so, and each day at midnight I want to create a new file for the days log data so I keep the file size down. The file stays open the whole time so that it is ready to accept data from several different forms which call a function (SaveToVoltsLogFile(str)), so I open it at module level like this:
Dim fsVlogStream As New FileStream(EVENT_LOG_PATH & VOLTS_LOG_FILENAME & DateString & ".ip", FileMode.Append, FileAccess.Write, FileShare.Read)
Dim swVlogWriter As New StreamWriter(fsVlogStream)
Now each time I call a function SaveToVoltsLogFile(str), the str data gets saved to the file:
Friend Sub SaveToVoltsLogFile(ByVal str As String)
swVlogWriter.WriteLine(str)
swVlogWriter.Flush()
End Sub
But by opening it this way, I cannot call a sub to close it and open a new file for the next day because putting the Dims into a sub means that the file is out of scope to other subs/functions, so my Save... sub won't work! So, what I think I need is a separate sub to open the file, another sub to close it, and another to write the str data. But how do I do this and keep the file in scope to all subs?
Essentially what I'm trying to do is to save the value of a string() to a cell in the datagrid view. The problem is that when I close the program and reopen it the changed value isn't there... It's not saving properly.
Here is my code.
Dim BOCHURSTOTAL As Double = ((BochurimBindingSource.Current("Give_To_Bochur_Quant") * (bochurpr)) + _
(BochurimBindingSource.Current("Reg_Quant") * (regularpr)) + _
(BochurimBindingSource.Current("Priv1_Quant") * (private1pr)) + _
(BochurimBindingSource.Current("Priv2_Quant") * (private2pr)) + _
(BochurimBindingSource.Current("Priv3_Quant") * (private3pr)))
DataGridView1.CurrentRow.Cells("DGV1TotalColumn").Value = BOCHURSTOTAL
Me.Validate()
Me.BochurimBindingSource.EndEdit()
Me.BochurimTableAdapter.Update(Me.PuterDataSet.Bochurim)
After using the following code, no errors are shown, but my database is not updated once i have made a change using my management system application.
Dim constring As String = Application.StartupPath.ToString() + "mydatabaseName.mdf"
Public c As String = "Data Source=.SQLEXPRESS;AttachDbFilename=" + constring + ";Integrated Security=True;User Instance=True"
Sub openConnection()
conn.ConnectionString = c
conn.Open()
End Sub
DB="Source={SQL Server};Server=CALVINRUKA-PCSQLCALVIN;DataSource=DWDSCalTables;Uid=sa;PWD=;Trusted-Connection=Yes;"
I using SQL Server 2008 R2 to connect with HTML page. I trying to connect HTML page with login to SQL Database. I have try called the Source but didnt work.
Send me Code for Connection string for VB.net 2005 and SQL server 2000
View 4 RepliesI am developing a software which will connect to a SQL SERVER situated at Head Quarters over a VPN connection.But for times when VPN is disconnected I want my applications at the branches to connect to a local Sql Server installed at a local server.Now all the applications at each of the local machines have their connectionstring stored in their App.config file.When the VPN is disconnected we have to change each of the connection strings on all the applications in each machine. Is there a way to do it automatically switch the connection string depending on whether the Server is reachable or not, and to store the connectionstring at centralised location.
View 2 RepliesI'm trying to change my connection string to w/e the user wants. After a few tips here and there, this is what I've come up:
1: In my settings I've added - Name(login), Type(String), Scope(User), Value(Nothing)
2: Here is the code I'm using
Private Sub LoginForm1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Here I'm checking if the login in my.settings is there
'If not, I'm going to let the user choose what database
[code]....
The error I get is: Format of the initialization string does not conform to specification starting at index 0.here -
Dim con As New OleDbConnection(My.Settings.login)
When I have my con equal to when I added the datasource from it works.
i have the connection string cn = New OleDbConnection("Provider=Microsoft.Ace.OLEDB.12.0; Persist Security Info = False;" & _ "Data Source=C:printtest2.accdb;")which works fine but my database is in the server in a network what additional details do i need for the connection string The server name is as follows "Prntsvr-Test.auhbr.ctrixa.ad"how do i use the connection string
View 9 RepliesI have installed sql server 2005 in my machine which is installed vb.net 2008. I want my machine to distribute the database to the clients and make it as server.I don't have that much knowledge of how to overcome this issue as i am awfully naive about it.Let me start it here:I have got an application in vb.net...at first i was using ms access database 2007. then decided to switch on to the sql server since i want to distribute the database to the clients who are going to use my application.When i installed the sql server, i imported my access db files onto sql server database. i enabled tcp/ip as enable in the sql server network Configuration. i want use sql server windows authentication as my default user account of my system for the sake to simplify the issue.
Hence, i connected the sql server into the vb.net through the "add new data source".am done with that...the problem is how do i assign the connection string to the vb.net? Or how do i include a connection string in vb.net which tells every other computer that the database data source is in my computer so that every computer can automatically check it in the network.Where exactly shall i put the connection string...as far as my knowledge is concerned for access database, you can easily identify your connection string in project /properties/settings...it goes here and you put your database in any where.And what is the best connection string do i need for sql server 2005..computers are running windows xp.
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]....
I have the following connection string set:
[Code]...
Im trying to add data from a text box into an sql server database. But i keep getting an error.executenonquery connection property has not been initialized.
This is the code ive written
Code:Public Class AddForm Private dataCon = New SqlClient.SqlConnection("server=MYSERVER; database=DB; User Id=MYUSERNAME;Password=MYPASSWORD") Private cmd As SqlCommand
[Code]...