I have a SQL 2008 Express DB and am trying to run an insert query. But every time I run the query I get the UnresolvalbeObjectException.
Dim db = Simple.Data.Database.OpenConnection("Server=localhostSQLExpress,Database=Foo;Trusted_Connection=True;")
Dim item as new with {.Name = "SMITH",
[code].....
I'm working with a vb.net 2005 project that i converted from vb 6.0 last year. It's working fine in windows xp, but on vista and windows 7 i get an error saying 'Insufficient security permissions to set the system time.' Can you think of any way to replicate this error on windows xp? I'm trying to get a windows 7 box setup at work but I was wondering if there was anything I could try with xp in the meantime.
View 9 RepliesI need an extremely simple regex pattern that matches anything within square brackets [].
Example:
This is a [test] text with [some] [examples].Required results: [test], [some], [examples].I don't want to get rid of the brackets, they should be included in the result (that should make it easier, right?)
If possible I'd like to exlude results that have whitespace in them, so things like [this string] should not be matched. If that gets too hard (probably not, but hey I can't even manage this :S) then I don't really mind, I can always check if the result contains whitespace myself.
I tried a lot of examples I could find online and ones that I could think of myself but none work. Note: I've been testing with the Visual Studio Find dialog (checking to use regular expressions obviously), maybe that's where the problem lies, because I don't really understand why some of these don't work...
Anyway, first thing I tried was simple: match the two brackets and one or more characters in between (that should be a +, right?)
I try to delete my Temporary Internet Files and I do it by using the command "kill()", but I get an error: "No files found matching".
View 5 RepliesI am currently learning about Independent Sub Procedures and am having trouble Calling the Procedure back to execute in the program what would i put within the parameters near the Call function? Simple application get two numbers from two different textbox's and multiply those numbers and put the output into a label. Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Right Here
Call CalcTotal()
[Code]...
I am using VS2008 front end and MySql 5 database When I attempt to run this sproc I get the following error message:"Procedure or function 'Test_sp' cannot be found in database 'EVOLUTION'." Yet the Stored procedure is definitely there.I have tried changing the name of both the sproc and in the sub below but it makes no difference.This is the first time that I am trying to use a sproc and I can't get it right.All other communication to and from the database is fine.
Dim Cmd As New MySqlCommand("Test_sp", Datacon)
Cmd.CommandType = CommandType.StoredProcedure
Cmd.Parameters.Add("@Acl_Key", MySqlDbType.String).Value = "ABC"
Cmd.Parameters.Add("@Acl_Desc", MySqlDbType.String).Value = "My Description"
[code]....
on a new project - windows form app i would like to bring a simple stored procedure from a server ( with credentials ) with one parameter.
the stored procedure is on the : "SERVER" "database" "sa" "sa" and it looks like this:
sql
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[Code]....
also if i could select the client name from a drop down list would be verry nice. the select for the name is : "select name from clients"
The results could be exported into excel or a screen. ( after selecting the client in the form , another button for export )
I have a specialized string dictionary of (string, string) (_RulesAndTheirDescriptions) that contains the name (key) and description (value) of methods in a given class. I currently do the following query to search for a match on the key or value and then bind that to a grid.
[Code]...
Does anyone have a list of OleDBTypes and how they match up with MS Access and SQL Server Data types. I would like this to be able to better write code for my parameter collections. Plus when looking at all the options availible with intellisense when programming in vb2008 v.s. SQL datatypes, there are some not so obvious choices.Here is the list I get from VB2008 using Intellisense:
OleDb.OleDbType.BigInt
OleDb.OleDbType.Binary
OleDb.OleDbType.Boolean
[code]....
I am trying to match between two datasets. Based on some predefined criteria the matched items are stored into a datatable. I am using the code below: [code]I am not sure whether there are more effective way to store the matched items in a new datatable since the method I used here requires three loops which is a lot of processing time.
View 2 RepliesCurrently we are using a VB script macro created in word to create some fairly simple forms based off of data entered on a data entry form. I am very new to VB, and I have been able to create many applications using forms, but I have absolutely no history creating reports. I have been reading up on the reports, and it looks like they are designed to use with data sources like tables. I merely want to take either data from the entry form, or from data derived internaly from processing the user entered data and populate a defined report "form". I have been searching, but there is so much on printing reports, that I feel overwhelmed. I am not looking for the exact answer as much as a link or place to look for a sample for what I want to do.
View 2 RepliesI am getting the above error when I attempt to run setup.exe as a non-administrator on Windows XP (sp3). This is for an application I created, and I would like to know what permissions the users need to install the application and updates. I am trying to understand the security issues when installing a vb.net desktop application, the .NET framework, and other resources such as the visual studio crystal reports engine. Any good resource which explains how this works for different operating systems and privilege levels?
View 6 RepliesError 1 Problem generating manifest. Insufficient memory to continue the execution of the program. Facsimile_XP
View 4 RepliesMy Application (Vb.net, Access 2003/2007) is to scan Access Database files for activex controls and to generate report accordingly.Problem:
Getting an error like:"Insufficient memory to continue the execution of the program."
The above error occurs while scanning for older version of Access files like prior to office 2000.
And the line of code where I get this is as follows:
Dim oForm As Access.Form Dim oAccess as Access.Application oForm = oAccess.Forms(objForms.Name)
But it opens the file and form as well.
Whether it is possible to read the file (Access Forms and Reports) or not?
I am processing a local message queue and every now and then getting an "Insufficient resources to perform operation" error message when there is over 2GB RAM free.The queue is very small (often only a couple of items (if that) and never exceeds 50 items), with the items themselves being just a very basic class that consists of a filename (as a string), two integers, two booleans and one enum (i.e. very little actual data)In order to check the size of the message queue, I have a timer that ticks every 5 seconds, and when it does calls the following code:
Private Function GetQueueLength() As Integer
Dim QueueLength As Message() = ProcessQueue.GetAllMessages
Dim Length As Integer = QueueLength.Length[code].....
Word has insufficient memory in my program and I am trying to find out why. My script works great and now it is not working. I am getting the error, "Word has insufficient memory. You will not be able to undo this action once it is completed. Do you want to continue?" The code that breaks it is:
wordApp.Selection.Font.Bold = 1;
wordApp.Selection.TypeText("var text here: ");
wordApp.Selection.Font.Bold = 0;
[code]....
I have a project in VB 2008 Express, and I made a foolish mistake of assigning a string setting (ie my.settings.mystring) a very long string (the contents of a 115kb text file). After that the compiler threw an error and closed the IDE, now everytime..I open the project to try and get rid of the string the IDE throws an error 'system out of storage...' (my laptop has 4GB memory, ~100GB free hdd space) and promptly closes.
View 3 Replieshow to avoid this error?"Insufficient memory to continue the execution of the program "i always got this error when i trying to execute or run my program.. it come to the point that time error will appear.
View 2 RepliesI have a form in where I work with some data readers. One of my readers only gets the information from the first row. When ever I try to get something from the second row onwards I get an error saying that "no data found in row". I am using "ExecuteReader" not "ExecuteScalar". I cannot understand why I get this behaviour. Here is the The reader that gets me this error is reader2.
Dim reader As OleDbDataReader
Dim reader1 As OleDbDataReader
Dim sql5 As String
Dim SQL As String
sql5 = "SELECT * FROM Services WHERE ServiceID = " & Me.ServiceIDTextBox1.Text & ""
[Code].....
IM making a form to hold information about Cars.I have the abbility to save the Cars to the file. THis does it perfectly..... well it saves the car to the file, It not saving it in a logical order but thats another problem.BUT, when i close the form and restart, the form doesn't seem to want to know that it exisits.
View 5 RepliesI recently upgraded to developing on a 64bit windows 7 system from 32 bit xp. I am using VS2010, same install from the old system.My apps have always targeted a x86 systems If I change this to target x64 on my new system the app can no longer connect to my database (Progress).
View 8 Repliesjust want to ask what would be the possible code if there are no records in database.. example when you click search.. then there! well.. here is my code
[code...]
Problem regarding in using Listview in vb.net. I can manipulate some flow like searching and selecting data coming in database (SQL) but my problem is that i need a message thtat will pop up that there is no particular data in the database where ever i find a data.
View 4 RepliesWe have an VB.net application that is being moved from one box to another. It runs great on the old box. The new box is configured the same as the old one but is on newer hardware. When I run the application on the new server it complains that the adobe toolkit that we use can not be found.
View 2 RepliesI am using VB 2008 with Oracle8i Database
Dim rsResult as new ADODB.Recordset
Do While Not rsResult.EOF
...........FILLING mshflexgrid.
[code]....
During MoveNext, i am getting this error, -21474667259 Insufficient base table information for updating or refreshing There is a problem in formating, but it showing error on recordset....why..?
I have a problem connecting with mysql server 5.1. I tried several methods and been a lot of googling too but can't find the solutions yet. Here's the installed component btw[code]...
View 2 RepliesPrivate Sub setView()
With lvwLogs
.AllowColumnReorder = True
.FullRowSelect = True
.GridLines = True
[code]...
I am getting the same compile error for the forms with setview. I am thinking it concerns with listview. It highlights the public sub setview().
when the user search for the username and find it in the database it will be seen in the datagrid.. but my problem is when the reader does not found any data with the same username it will give a message that user is not find,,i use the command.executenonQuery and also the command.ExecuteScalar in my if statement.[code]
View 3 RepliesI have an Entity Data Model with two entities in it "Roles" and "Users". There is a navigation property from I have a EntityDataSource and a GridView. The EntityDataSource points to the Users entity and has an Include="Roles" parameter.I've added a BoundField in the GridView that points to RoleName, a property of the entity Roles. However, when I execute the code I get the above error.I have used very similar code successfully in another application. Any ideas why this isn't working?
Here is my EntityDataSource:
<asp:EntityDataSource ID="EntityDataSource1" runat="server"
ConnectionString="name=pbu_checklistEntities"
DefaultContainerName="pbu_checklistEntities" EnableDelete="True"
EnableFlattening="False" EnableUpdate="True" EntitySetName="Users" Include="Role">
</asp:EntityDataSource>
And here is the BoundField:
<asp:BoundField DataField="RoleName" HeaderText="Role" SortExpression="RoleName" />
Let me know if I use the wrong words when discribing my situation, I am a student in college learning VB. I have a a datagrid bound to a table built in sql server 2008. The search feature works like a charm but I want to display a messagebox error if no rows match the search criteria. Here is the code I have come up with:
[Code]...
