I often find scripts over internet to perform different functions with SQL Server but I donot know how to use them in vb.net.For example I want to run the following code through my vb.net application, but donot know how to do so.
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '' ;
GO
I have a code in VB that looks like this:'Server.Transfer(txtUser.Text + "_page.aspx")which is taking a forms authenticated user to their page. For example if John logs in, it will take him to john_page.aspx.How will I be able to integrate this in a PHP login script?I'm trying something like:header("location: $member ._page.php");but I don't think I'm doing this correctly.
View 1 RepliesI have a situation where I need to create a session in a Windows server using a specific Username and Password.
View 1 RepliesI have a client who needs Excel VBA code that produces formula values moved to VB.NET. He is in the business of providing financial analytics, in this case delivered as an Excel add-in. I have translated the VBA into VB.NET code that runs in a separate DLL. The DLL is compiled as a COM Server because, well, Excel-callable .NET UDFs have to be. So far, so good: Excel cells have "=foo(Range1, Range2, ...)", the VB.NET Com Server's UDF is called, and the cell obtains a value that matches the VBA code's value.
View 7 RepliesAdd some code to a web server? I have this code here[code]...
View 1 RepliesI'm trying to manage an FTP server with code that requires authentication.So I need to log in, get a list of directories and files within a sub-directory, Create directory, Delete directory and Delete File. (I know how to download and upload) I can't find any documentation on how to do this...though I would think it a fairly simple question to answer I seek not answers, but understanding, that I may not solve, but learn. What good is a fish without the skill to catch it?
View 1 Repliespeople plix help me with ASP code for login. am using MSSQL i want users who have registered using their emailadress and passwords to be able to login.
View 1 RepliesFirst off, I am new to ASP.net, so this is new territory for me.I am using Telerik controls on a VB.net project. I get the following error as a javascript error for every action on the form. Changing any value, whether its a telerik slider, a radio button, asp:button, submit button, telerik rating. Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500
I understand that the 500 error is an error thrown when the server doesn't have any more details, however I was hoping someone might have had a similar situation and can point me the right direction as I have a good feeling it has something to do with the Telerik controls.
I was able to submit the form using javascript however then I get the following error, and I don't know if they are related or not.Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.
I am using the following VB code to attach my DBs to server.
Dim cnnConnection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=" & Application.StartupPath + "datafiles" + TextBox1.Text + ".mdf" & ";Integrated Security=True;Database='" & TextBox1.Text & "';Connect Timeout=30")
cnnConnection.Open()
But it gives an error:
Unable to open the physical file "D:.Net ProgramsSQLDBAttachExperimentsSQLDBAttachExperimentsinDebugdatafilesdbSQLtest.mdf". Operating system error 5: "5(error not found)". Cannot attach the file 'D:.Net ProgramsSQLDBAttachExperimentsSQLDBAttachExperimentsinDebugdatafilesdbSQLtest.mdf' as database 'dbSQLtest'.
Exception: ASP .NET VB .NET Code connect to sql server using sql authentication sql onnection stringHere is the solution for the problem
View 1 RepliesFor a month now I cannot see one of my servers disk info anymore. I have tryd with both of this codes.On the first code I get this error "Failed to optasin Server Information".[code]On my second code to just give disk space on c: I get this error "Drive already mapped" and "Drive not available or forlder not accesabile".[code]
View 1 RepliesI want a PC to operate as a mini HTTP web server that can receive requests from local (WIFI) devices. I know how to resolve the addresses so that the URL of the PC will be known on the WIFI network, but I'm not sure how to get the PC to act as a HTTP server.
View 12 RepliesI'm trying to write code to create a new database and then create tables within the database.
I'm running into a strange problem right now, which is the fact that I was able to create a new database ok on either the regular SQL Server instance, or the SQLEXPRESS instance. However, when I attempted to create a table, I got an error message saying that there is already a table of the same name.
When I tried to connect to the new database via SQL Server Management Studio, I could see the database. However, there are no tables in it! So, theoretically, I'm creating a brand new blank DB, so there should not be anything in this DB, right? and I should be able to create any tables I want in it!
Here is the code that I have so far:
[code...]
I just have one simple form with a button on it. The click event on this button calls the CreateAllDBs() routine.
I'm writing a program that will be based off of TCP communications with a server. The user would click a button, which would send data through TCP Client to the TCP Listener on another computer. The TCP Listener sends back a response, and the TCP client is receiving it. Right now I have the response from the server showing up in the immediate window, which is good. I want the response from the server to determine what action the client program will take next.
How do I use the server's response variable in a different class? I need to use the response from the server in an if-then-else statement to say "if the server response is 001, then execute this code. else, if the response is 002, then execute this code."
Having recently installed IIS Express I was hoping that it was going to make life easier for me, but I've run into a problem almost straight away.Consider the following which is representative of some live code:
Public Shared Function GetServiceId() As String
Dim principal As MyCustomAuthentication.Principal.MyPrincipal
principal = CType(Thread.CurrentPrincipal, MyCustomAuthentication.Principal.MyPrincipal)
[code]....
Running the code under the ASP.NET Web Server (Cassini) everything is fine and I can see that Thread.CurrentPrincipal is of type MyCustomAuthentication.Principal.MyPrincipal.Running under IIS Express this same line throws an InvalidCastException and checking the type I find it is now of System.Security.Principal.GenericPrincipal which is confusing as nothing else has changed.I can confirm that MyCustomAuthentication.Principal.MyPrincipal implements IPrincipal and remember this is Live code, it is currently deployed and working.
am trying to add a xml file contents to SQL Server with the following code but getting the error, how to solve this. any ideas
Dim xmlPath As New String("c:USERSAdministratorDESKTOPxml FILESooks.xml")
Dim xmlQryAs String
xmlQry= "DECLARE @xml XML" + Environment.NewLine() + _[code].....
Incorrect syntax near the keyword 'FROM'.The table (and its columns) returned by a table-valued method need to be aliased.
I have the following code to download a file from a FTP server
Sub DownloadFile_Sap()
Dim remoteuri As String = "http://appsrv01.shakarganj.com.pk:7778/reports/rwservlet?reptest&report=sap_dashboard"
[code].....
is there any code to copy and rename data within the sql server.actually i reated a database which will be like default template and ever company will have the similar database with different name.So what i want when a new company is created, a copy of default database will be created with new name.
View 2 RepliesI'm supporting an old vb.net program whose database it connected to was moved from SQL Server 2005 to SQL Server 2008. Is there a setting on SQL Server 2008 which will allow ODBC connections to access the database but not allow VB.NET to connect to it programmatically?
[Code]...
I have a button that opens a selected file depending on the file extension (doc, docx, or pdf)... the problem is when I have a pdf file is that the file is displayed in the browser, and when I hit the back button I come back to the original page - but the buttons won't then work...
View 1 RepliesI'm trying to implement sql dependency in my vb.net application as per: [url]. I'm having problems with the invoking code, when a notification is received the application locks up with no errors. (When MyOnChanged is called via the delegate). Have I made a mistake in my C# > VB.net conversion? [Code]
View 2 RepliesI have a TCP connection code for client and server communication. It's not meant to be malware but it collects the clients computer information and then connects to the server.
It successfully "connects" but then immediately disconnects.Here is the code for the server:
Dim Listener As TcpListener
Dim Client As TcpClient
Dim ClientList As New List(Of ChatClient)
Dim sReader As StreamReader
[Code]...
I have port forwarding all done and it works if I run the client and server on my own machine. If I run the client on another machine though It gives me a message box saying that it connected with the clients remote IP and at the same time it tells me it disconnected. The client never sends the system information. What is the problem?
ok so i have two "programs" one is a server and the other is a client (a little live chat). i dont want to keep my computer on for it to run the server so i wanted to somehow run it on my online server. is this possible?
View 3 RepliesI need to write an app that will stop and restart a service on a domain controller. The app needs to be usable by all domain users without making them run as.
Therefore, I want to have the administrators login details within the app itself (I will encrypt them).
How do I get my app to run something on the server as administrator though?
I am trying to code a client - server program. I have 4 winsock controls on my main form. The client is able to connect to a free one just fine, and can figure out if they are all in use. When testing my program, I found that when I try to send data through a socket, then send different data directly after, it jumbles the data together.
CODE:
That is the code I am using. When the client is connected to the server, and ready for data, it sends the packet "@Ab". When the server receives this packet, It is supposed to send the welcome alert, and then current events posted in the server.
On the client side, there is a message box that is supposed to show the welcome alert, and at the bottom on a status strip, the current events are supposed to be listed.
When the welcome alert shows, it contains the alert text fine, but then shows the packet for the events after it.
I have to create a project management application in VB.Net Framework 4 which should create a client folder in a public folder in Exchange server.
I think the only way to create a public folder is through the management console. Is there a way to connect to the Exchange server and execute the creation command file from the code but I do not know how.
First off, my apologies for being a complete Newb! I have a SQL Express database that I use quite successfully to track my investments in several accounts. I built it myself, it's quite functional, and Im happy with it. The problem is that there are multiple account tables and updating them can be tedious in SQL Server, if multiple purchases and sales in multiple accounts have occurred in a month. Tedium can lead to errors¦
[Code]...
I have developed an ASP.Net 2.0 application and I am facing problem in sending email from my Web Server. Following is the VB code I have used to send email from my web application. Thing is when I try to send email from my local system (laptop) the email goes out fine and reaches the recipient address instantly but when I try to send email from my web server it fails.My hosting provider gave me a relay-host address for sending out email. The email goes out fine but the relay host has an annoying amount of delay in email delivery which is a problem during the sign up process.
Here is the code I am using:I have imported system.net.mail in my code and used async="true" on the aspx page.
Private Sub SendMail(ByVal actcd As String)
Dim mailMessage As New System.Net.Mail.MailMessage
mailMessage.From = New MailAddress(support@ihomejobs.com)
[code]....
I have tried the above settings and they work fine from outlook and the application when tried on my laptop but these settings fail on web server.I want to send email from my web server without using a relay-host.
I have created a few months ago a simple tool in vb.net, that sends an xml code to server, and that server sends response after a while. Everything is performed in http session, for that purpose I use webbrowser control and webclient. I know it could have been solved in different way, however iam not an expert in vb.net, and also didnt want to spend too much time on it. Anyway it worked, until they had changed something on the server. Let me explain in a few words how that tool works, so it will be easier to understand the problem.
In the first part, I open an URL in the webbrowser control, subsequently I enter xml code in the textarea on that page and click on the submit button. In result of that I get another page with some data on it, namely links to xls files. In the next part I use webclient for downloading those files. What is important for all of these operations I need to use the same http session id.
So, simply by now, i just set headers in webclient - WebClient.Headers.Add("Cookie", WebBrowser1.Document.Cookie.ToString) What have guaranteed to use the same session id by the WebClient. However, after the change made on the server mentioned before, the JSESSIONID value is not available in that string. When I use https analyzer (fiddler), I can see that value there...until moment when I am using WebClient. Of course due to that fact, the webclient won't download files for me, because the session id is not the same.
There is one more thing, what would be useful. When I checked the cookies file on my harddrive, I saw that line starts like #HTTP_ONLY. I think that would cause that problem with jsessionid.
Now, I am coming to my question Do you have any idea, how I would get that JSESSIONID value ? It is sent from webbrowser control, however don't know how to get it.
I am new to Jquery and trying to start learning the new tool. What I want to do is call a JQuery message box from my gridViews Row Command function after the processing is done so I can notify the user the process has been complete. I was trying to use this website as a referanceBut not sure how to call the function from the serverside. I have triedPlace this inside your script tags...
$(document).ready(function () {
//Determining if there is a message to be shown if the message is not equal to empty string then the messagebox should appear.
[code].....