My program asks the user for the location of the database and stores the location in the variable "filename"I then have this:Dim ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filename
View 2 RepliesI have a vb.net 2010 windows forms application with a strongly typed dataset. I am storing the database connection path in a txt file so that the database's location may be changed in the future for whatever reason. The typical location of the connection is the read only app.config from what I gather. I have the datasets modifier set as public but I am having trouble finding how to access the connection object for the adapter.
View 5 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 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]....
I'm looking for a way to search a string variable for two words and copy the text in between them into another variable. This needs to be done as many times as the match occurs.
View 3 RepliesI had a job interview today where I was asked to build a GUI for an MS Access 2003 database using VB.Net 2008 and old ADO. I looked on [URL] to find the correct one and I wasn't sure given the diverse development environment.
View 2 RepliesWhen i start computer or after restarting the first time when i open my program show this message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.What is problem here is connection string.vb.net
Public conn As New SqlConnection("Data Source=.SQLEXPRESS1;Initial Catalog=PesniDB;Integrated Security=SSPI")
My application is VB.net 2008 with sql server 2008 , the application is working on the server . whereas in the client i got the error which i attached below Error" A Network - Related or instance - specific error occurred while establishing a connection to sql server. The server was not found or was not accessible.Verify that instance name is correct and that sql server is configured to allow remote connection"
View 1 RepliesI have been reading/researching/taking advice on connecting to my db by storing the connection string in my app.config. I have the connection string named "MyDB" in my app.config file. However, I cannot figure out how to use it in my code. I use mySQL. I added the configuration.dll reference. How do I pull the connection string from the app.config file and open a connection with it?
View 24 RepliesConnection strings can stored in encrypted form in configuration file.
But some one can easily use the "UnprotectSection" method to decrypt the connection strings
I don't know how does this thing make it secure.
I have two connection strings coded and in their different contexts, they both work in VB.Net 2008. However, the third connection string will not work if it has the extra ;HDR=Yes;IMEX=1 so I wonder why. Is it perhaps the words 'Extended Properties' in the third example that makes it fail?
[Code]....
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?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 am trying to connect VB 2008 express with sql 2005 standard edition on a reomte server. Is this possible or VB 2008 express version limits this Can some one guide me with the connection string to achieve this.
View 1 RepliesYou will find attached the source code of a small program. I wanted to know if it was possible to modify the connection string in Web.config and use a connection to MySQL. I made some attempt, but does not connect.
View 1 RepliesBefore I explain, the connection string I am trying to use is copied directly from elsewhere in the application that has always worked and still does.
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|cdb.rmd;
Persist Security Info=False;
My problem is that no matter if I go to "Server Explorer", "Data Sources", or any other option it will not let me add a datasource/database. Up to this point I have done everything at runtime but now due to reporting issues I need to create a dataset in design view.
This is what happens:
I click "Add connection..."
I choose "Microsoft Access Database File" (Which it is...)
I click "Continue"
Form shows up with a field for my connection string, which I insert (shown above).
I click "Ok"
I get the following error:
Format of the initialization string does not conform to specification starting at index 0.
The "Test Connection" button is apparently useless as the connection passes even if the field is blank.
I have attempted reducing the connection string to only what is absolutely necessary.
I have copied the string directly from connectionstrings.com replacing my filename.
I have renamed the file to an .mdb extension.
I have used the full path from C: all the way to the file.
I have filled a DataSet from a SQL Server table and I have also set up synchronisation with a local copy (for offline use). The local copy is saved to a SQL Compact Editon database file.
1. Create the connection string to the SQLCE DB
2. Execute a stored procedure (a copy resides in the DataSet) against the SQLCE database
when the codes below is run, when it loses focus, the error 'connection String Property has not been initialized' shows and when i commented on the lost focus section, and click on saving, the sme error shows and ' da.Fill(ds, "Branch")' is highlighted.
[Code]....
I am creating an VB 2008 application which uses 2 connections strings in according in which computer is running (my test machine, and the production server). How should i manage the connection string in order not to change manually the connections string which are many inside the code??
I have read that you can read them from an external line, or if you put both connection strings in an external file, according in which machine the program is running can actually the correct string?
Not sure this is the most efficient way but i am trying to set a connection sting via the openfile dialogue. Is this possible? Im trying to enable a user to specify the excel file they want and to access the excel data using data adapter and fill table etc. Im use to working with access db files but not excel.
View 5 RepliesI have a small application where I am importing different versions (2008, 2010) of Excel sheets and saving them in SQL server. My program will find the 2008 versions but for some reason it will not find the Excel 2010 versions. I am not sure if my code for the Connection String is correct. Perhaps someone could have a look at my Connection String code?
Imports System.Data
Imports System.Data.OleDb
Public Class DBHelperClass
[code].....
I know this topic has been addressed a million times but please help me out. I have read so many articles on HOW TO encrypt and decrypt the app.config file but I need to know WHEN and WHERE I should encrypt it.
The problem arose because we found an AppName.exe.config file on a users computer and the database username and password was clearly visible. I understand that the .config file gets created during the VB app install process and is used
by the application. I then learned about the aspnet_regiis.exe tool and ran it on the app.config file inside my VB project. I am guessing that was the wrong thing to do.
When I now install the app on user desktops, it gives an error stating failed to decrypt the connection string. Also, when one of my other developers attempts to open the project in his copy of visual studio on his computer, he receives an error when trying to access the setting portion of the project properties. We store all of our projects on a file server and any developer can access the projects via a mapped drive on their computer.
So how am I supposed to encrypt the .config file. If I can't encrypt the App.config file in the development environment, then I'm guessing I have to perform the encryption on the users PC during the install process? How do I do that? Or is that what I am supposed to do?
Just for reference, here is the aspnet_regiis command I ran.
aspnet_regiis.exe -pef "connectionStrings" S:ProjectsDevelopmentVB.netPTPUSourceCodePTPU -prov "DataProtectionConfigurationProvider"
One last thing, maybe it's my misunderstanding of the issue but if this problem has existed since .Net 2.0, why has an option not been built into the development studio to encrypt connection strings?. This would seem to be a very common issue, even their own dataset wizard creates connection strings that are clearly readable.
I want to read a tab delimited file so i set up a data reader with the following connection string: [Code] However when I do this it doesn't seem to delimiter at the tab characters (I cannot work out why it is breaking up the data where it is). the first few lines of the csv are in the attached "dbamstr.txt" - the select statement I am running is: "SELECT * FROM dbamstr.txt".
View 3 RepliesI have a script that checks a version table from one mdb (server) and compares it to the same table in another mdb (user folder), if the version number is mismatched it needs to replace that file from the server, to the user folder. The problem is, how to get the OLEDB connection to the user folder since, the folder destination is
E:Configurator & UserName & Detail2004.mdb
How to set this up?
Here is my code:
Dim UserName As String = Environment.UserName.Substring(Environment.UserName.LastIndexOf("") + 1)
Dim connectionString2 As String = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:Configurator" & UserName & "Detail2004.mdb"
Dim con2 As New Data.OleDb.OleDbConnection(connectionString2)
Dim cmd2 As Data.OleDb.OleDbCommand
Dim dbconn As OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DS As New DataSet
dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:COLORsitedataCUFORHDR.dbf;Extended Properties=dBASE IV;")
[Code]...
I prefer SQL server but im afraid in this app I have no choice. I think the .DBF file is v III dBase according to a thrid party .dbf viewer. The code explodes on the DBCommand.Fill(DS) line, telling me I have provided and invalid file path. The path is good to go.
Should I be using a driver with a different provider? When I remove the Extended Properties parameter I get an error unrecognizable database format - hinting in this case the path is correct.
How do I strip out the data source from the connection string so that I only have the directory path and file name.
My connection string is thus:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsMartinMy DocumentsVisual Studio 2008ProjectsRestelRestel IIRestel IIRestel.mdb
I have been creating some asp.net sites that connect to an AS400 for data and I use a SQLDataSource for this with the following connection string (changed for security reasons). Now I need to create a winform application in VB.NET and am wondering how I would do this? I have only used MSSQL in winforms and use the sqldatareader for Select statements and execute non-query for others. I need to call some stored procedures on the AS400 passing parameters. I was hoping to do this by code like I do with MSSQL rather than drop in controls to bind to.
Provider=IBMDASQL.DataSource.1;Data Source=192.168.100.2;Password=xxxxx;User ID=xxxxx;Initial Catalog=S12345;Default Collection=AABBCC
I made an application that was used by one person only, but now my boss told me that this application it'll be used by all company.I made the application with a dataset that have the datasource in a access database that's installed with the application. The user can add, delete and change values in the database, so i had to put the database in a sql server to everyone see the changes.There's someway to change the dataset datasource/connection string?
View 9 RepliesWinfom, intellsense remind me configurationManager wrong.This code is from asp.net, how can I change it?
unction GetData(ByVal queryString As String) As DataSet
' Retrieve the connection string stored in the Web.config file.
Dim connectionString As String =
[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.