The string is all correct (minus the RID and pin I x'd out) but the USER would need to add the WEBSITE as show where I have the textbox1.text below
I realize its in Parathesis, so that is not going to work, but not sure how to send this entire string with a new website entered from each user .[url]....
This is a bit old-contents to be discussed but I need someone who can explain me how to create stored procedure in SQL Server for returning a value from procedure, example:[code]Then I need the name of its customer and the address instead.I need to make it as a stored procedure and show me how to execute it on VB.NET. Perhaps we assume that the name will be prompted to LABEL1.TEXT and the address will be prompted to LABEL2.TEXT. I've improved this SQL-Server Stored Procedure Using return but I have nothing to return after I execute it.[code]
View 1 RepliesI have been searching for a good code example that will place a small server program on my server and then allow me to use a client on my pc that will tell the server program to run a batch file on the server.
I thought this would be simple... I am finding it not that easy.
We have a server that users need to execute a command on however we do not want them to have login rights to the server so this will allow them to execute the batch file without having to log in.
Im trying to execute a winform app from my website (asp .net), this winforms app its execute in the server side for processing information and send email, but i need to pass some arguments, from the webpage i know how to do it, but im asking how to catch the arguments in the winform app?[code]...
View 4 RepliesIn my VB.NET code I construct a ODBC.COMMAND to call a stored procedure that eliminates a record from table in SQLSERVER 2008, I use this code in a FOR NEXT loop, it may contain 1 to 20 records_ID to pass to stored procedures to delete the records.
This code work well for several months, but since the last compilation it only deletes the first 2 records.
In debug mode in VS 2008 IDE works fine.
VB.NET CODE
''' <summary>
''' DELETE CANCELED CUSTOMER ORDERS
''' </summary>
[Code]....
I am having an issue with an ASP.Net page I am writing and struggling to diagnose why this page is failing.
I am trying to do this:
Dim st As New StringWriter()
Dim strURL As String = "CourseProgramme.aspx?id=3733"
Context.Server.Execute(strURL, st)
txtNotes.Text = st.ToString()
The aim here is to get the HTML back for the page that has been specified in strURL and then display it in a textbox. However when I run this code it crashes the ApplicationPool in IIS and when I look in event viewer I see this error message:
A process serving application pool 'blueprintdev' suffered a fatal communication error with the Windows Process Activation Service. The process id was '5284'. The data field contains the error number.The strange thing here is that in another page I do this code which works fine:
Dim strDutyStartDate As Date
strDutyStartDate = TextboxDutyStartDate.Text
Dim st As New StringWriter()
[code]....
As far as I can see other than the URL I am passing, which does exist, I cannot see a difference between the two.The page I am developing is in ASP.Net with .Net 4.0 however in the website there are some classic ASP pages. IIS is running at version 7.5.7600.16385 on Windows Server 2008 R2 64Bit.So far I have tried setting the application pool to run in 32bit mode but that causes errors in other areas and the site will not load.
I need to download an .exe from the web/ftp server and execute it. (it's a setup program)The application would use the WebClient (probably) class to downlad the files, and presumably would display progress to the user as it goes.
View 3 RepliesI need to download an .exe from the web/ftp server and execute it. (it's a setup program)The application would use the WebClient (probably) class to downlad the files, and presumably would display progress to the user as it goes.
View 1 RepliesWe have a Try/Catch block of code in our web application to trap a certain exception. What we want to do with this exception depends on the current time. If it is between 4:30PM and 3:00AM we will want to send an email, otherwise we will throw the exception.
Try
'Yada
Catch ex as WebException
Dim Time As DateTime = DateTime.Now
[code].....
I have simple ASP.net web form. With a simple click on a button i need to call a the Multithread process in order to execute my querry in SQL Server DB. I know that my querry willl take up to 45 min to be executed. While the process is running i need to display some status information like: Starting time, Time elapsed, % of completed...So after running the process i got the following error message: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."So i have 2 problems to fix:
Avoid getting timeout while processing/calling the stored procedure. I tried to add cmd.CommandTimeout = 1000 but it didn't work out!
Display correctly Time elapsed and % Completed while processing.
Here's my code in the main form:
Imports System
Imports System.Data
Imports System.Configuration
[code]....
I am using VB 2008,I am trying to make a launcher my private server but, I failed it always say 'This exe can't execute independent" I tried these method
Shell ("Game.Exe") And System.Diagnostics.Process.Start("Game.exe")
I'm just wondering how I could have a Textbox, execute "scripts" through it? Like say my Textbox.Text is "MsgBox("test")", how can I execute that function?
View 2 RepliesI trying to figure out how to execute commands stored in string, let's say i have string called "command" and a textbox, so i want vb to run command that i typed in textbox, e.g. i type in textbox "label1.text = "bla bla"", and then type like "msgbox.show". Is that even possible?
View 12 RepliesIs there a way to "execute" a string variable as a command? [code]
View 9 RepliesThis is perhaps something that may or may not be feasable in VB.Net. I would like to give my end-user the flexibility to add segments of code to my program, save it to a text file and then run it whenever they need it. This will ease the burden of upkeep; rather than compiling all my code and releasing that at short intervals, I can just let the user update the portion of code they want without having to re-compile the tool.
[URL]
But that does not seem to include variable reference. So if I wanted to add the following code, it won't run.
Dim myText As String = "For n as integer = 1 to 10000" & _
vbCrLf & "me.label1.text = ""label"" & n" & _
vbCrLf & "Next n"
AxScriptControl1.ExecuteStatement(myText)
It would be great if I could run something like that, where as long as all the variables were defined, it would run like compiled code.
[code]....
I have a problem to implement action button to execute bat file . I am using SharpDevelop Version : 3.2.0.5698 . this code looks like :
Sub Button3Click(sender As Object, e As EventArgs)
Shell(Environ$("CONFIG") & "wpis_v3.bat")' TODO: Implement Button3Click
End Sub
in wpis_v3.bat I have :
@echo off
%DIR%instatus.bat >> %DRIVE%users
eport.txt
status.bat launches script to check license availbilty on the server and write it to report.txt ... by launching just wpis_v3.bat it works . report is generated with all information about licenses . But when I launch from VB icon - report file is generate but is total empty . I observed that with any bat which contains >> VB doesn't write into file. Is there other way to acchive it ? I would like that VB will show only specific lines from this report.txt - which contain string : "Site" and other "Client" .
I was recently assigned to do some research on how to approach a project. Right now we have an old program written in tcl. From this tcl program ( running on VMS client computer), we are able to run unix commands to execute processes on a unix server. This is done via tcpip. Now, we are thinking of making upgrades to this system . We are wondering if this kind of thing was possible with Visual Basic. Are we able to run a VB program on windows computer to run UNIX commands on a server? If so, what issues might be brought up. If anyone has even the briefest guideline or tip on this,
View 3 RepliesI guess that I'm not the first who ask this, but what is the easiest way to use threads in VB.NET? I mean, I need to download some string from a remote server and then to show that string in the GUI, so I have to use some callback function to call it in the main thread. I found different approaches for this, but all seems very difficult compared to Python where (with GTK) I used something like: gobject.idle_add(callback_function, parameters) and "callback_function" was executed in the main thread. How I do that in VB.NET?
View 1 Replies[Code]...
how can i get this code to return all values instead of just the first value ?
Hey guys, I am trying to send data from client to server (encrypted) and the string sent from the client is not the same as recieved from the server. I've been killing my brain for hours to get this to work but I cant manage. Im converting everything to Base64 string.
Client:
Public Sub SendMessage(ByVal msg As String)
Try
SyncLock myclient.GetStream
sw = New IO.StreamWriter(myclient.GetStream)
[code]....
I 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 am working on an application that is going to read a weight from a scale. The people who sold us the scale said that I can send a string to the scale over FTP and the response I will get is the weight. I haven't done much with ftp and have been searching for weeks. Can anyone point me in the right direction? The steps are... Create a TCP/IP connection to the ip address, port 1701 If the connection is succesful then I'll get 53 Ready for user as the response I can then send the username/password to the machine (sent as a string...) Read the response, which should be 12 Access OK I then need to transmit 'r wt0101' to read the weight. The response will have the weight. They've said this is done through FTP but maybe that's not the case? I don't understand why it would be FTP but that's what the technical documents say. Is there a class I can use that sends string commands over a tcp/ip connection?
View 8 RepliesI have configured Sql Server Express on a server, Enabling TCP/IP and Named Pipes to accept remote connections. However when i attempt to connect from VB.net on another PC on the same network I get the following Error: Failed to login user "ServerNameUser".
Can anyone offer some server setting and a ADO.NET Connection string. The attached file has the Sql Server Settings.Attached Files sqlRemoteConfig_Current.txt (806 Bytes, 70 views)
I am creating database application in VB 2008.How am i find the connection-string for that application?what are facts that i have to include in connection-string?
View 2 RepliesMy 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 am using following code to edit my connection string [code] on dbSQLServerTestDataSet1.tblContact part of the line.These objects do exits in my project. I have also imported System.Data and System.Data.SqlClient.
View 1 RepliesI have problems with uploading a string to my server.here's the
Module Module1
Sub Main()
Dim text = Console.ReadLine()
[code]....
The text was no appear.
I have two databases, one on my local work computer and other on a server. Both have been created with Microsoft SQL Server 2008. I can access both of them with connection strings that contains names of the servers and some other information. However the names contain only the ip-number of the server. And I need the full name of the server and the instance created, separated with "" character. I can see them in my SQL management studio but I need to get them from VB-code.I created SqlConnection-class but it finds only the ip-addressed name. SqlSourceDataEnumerator won't do good because it finds all unnecessary server names that I don't need. How can I find the real name of the server that is specified in the connection string?
View 5 Repliesconnection string for vb.net2005 and sql server 2000
View 1 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 Replies