VS 2008 How To Make SQL Connections Work
Sep 29, 2009I 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]
View 12 RepliesI 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]
View 12 RepliesI 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)
View 21 RepliesI 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'.
[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.
[Code]...
what libraries can i use to make http connections in visual basic? like cURL library for VB ?i am looking for something like cURL for visual basic.
View 1 RepliesFor 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
[code]....
i have written hundreds of programs with vb.net 2008, but never a service before. I have a simple service written that basically just rights a entry in the eventlog to test. No coding/compiling issues. I run the "installutil.exe" and I get a error ever time. So I went back and added the "Add Installer". But I am sure of what else I need to do, as I get the same error. Please assist.
Error:
Installing assembly 'C:UsersDonaldDocumentsVisual Studio 2008ProjectsWindowsService1WindowsService1inReleasewindowsservice1.exe'.Affected parameters are: logtoconsole = assemblypath = C:UsersDonaldDocumentsVisual Studio 2008ProjectsWindowsService1WindowsService1inReleasewindowsservice1.exe logfile = C:UsersDonaldDocumentsVisual Studio
[code].....
how this works?
Visual Basic (Declaration)
Public Function GetColor ( _
prop As ColorProperty _
) As Color
[code]....
I cannot make the code work when it gets to consonants. I cannot get the consonant part correct.
Code:
'Date of last Modification: 4/11/2009
'Pig Latin Converter: Takes and English words and converts it to Pig Latin
'Rules stated in comments within calButton click event procedure
[code]....
I'm trying to make my program forward port 2303 for UDP so that my game will work without the user having to forward their ports manually every time they want to play.I've searched and come across this C# code but I keep having problems converting it to VB.Net:url...
View 1 RepliesI 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 was wondering, if there is a way to block incoming connections from specific ip adress that tries to connect to computer
I assume that it cant be via windows host files
I need to change the connection string of all tableadapters at runtime, can anyone tell me for the best way to do it?I have a conection string in my settings, that i can't change at runtime (application scope), i could go to dataset.designer and change the value to a new variable but i don't think this is a good method.
View 3 RepliesI'm wondering if its possible to log who is connecting remotely to my local hard drive and also log what they do if possible?A lot of people access my hard drive and im curious to what they do while there.
View 1 RepliesHow would i write all the TCP connections as an array then when i click on one connected client, it chooses the same value from that array?
View 2 RepliesI need help getting a connection to a database from within the windows 7 environment. The code currently works for windows XP flawlessly.However in Windows 7 i get an error about a resource not being registered on the local computer.
View 12 RepliesI 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.
View 1 RepliesI'm writing a program that notifies the user when process X.exe starts eceives a new TCP connection.
Is the only way to issue a full 'netstat' and then select the entries relating to that specific application or is there a better way?
I have written tons of websites with PHP and MySQL, now I want to combine a website with a program on the computer.I have searched google, but I cannot find a good tutorial on how to use MySQL on a server with Visual Basic.NET I need to connect to my MySQL database, read data, and write data.
View 6 RepliesI have a need for an application with a SQL database back-end. The application will run on a laptop and will therefore be used both on and off the network. I can write the app and I can link it to SQL over the network. I also know how to dynamically change the connection string so I can handle online/offline data source connections. Where the data can be stored on the local client? I'd like the data to be held in the central SQL DB and to automatically copy to the laptop upon connection to the network. The client data source is read-only and will not upload back to SQL. I've seen XML mentioned but that looks overly complex.
View 2 RepliesI have been developing an async socket connection server and client program. I have been testing it, and noticed that if I connect to the server from my client and then disconnect. Upon reconnecting I am on a different port(local IP still). This is fine, however when I go to send a message, and the server trys to update all the clients, it eventually hits clients that do not exist anymore. I get the SocketException 10054, and upon connecting/disconnecting enough, it no longer works at all. My question is how do I clear out these no longer useful sockets from the server? I am doing currentsocket.Shutdown(SocketShutDown.Both); and then a currentsocket.Close(); after that. When a user disconnects.
[Code]...
I have a form that works on my local Machine I created into. I have Office 2007 on this machine. I created the Form with the Excel 12 Reference. I move the Entire conetence of the Project folder to my work computer. Which has Office 2003. Do I need to recreate the form with the Excel 11 reference. I could not get the form to work on work computer. IT has a com error. I am acessing the EXE for the debug folder w/in the Bin Folder.
View 7 RepliesHow 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. :/
I am using datagridw view control for input purpose but when the datagridviewcell in edit mode the it is no problem to move current column to next column but when it is not in edit mode then and pressing enter key then it is moving to next row and the same column. but how to take over this problem please give me dn idea.
View 2 RepliesHow to make a 32 bit VB.Net com add-in work with 64 bit Office 2010?
View 10 RepliesI'm looking for some advice on how to make my app work with different resolutions as I have posted a demo game on the forum but the game was designed on my laptop which is set to 1280x800 but a few people who have tried the demo are having problems as they are using 1024x768.
Is this a case of getting the computers resolution when the app starts and alter the size and position of controls?
I am using the code below for paypal notifications. I checked the notification history and it comes back as payment_status is Complete BUT the VB code performs the code for the "INVALID" case...
'Post back to either sandbox or live
Dim strSandbox As String = "https://www.sandbox.paypal.com/cgi-bin/webscr"
Dim strLive As String = "https://www.paypal.com/cgi-bin/webscr"
Dim req As HttpWebRequest = CType(WebRequest.Create(strSandbox), HttpWebRequest)
[code]....
Below is a test program I am trying to get working with using SENDKEYS to send strings to a window.The appactivate never makes the notepad window become the current window in focus and the sendkeys doesn't work.
View 8 RepliesI made a custom button to input keypresses:
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Class KeyInputButton
Inherits System.Windows.Forms.Button
[code].....