I 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 am using VB 2008 & Access 2007 for windows forms application having typed datasets while creating connection to DB vb asks to store connection string so i did it now that i want to know where is the actual path of file where these connection strings are stored. b'cas after runnig a macro in Access Database i lost all these connections from Data Source Configuration Wizard Combo Box & also i am anable to create a new connection to Databases.I have tried to reinstall the entire Visual Studio couple of times .
View 17 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 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 RepliesI'm sorry but Microsoft did not think about this very well. I have used the dataset wizard to connect to my sql server and the connection string was placed in the app.config file. The only problem with this is that you can not write to it nor change string at runtime. So I need a way for each one of my users to specify their connection either during installation or after installation. I would appreciate any help in this matter.
View 14 RepliesI need to be able to change the connection string of a strongly typed dataset at runtime. I have gone into the settings.vb page and written this code:
Namespace
My
'This class allows you to handle specific events on the settings class:
' The SettingChanging event is raised before a setting's value is changed.
' The PropertyChanged event is raised after a setting's value is changed.
' The SettingsLoaded event is raised after the setting values are loaded.
' The SettingsSaving event is raised before the setting values are saved.
[Code] .....
The way the code is suppose to work is that when a user logs in, the application gets the user's site ID (gvUserSite), then uses that to set the connection string. But when I log on with a SiteID of "21" it always uses the Case Else value. Also when I set breakpoints in settings.vb the application never stops on the breakpoints I set during runtime. As if the breakpoints were never set. Also if I put any code in the "MySettings_SettingChanging" in settings.vb I get a runtime error
"The debugger cannot continue running the process. Process was terminated.
I have a DB application that I've created using the Datasources wizard. A particular insert requires that two inserts must be done at the same time meaning that it has got to use transaction. how to use transaction in this situation.Only performance counts!
View 5 RepliesI am creating a console application in Visual studio 2008-vb.net. I created a typed dataset-dataset1.xsd. Now in the code, I want to access the table. How can I reference the table?
View 1 RepliesI just read this post url...Post #2 by jmc states indicates the use of Entity Framework instead of typed datasets.when jmc says something I usually pay attention. I have a large app that I've been converting from VB6 to .Net and I've used mainly typed datasets.It's a single user app that uses an Access database. I'm have no problems retrieving the data from a table or multiple tables and I'm very happy with its preformance.Is it worth scapping what I've done and learn how to use Entity Framework? I should add that I'm near the end of my programming career not the beginning.
View 4 RepliesA project I am currently employed with will have some time soon to improve and specialise a product that is currently in use. We may have about 4 man weeks spare in which we could replace the typed datasets that are in use.
The project is currently written in Vb.Net and we will definitely not have time to replace this code with C#.Net, although we would like to.
My question is what would you suggest as a replacement for the typed datasets.
I have currently suggested nHibernate as I have worked with Hibernate before and loved it.
Linq to SQL has been discounted.
I used to build data layer by using Classes, however someone suggest to use Strongly Typed DataSets because it's faster in development. The data layer that I'm going to build should support multi DBMS(Oracle,MSSQL, MySQL..)
View 3 RepliesI used to build data layer by using Classes, however someone suggest to use Strongly Typed DataSets because it's faster in development. The data layer that I'm going to build should support multi DBMS(Oracle,MSSQL, MySQL..).
how is better build it by using Strongly Typed DataSets or by using Classes?
In a typical session with the program I'm writing, the user needs to be able to access the data in 1 to 500 (maybe) tables (but always only one table at a time). Up to now I've been creating these single table datasets dynamically, as and when required.I've now come across the distinction between typed and untyped datasets (where typed seems to be the recommended option). It seems, though, that typed datasets are created at design time only and not dynamically. Is this correct? Are all of my dynamically created datasets therefore untyped?
View 12 RepliesI've been Searching the Net for hours now, and i can't really seem to find anything clear and straight to the point.
I need to create a Server/Client application using VB.net 2008, it's actually my first time to have a database on another computer. So I first searched the internet for the things i need to make this software.
[code]...
and advise how I can change this connection string at run time. This is going to be on Client's computer and my application will need to change the name of computer after user enters it.
View 1 RepliesI have an existing system that uses an ODBC connection to connect datasets to a SQL Server database. I want to conevrt these to use an OLEdb connection.
View 4 RepliesIm using the code from [URL] as a starter, most of the code is the same. the chat system works fine but on the client a added a disconnect button "clientSocket.Close()" and as soon as i click that i get errors, on the client, this is the code...
Private Sub getMessage()
For infiniteCounter = 1 To 2
[CODE]...
And this line...
serverStream.Read(inStream, 0, buffSize)
gives me "Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."
Now im talking the server, after the client clicks disconnect or closes by task manager, looses connection, etc the server crashes and gives me.
How can I change my connection configuration of my datasets and project. I mean, my datasets are not hard coded, I am using dataset wizard. Now, I have to change the computer name to IP.
I am worried that it could give a destruction to my project. How could I change it easily and safe?
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]....
How do I close a connection of strongly typed dataset? I want to backup my database with a zip technique. But I can't access it when my program is open. I've closed connections of all table adapters but it didn't work.
View 14 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 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?
Is there a way that we can use that Add data source wizard that is in vs to our own apps?
View 2 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?
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'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?