I am having trouble with executing the setapprole stored procedure in VB.NET on a SQL server database. When in SQL Server Management Studio Express, if I connect to servernameinstance as MYUSER, I can create a new query on the MYDATABASE database in there, with these two lines[code]...
View 1 RepliesSo, I'm trying to make a RichTextBox which makes seperate words colored as you type them (like in Visual Studio itself ).The problem is, it's absolutely not working as I want and absolutely not the same as in Visual Studio.It's constantly running over the code each 500 milliseconds (by a timer), bugging the focus and selecting the words you want to be colored quickly.
Also, when you have something selected in the textbox,it constantly unselects when it runs over the code again (tried to fix that, but failed).So, can please someone improve this code (a lot, it's coded really bad ) so the user doesn't notice the words are getting colored?I put the words into an array with a different array containing the colors of the string array on the same index (Sorry for my "not so good" english.. But I'm sure you understand it ).
[Code]...
I'm trying to put together a quick example for another thread about treeviews, and I'm getting a problem when I have a recursive routine, getting the message.
Quote:
There is already an open DataReader associated with this Command which must be closed first.
I'm a tad confused as I am explicitly creating a new command every time through the loop, so I'm not sure (unless its something ADO is doing behind the scenes) how the datareaders higher up the tree are interfering.
Here's my code :
Private Sub SetupChildren(ByVal ParentID As Integer, ByRef ParentNode As TreeNode)
Dim MyCommand As New SqlCommand("SELECT * FROM Groups WHERE ParentGroup=@ParentGroup", m_myConnection)
[Code]...
Obviously I could close the data reader down before calling the next level of recursion but it would prevent the code continuing the loop at the current level when it had finished processing children.
[URL] The jist of the problem is in fact that in the weka.classifiers.trees namespace you have the following members:
namespace weka.classifiers.trees.j48
and
public class J48 : weka.classifiers.Classifier (Member of weka.classifiers.trees)
Lamentably VB .NET in VS 2008 does not seem to be smart enough to distinguish betweem the two (which is odd, because there is no such problem in VS 2003, or in C# in VS 2008) because of it's lack of case sensitivity. Or possibly because of the fact that ikvmc emits an assembly compiled for the 1.1 run time... I'm not sure. I'm also not quite sure how you would resolve this particular issue and given the time sensitivity of this project I do not have the time to learn C# or Java to an extensive degree.
I am using My.Computer.Network.UploadFile(arg1,arg2,username,pass) & sometimes it returns an error to me about not being logged in?I keep using IE & such to visit the ftp'd pages & even login & logoff the ftp site server at times, but seemingly randomly it will fail, even if I use try catch statement, it seems to keep wanting to fail till i go back to IE & go to a webpage on the server or log back in to the account management through IE.
Should it not be authenticating & working correctly each & every time regardless unless the server can't be reached? Why is it wanting to fail SOMETIMES when closing these webpages/logging out on IE only, why is this seeming to have any bearing on this failing in VB.
I have a series of WebRequests in my app all formatted like this
Try
request.Timeout = 30000
' Get the response and read it to the end [HTML of a page]
[Code]....
After roughly 250 iterations of about 5-6 WebRequest per iteration, the app hangs and starts hitting the WebException "The remote name could not be resolved: 'hostnamehere' ". WebPages also don't load through my browser when this happens, I have to close the app for my internet to work again. This app is multithreaded and I was testing with 100 threads (in a threadpool, MaxThreadCount set to 20, addressof the sub which performs the WebRequests). A test with 20 threads yielded identical results - Same WebException also right around 250 iterations processing the same sub. I have tried setting the ConnectionLimit of the request to the thread count with no luck.
What am I missing in the code below? I am getting a failure sending email message.
Private Sub sendTestEmail()
Dim EmailBody As String
EmailBody = "This is a test *****************"
[Code].....
I am using Web Application Deployment for publishing on IIS. At first I have converted my website to a web application. My application compiles and build fine on my VS2005. But when I try to run it via CC.net. It comes up with a 100's of errors. Following is the list of someof the errors that keep repating in the same file.
errorBC30284: function 'GetCannotChangeMessage' cannot be declared 'Overrides' because it does not override a function in a base class.errorBC30451: Name 'GetAndChangesCanBePerformed' is not declared.errorBC30456: 'GetStatusMessage' is not a member of 'Object'.
why my build is failing with these errors. As functions are overridable in base class and also names declared
Quick question: I'm trying to parse dates in the following format to their equivalent DateTime data type, but for some reason it's failing. The string format is: 28/May/2009:17:43:04 +0000Or: dd/MMM/yyyy:hh:mm:ss zz00Here's the code I'm using:Dim provider As New CultureInfo("en-US")Dim d As DateTime = DateTime.ParseExact(value, "dd/MMM/yyyy:hh:mm:ss zz00", provider)
View 2 RepliesConvert.ChangeType fails when converting from nullables. The internet solution appears to be first doing a check if the conversion type is a nullable. However, in my code the nullable check is failing:
Dim nulltype = GetType(Nullable(Of Double))
Debug.Print(nulltype.GetGenericTypeDefinition.Equals(GetType(Nullable)))
This returns false for me and I don't understand why. The real-world situation is that the
[code].....
I have a function (GetData) that parses a SQL string, makes a connection to a SQL Server and dumps the result to a DataTable. It works perfectly on a series of SQL calls I have. I have new query I have added and now the function balks at the adapter.Fill(table) call. I do not understand why the call fails. The SQL portion works fine when run directly against the SQL database (Management Studio). I am thinking the fuctions not capable of dealing with the subquery somehow, just not sure why.
Bindingsource4.DataSource = GetData("SELECT QTY,ITEM_NUMBER,DESCRIPTION,(Select STATUS_TEXT From ITEM_STATUS_LIST Where STATUS_VALUE = Line_Items.Status) FROM(LINE_ITEMS) JOIN PURCHASE_ORDERS ON
[Code]....
I am trying to test for the existence of a file on a web server using the GetFileSize method.
When I use code I found at BOL, the code never finds the file. It always returns a 550 code.
Howver, if I preface the code with a Request to get a DirectoryDetail listing, then the GetFileSize method works fine.I must be opening something and not closing it. Whatever it is, is then available to the GetFileSize method. But I cannot figure this out.
[Code]...
I created a simple service that does some inventory and records the data to a MySQL server. The service starts just fine when told to from the services administration panel. However, it will not on computer bootup. I get the famous error.
The InventoryService service failed to start due to the following error:The service did not respond to the start or control request in a timely fashion. I've read that logs can be a problem, so I disabled the autolog...but that didn't solve any problems. I believe it has something to do with the user not already being logged in and attempting to connect to a remote database. So, I added a function to check for internet connectivity before executing any inventory methods or SQL queries. This did not fix it either.
EDIT: I also am receiving the following error in the administrative logs. I create the service dependant upon the Tcpip service, but it still fails.A timeout was reached (30000 milliseconds) while waiting for the InventoryService service to connect.
We have a legacy setup that creates pdf's on the fly based on client info. I can follow everything through where the process gathers the info and everything runs normally, until it gets to the doc.Form.FlattenFormFields then it goes in to limbo. I've captured the base64binary string and it tried to use that to convert to a pdf with no luck also.
View 1 RepliesI'm using the ASP.NET Membership provider and using the Password Recovery control to reset the user password if they forget it. On the whole it all works fine, but with one catch when it comes to validation.I have expanded the PasswordRecovery control out to use the template feature to customise the appearance, which is all fine. I have set the user lookup error handler using:
OnUserLookupError="PasswordRecovery1_UserLookupError"
in the opening tag and if I load up the page, type in some junk name and click submit this fires as expected, in all browsers. The snippet of VB code makes an error div visible and sets some text.However, if upon loading the page for the first time I type a duff name into the username box and hit the enter key to submit the form, in Internet Explorer (version 8), the UserLookupError event fails to trigger. It triggers just fine in Chrome or Firefox, just not in IE. I know it's not a focus issue on the form, as I can see the form is being submitted.If I click the submit button first, then following that hit the enter key it does fire, it's just that first time it doesn't, and only in IE.Also to add that if I set breakpoints in the VB code to check to see if the page is being submitted, I can see the Page_Load event fire when I hit the enter key, but not the sub PasswordRecovery1_UserLookupError.
I am having problems calling a Com object that I created under Visual Studio 2005 with Standard ASP I registered it using regasm.exe.Below is my code (VB) . have tried creating the object two ways.What am I doing wrong ?
Server.CreateObject("TestCom2.TestFunction") and
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
[code].....
I'm using VS2008, targetting framework 3.5..Every time I reboot the PC, I open up Visual Studio, play with my code a bit, then hit F5 to debug it. I play around with my code some more, then debug again, and end up with the following problems:[code]The previous ten items in the error list are all Warnings, and they've all been in the project for forever, so I don't think they are the issue, here.What is the issue is that Visual Studio refuses delete/copy the XML file, and so will not run. I have to shut down the IDE to fix the issue.
View 11 RepliesI have a generic list that I'm removing items out of using List.Remove(Object). I have been removing items but whenever I get to the fifth item I'm removing it fails and does not remove it from the list. It doesn't seem to matter what I'm removing but everytime I try to remove five items it fails on the fifth item.
View 4 Replies[Code]...
And have been trying things, but haven't found how to get it fire. At run time when I look at the value of the @Appid paramter it has the first row's value so it doesn't appear to be that.
I've got a webservice called Converter.asmx and I've just noticed that on the remote server I basically can't connect to it. The error that I get: "No connection could be made because the target machine actively refused it 127.0.0.1:49792" and the error occurs where I'm calling the web service (second line below).
Dim webservice As New localhost.Converter
results.InnerHtml = webservice.ParseData(txtInput.InnerText, options)
On my localhost it works fine. How can I change the webservice so that it'll work on the remote host as well?
I am working on a Tag system for a news page designed in ASP.NET. For the system I require a TagExists method to check for tags within the database. The stored procedure I have written is below.
ALTER PROCEDURE [dbo].[Tags_TagExists](
@Tag varchar(50))
AS
BEGIN
[code]....
I have tried switching the procedure to return 0 if the tag exists and 1 if it does not and it still returns 0 despite the exact same testing conditions. I have also returned the actual select query and it has complained of the Tag "news" (my test item) not being an int on execution showing the select itself is definitely properly formed.
I've just been forced (by hurricane Irene) to shift from XP and Access 2003 to Windows 7 and Access 2010 with no time for testing or evaluating changes.All our databases are still Access 2000 format.Our offices were flooded and our servers got moved around, though they're all still named the same things, and in many cases things are working exactly the same.However, I have a database that I can't connect to.It's an Access front end that links to tables in an SQL Server 2005 back end.When I start up this particular database the first thing it does is fail when running code that had been put in to set up ODBC connections when one didn't exist on the computer that was trying to access the data.[code]I didn't write this code.
View 6 RepliesCode:
dim Insert as string="insert into acaps(AppId,activity_dt,activity_cd,process_state,UserId,SeqNbr,LocCode,comments) values (@AppId,@activity_dt,@activity_cd,@process_state,@UserId,@SeqNbr,@LocCode,@comments)"
Dim x As New Odbc.OdbcDataAdapter(selectQ.ToString, DirectCast(Me._Cn, Odbc.OdbcConnection))
If x.InsertCommand Is Nothing Then
[code].....
And have been trying things, but haven't found how to get it fire. At run time when I look at the value of the @Appid paramter it has the first row's value so it doesn't appear to be that.
My program prompts the user to save info upon exit. If Yes is clicked > Program closes. If Cancel is clicked > Program stays open.
[code]...
The above works fine, also this works fine (In the sense that if Yes or Cancel is clicked the program wont close):
[code]...
How can I prevent the program from closing while using a NotifyIcon in this way?
I don't know what is wrong with this code, but it is not detecting when there are no items in the listbox. It ALWAYS returns that there is something in the listbox, even when there is not and keeps erroring on the line of code in BOLD.[code]
View 1 RepliesOutput Parameter For Stored Procedure Failing?
View 2 RepliesWhy does this give variable A the value of zero (instead of setting it to nothing)?Dim A as double? A=If(2<3, Nothing, 6)
View 11 RepliesI've got a VB2005 application written by a previous coder. I had to move it to a new windows 7 box, since the xp box it was hosted on had catastrophic hard drive failure. It worked fine on the xp box, but it fails on the windows 7 box.
More specifically, I've tracked it back to a specific subsection. It uses the Process library to start pscp, the putty scp command line tool. It has a timer to wait 400 seconds for the process to close, otherwise it stops the process and reports an error.
Unfortunately, on windows 7 it doesn't seem to even start the process, because it does not wait the specified 400 seconds, nor does it report the other error it would give if pscp did start, but failed. Is there a compatibility issue with the process library, or is it some configuration issue?
Update:
Alright, after more testing I've determined that the subprocess is getting spawned, but the parent is not waiting for it to exit.
it seems the VB code myProcess.WaitForExit(40000) is not actually waiting until the process exits. Is this because it can't 'see' the process and believes it has exited?
Oddly enough, I've worked around this issue, but it's still annoying me. I worked around it by sending too-long writes, with padded zeroes; the code works but sends a few hundred unnecessary bytes. Specifically, I need to send exactly 992-byte packets instead of 7 or 19-byte packets
View 2 RepliesAfter adding a string to the program from the resources the build always fails, and removing the string and the code to load the string does not solve the problem, as the build still fails. We've been using multiple versions of the program since this started happening with the most updated one, and adding the string is what started the failure in building even though we added other elements (like an exit button) and other forms without it failing. With the one that started with the build failures we've tried it on all types of computers and it does not manage to build on any of them, even one's with a new installation of Visual Basic Express 2010.
The exact line added that apparently makes the build fail is:
PictureAndInfo.infoBox.Text = My.Resources.StegmeierBreweryString
And the string added to the Resources isn't anything unusal compared ot the rest we have but it is this is:
The Stegmaier Brewery business began in 1857 when Charles Stegmaier first set up a shop. Since then the Stegmaier business has grown greatly. The size of their operation has grown from the original shop to the large building pictured to the left (opened in 1863 and purchased from Stegmaier in 1978). The Stegmaier Brewery Company was purchased in 1974 by Lion, Inc. and Stegmaier Beer is still produced today by Lion, Inc. and remains a popular choice among consumers.