I'm writing a VB.Net app using SQL Server 2008. I want to use exception handling but it appears that the way to do that in SQL Server 2008 has changed. I've read about a configuration console to create an exception policy for my app. Where do I find this configuration console?
View 1 RepliesI have a method as follows:
Public Sub Send()
Dim caughtException As Exception = Nothing
Try
//Attempt action.
Catch ex As Exception //Custom exceptions which can be thrown all inherit from Exception.
//Instantiate error object to be logged.
caughtException = ex
End Try
//Log action and if there is an error log this too.
If caughtException IsNot Nothing Then Throw caughtException
End Sub
It is essential that I log the error for reports, which after research, rethrowing the exception is the right thing to do. What I am concerned about is preservation of stack information. In order to keep the code DRY I am logging the action in one place - after the exception has been caught. This functionality is ultimately exposed via WCF.
I am writing ASP.Net Web-form in VB.
I have a system which have already handled exceptions by try-catch blocks everywhere.How do I quickly and generically implement exception logging like overriding something instead of inserting logging functions in every single catch block?
I have inherited a ASP.net site, and I've made some changes too to some of the VB code and CSS, and have hosted it on a FTP. It uses an SQL DB to allow users to log in and calls stored procedures.The site complies with no errors, and allows me to log in as a user, and can works perfectly on testing.However, once uploaded to the FTP, it no longer allows me to log in as a user. It hangs for a while, and then returns a message saying that the password is wrong, despite it being correct. It doesn't throw an error message, and I think I've narrowed it down to something to do with the Web.config file, but I'm at a loss as how it's not working, especially with the lack of error messages being thrown.[code]
View 2 RepliesUsing visual studio (Winforms) with sql server (R2). If you can login by inserting the correct values in the textfields (vb.net) that is connected in the database . How do i code the log out?
For the past year-ish i have pretty much mastered the httpwebrequest function of programatically logging in to 1 of my websites to retrieve data, while it works well i was thinking about the webbrowser function, would i be better sticking to the webrequest route? it looks like the webbrowser requires much less code which is good lol can the webbrowser do everything httpwebrequests can?
View 1 RepliesI can log into a website great using the webbrowser function then have the fields filled in and the submit/login pressed, i am now trying to do it so i don't need to use the webbrowser function, ideally what i intend doing is grab a piece of information once logged in.i have searched a lot and i know i need to use webRequest and webResponse for this, the part i'm having trouble with is how to deal with posting the actual data to the website, in the webbrowser way you can see the input fields filled in for you but i'm not sure how to post the data this way?
View 2 RepliesI'm trying to login to a forum based on given details (username + password textbox).
Here is my current
Dim id As String
Dim password As String
Private Sub ButtonX1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonX1.Click
If TextBoxX1.Text.Length > 0 Then
If TextBoxX2.Text.Length > 0 Then
[Code] .....
But I'm having trouble clicking the "Log In" button on the top floating bar. And the page I'm trying to login to: [URL].
I'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 RepliesAs of now I have the POST data down and am sent to a 'Redirecting..' page.Here I am able to grab some data from the HTML that will be required in future requests.It seems that now, however, I need to authenticate myself.Packet sniffing the data, here is what I need to imitate for a successful login:
HTTP/1.1 302 Moved Temporarily
Set-Cookie: GoogleAccountsLocale_session=de
Set-Cookie: SID=DQAAAG0AAADLKo0PYiFiKAFeYWFSWc8CDvKmmRDmpLLQlmkK0VgnaSxNeLk1FH9rZZ_ztotu-
[code]....
Bolded are the pieces of data which I can extract, underlined is the one I'm not sure of.Anyway, how can I go about setting these cookies to an HTTPWebRequest (well, multiple requests but just the one object)?
I'm trying to use WebBrowser to remotely log into a site and perform a basic action on the site.I'm running into problems though so maybe you brilliant people The first step is logging in to the site. Here's the form code for the login:
<form action="" method="post" id="loginform">
<input type="text" name="username"/>
<input type="password" name="password"/>
[code].....
WebBrowser1.Document.GetElementById("Windows Live ID:").SetAttribute("value", "Textbox1.text")
WebBrowser1.Document.GetElementById("Password:").SetAttribute("value",
[code].....
i'm using a timer to open a database and drop in a few fields of info, such as date, time and 3 traces.
the timer interval is set to 1000msec, but after its been running for a day or so, i've looked into the data and i can see there are periods where no info has been logged. sometimes its as little as a couple of seconds, and other times its upto a couple of minutes.
I'd like to create a new file everyday for a logging application to minimize size when accessing. I'm after a couple of pointers with respect to when to create the file, and what checks to do etc.
View 2 RepliesI am developing an application with "Visual Studio 2008" (in language VB.NET, Framework: 3.5) with data server as "SQL SERVER EXPRESS 2005".
i have one table with name [fyr] and it contains two columns 'fyid' (integer) and 'fyear' (nvarchar(50)).following queries are showing exception as "No data exists for row/column"
Dim cmd As New OleDbCommand("SELECT * FROM fyr WHERE fyear= '" & DateTime.Now.ToString("yy") & "-" & DateTime.Now.ToString("yy") + 1 & "'", Connection.Instance)
Dim cmd As New OleDbCommand("select * from fyr where fyear = '12-13'", Connection.Instance)
Dim bdr As OleDbDataReader = cmd.ExecuteReader()
both queries above has same result.but all these queries are working if executed directly in "SQL SERVER Management Studio" and showing the expected results.and connection is in open state all other queries in the project are executing correctly and successfully.The table has the data like this:
fyid fyear
1 11-12
7 12-13
It is possible to catch an exception and throw a new exception which wraps the first exception as an inner exception: [URL] Also, if I call a function and it throws a certain error, but I catch it, will the calling code's catch handler execute? If so, and it is of a higher exception type, is this not wrapping the exception? eg I can throw exception ex of type IndexOutOfRange, log it but rethrow, catch a higher up exception and do something, or I can throw a new exception and wrap an inner exception like:
View 1 RepliesI'm trying to create a Server/Client Sync scenario for my application using Sync Services for ADO.NET specifically the LocalCache custom tool which sets the whole thing up for me.My server DB has 5 Tables, all of which are being synchronized to the client application, which now has a SQL Server Compact DB with the same schema as the server DB. I have a dataset with some custom queries that I use to connect my app with the local database.So far so good.However in my application when I try to fill one of my tables with the table adapter on my form (the default "fill" method) it gives me the following exception:No mapping exists from DbType Object to a known SqlDbType.
However, if I continue and do the fill again, IT WORKS without a problem.
Try
Me.WTSUsersTableAdapter.Fill(Me.WTSMainDataSet.WTSUsers)
[code]......
My application scan through the excel files and generate a report having count of Activex controls in each excel file. But while running the tool from client machine we are getting an error on opening the file (for some file not all) and the files are located in the sever side, as follows:
"the rpc server is unavailable (exception from hresult : 0X800706BA)"
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
View 2 RepliesI want to make a basic winsock chat server and client, and I just need to know the basics, like.How do you determine where to send the data?How do you determine where to receive data from?How to actually send and receive the data?I just don't want to read from a website that has a lot of extra information. I just want to start off with the basics so I can actually learn.
View 2 Repliesi'm using socket programming in vb.net 2005 and make a Server/Client windows application and it used in the network to multi user chat server and havent error and it work , but one BUG in server app : the Server app. work currently until the number of clients more than 30 and then it crashed . and error is "socket.exception" . now tell me what to do ??? it's very very important to me because the number of server's CRASH in on day more than 10 time and i end it and then run again and it's not good for my job .
View 5 RepliesI am getting an exception when I run the below VB.NET code to validate a user..The exception says that "Incorrect syntax near variable user" where am I going wrong ?
[Code]....
i'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
View 9 RepliesMulti-User Chat Program (Server & Client) with Main Server?
View 1 RepliesCase : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
I have simple code that connects to Sql database... (well it doesn't)
VB
Dim objConn As New SqlConnection("Server=localhost;uid=***;pwd=***;database=***")
objConn.Open()
ERROR MESSAGE: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 the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)But looks like something is wrong with "localhost" thing. Any help? Where can I get name of (my) server?
We are currently using Access 97 as our database. This resides on the remote farm server (which is a Windows 2008 R2 server). We are using a front end vb6 exe which accesses the back end data.Occasionally we are getting corruption to our database and we have to make sure everyone exits the software to allow us to repair/compact it. There are 2 physical servers, each running 2 virtual machines. When the user logs onto the farm using RDP, they go to one of these 4 virtual machines.We are getting all kinds of corruption, some where # characters have been inserted into the top of one table, some where the indexes are corrupted, and some where access needs to repair the database.
View 1 RepliesI'm getting desperate here trying to find the problem, and I don't know where to start looking for it.
Here are the symptoms:I've noticed, that when a user logs on in the morning, he is then immediately logged off, then when he logs on again, everything is fine and he can work on the site.
Every once in a while, when the user clicks a link, the page takes a lot of time to load, but it never actually loads, and the user is thrown to the login page.Also, after an Exception has occurred in the website, the user is then thrown to the login page. It's as if the exception clears somehow the session.
[Code]...
I was wondering is there a way anyone knows of to "inject" a logger into an application such that it passively monitors the thread and quietly logs processes as they occur without having to do things like: [Code] It would then monitor everything that goes on inside of that method including passed in arguments along with method calls and values passed into those methods, exceptions that occur etc. Has anyone implemented something like this in the past? Could it even be implemented? Is logging in this fashion just a pipe dream?
View 6 Replies