VS 2010 How To Make SQL Connections Work On Other User
Sep 30, 2009
I have a little Windows Form application that uses sql database.My application works on my computer, but when I install the app to another computer I get this errorSystem.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was noccessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I just can't run any of Data sample codes that come embedded with VS2008. I'm trying running CreateDB example but I can't make it work.How can I configure Data Connections? [code]
I am developing a VB.Net application. That application might be working on a LAN. MS Access as a backend will be used.
I have developed many single user applications, but don't know of multi user , LAN, manage DB etc. How do I make the program as Multi user on LAN. Data will be accessed at the same time. How to mange such things.
I have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
I'm working on a vb.net application connecting to mysql db which will have alot of users using it.
How should I deal with the user registration?I mean, I used to create a table with a username and password fields to store the users data in it, but in this case all the users will connect to the database with the same username and password of the server (in the connection string)
I need a pointer on how to do this thing right.What would happen if many connections established from many computers with the same user and password in the connection string?
I'm new in the programming area and I'm having trouble making a calculator. My question is: How do I make the calculator work using only the keyboard, without the need of mouse.
I tried this: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Me.KeyPreview = True End Sub Private Sub FlowLayoutPanel1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles RESULTADO.KeyDown If e.KeyCode = Keys.NumPad0 Then [Code] .....
It only works on the text box called Result. I want to know how do I make work in the whole Class, and if it is possible, to make it work on two different Classes without writing twice the same code.
Using VB.Net and SQL Server 2008 R2: I have recently had a database that using sp_who2 reflects a connection ".Net SqlClient Data Provider" is still active even though the .Net application has closed and disposed of all connections.
'Declare the price rate per night Const decNightly_Rate As Decimal = 350D Private Sub btnCalculateCharges_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculateCharges.Click
[code]...
I am trying to make a hospital form where the user inputs data for a hospital bill. I have to create three functions: CalcStayCharges, CalcMiscCharges, and CalcTotalCharges. I do not know why this code won't work.
For my project I connect to a large number of variables in multiple Beckhoff PLC's. I connect to the PLC in the Form load event.But the first time connect to all plc's taking too long.The data from the plc's. be sent to my program can not cope with the private sub OnNotification. This is because the program is busy with making connections with various other plc's.If the program is fully launched it works ok, but I also want to start working properly.I solve it just with a timer and a counter. Each program cycle I make a connection, the next cycle the next etc.until all connections are made. This should be better.I would like background workers use to make the connections to the PLC's. bgworkers provide the connection.The main program is not blocked, and the incoming data from the PLC's can be handled properly In the form Load event I start the bgWorkers containing the code for connect and AddHandler. Unfortunately it will not work this way?
Imports TwinCAT.Ads Imports System.IO Public Class Form1 Inherits System.Windows.Forms.Form
In my application, users can establish connections to one or more databases in order to pull in data, thus a read-only connection is sufficient. I use the following connection string syntax when connecting to an Excel 2010 database:
I'm pretty new to VB.NET and connecting to SQL Server.What is considered best practice when building an app that needs to connect frequently to a SQL Server DB to fetch, write, delete and update records?Should a connection be opened at app startup (a connection at start is opened to validate the user) and left open for subsequent transactions or should a connection be opened, closed and disposed of each time a read/write to the DB is required?
On a lan, the server and multiple clients work correctly.but over the internet, the server and client can't hear each other(we tried several different host computers, and several different hardware configurations)Is there a secret to getting UDP to do connections over The Internet vs a LAN?
I have an application that requires data be entered, and after entering, a button is clicked to process that data. Clicking the button works just as it should--the data is processed properly. In constructing a test module, I provide a set of data values, followed by:
btnWhatever.PerformClick()
Nothing happens. I have used this syntax for years, and it has always worked flawlessly. I have triple checked everything else and isolated the problem to the failure of the PerformClick(). The PerformClick() is in a test subroutine that does nothing but fill textboxes and labels with default data, then calls the PerformClick() on the button to begin processing. Again, the button works fine, the data is entered as it should be, but the PerformClick() does not fire the click event.
I have code for make the usercontrol transparent: Protected Overrides ReadOnly Property CreateParams() As CreateParams Get Dim cp As CreateParams = MyBase.CreateParams cp.ExStyle = cp.ExStyle Or &H20 'WS_EX_TRANSPARENT [Code] ...... These code shows the usercontrol transparent. But when the control moves I see that these control needs time to be transparent or drawing an image. Why so many time(maybe 2 seconds)? And why I can't use directions keys on keydown event? (The arrow keys are ignored).
I have two textbox, one loads username and the other passwords. Now my browser puts in the usernames from textbox one into the location and then textbox two puts the passwords into the location. Now I already did that.I just wanted to ask, if it is possible to make only one textbox, and make it like this format. Usernames:Passwords. Now, I want it to move the username into the location and the password into the other location and then delete the Collen
I have written a program that uses directshowlib to capture a stream from a webcam and save as an AVI whenever a bird lands on the experiment platform for behavioral research. What I would like is to be able to allow another program or connection to the same webcam at the same time simply for preview purposes, is this possible?
Basically I want my app to still be able to record on demand when a bird interacts but I would also like a IP cam program like webcamXP/Webcam7 to be able to stream a live feed to the internet so we can have a live view of the platform. I had found some articles about connecting multiple streams from one webcam but am not sure how to go about it. If I have to I will simply mount a 2nd cam in the Bird colony and dedicate it to the web stream but if I can use the same cam as the recording cam that would be great.
I have my desktop app, bound to an access database. I want now to improve a button so the user can make a backup of the *.mdb file.So i used this
If FolderBrowserDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then If FolderBrowserDialog1.SelectedPath <> "" Then FileCopy("BDGRACIA.mdb", FolderBrowserDialog1.SelectedPath & "/BDgracia.mdb") End If End If
It works fine when i try the app from within Visual Studio. But when i install it it won�t find the database because it was installed elsewhere.Is there a way to control where the DB is installed and follow that route? Does this depend on the OS the app is installed? Or did I face the problem wrong and i should do something completely different with my button?
visual studio 2010 using vb.net for my windows form.I am trying to get some direction on how to integrate paypal into my windows form application. Currently, I have an expiration date on the software that loads a registration form when the software expires. I would like to add a button that can do the following:
1) open paypal to allow the user to make a payment for the software
2) send the information back to my form (successful payment or unsuccessful payment)
I have a server which has around 300+ users on it. Though the problem is that its coded in VB6, and if somebody has a bad ping, everybody has a bad ping. I need a tunneling server which will tunnel the incoming and outgoing connections and make there ping appear to be 0 in the server. Client to Server, Server to Client.
i created a application with function export report as pdf file, the application can download the report in web format. i run the application in my pc, it is work, but i try run at user pc, but fail when exporting
I created a Custom User Control at work using VS Express. It was added to my toolbox and then I added it to my form.When I created another one at my home use VS Pro, I think, it was not added to my toolbox and I'm not sure how to access it.
I'm familiar with Visual C# and the try/catch for that but I cannot seem to figure out how to do the same thing in VB. Basically I can't figure out how to get the try/catch to work with text boxes and input from the user and whatnot.I've tried setting the textbox.text property = "" but that has no use, I've been trying to find something on Google about it but I cannot seem to find a single thing about textbox try/catch statements. Is it possible to do it with text boxes?
I have this code that gives me the user logged on name of a remote computer, but if i run the program in certaing computers, it returns with the error "Not Available Due Restrictions" which is set if the scope cant connect... why it connects fine in some computers and other not..is there something i have to add to the code for it to run fine in any computer
I created a simple user control with a label, and one property that allows me to set its text.I can call the property Text2 and everything works well, but if I call it Text it doesn't work.
I tried both this: <Browsable(True)> Public Overrides Property Text As String
How to make my counter work. I keep feeling like I'm putting it, or maybe just part of it, in the wrong place so I've been moving it all over the place but haven't found anything that works yet. I'll paste my code below and it will be the code that seems to not stop when it reaches the end of my counter. Other ways I've tried it make it stop after one or two, depending on what I did to the code at them time.
Here's what I have at the moment: Public Class mainForm Dim guessCounter As Integer Dim correctAccumulator As Integer Dim totalAccumulator As Integer Dim answer As Integer [Code] ......
VB.NET While 1 = 1 Dim localRecv As New StreamReader(localClient.GetStream) Dim aString As String = localRecv.ReadLine localRecv.Peek() MsgBox(aString) End While
Basically "aString" will keep updating if new data arrives to the server. This way does work, and keeps MsgBoxing every time I get new data, but I don't wanna use While, I need something else, because It won't run any other code, just keeps looping that. :/
