I have just installed Oracle 10g XE,and its ODAC package for .NET.I am making a simple connect-and-get-table app in VB,however,it always throws a "Table not found" error.I created the "Test" table in Oracle Home (the web admin thing) and here is the code I'm using in VB :
Dim oraCmd As New OracleCommand("Select * From Test")
oraCmd.Connection = oraCon
oraCon.Open()
[code].....
EDIT When I try the same query in Database Home,it works.
UPDATE: Found the error to be related to the path. A literal path fixed the problem temporarily. Need to resolve this for deployment though. I am trying to access a SQL Lite table from VS2008 VB.net, using SQLLITE ADO Provider v1.0.66. I have successfully opened and extracted data with this exact configuration to populate the SQL Express DB on a web site.
But now when trying to execute a select stmt to populate a reader I am getting table not found, its the same table I read from earlier. This query works perfectly in SQLLite Expert Pro v.3.3.40.2189. Any help would be appreciated, the connection correctly shows it is opening. I have tried other tables in the same db and other similar dbs. Out come is the same. Its as if the Info Schema is not available to the ADO Provider.
[Code].....
I had a program that was working, then the underlying access database was changed and a few of the field types were changed from double to Decime. I went to the table adapter and tried to reconfigure the the table and adapters, but the underlying code that is generated by VB did not changed and cept the fields ad doubles and I was getting a null error.
I then deleated the table and added the table again using the same sql statements
I now can not view the desing view of the form and get the following error.
"DataMember property 'Specification_SPCUrethane' cannot be found on the DataSource."
How do I remove the binding sourse and detaset from the form so that it will display so I can fix the problem?
I am having major problems with creating my tables and populating them.The problem for the creating seems to lie when I try to create my table named WeeklyUnitStaffRota. I get the run time error 2147467259(80004005) No unique index found for the referenced field of the primary table. This has only started happening as I have been tinkering with my tables to get them to populate properly.I seem to have a problem when I have two columns with the same info but relating to a different college ie two MSC being run at 2 different colleges.[code]...
View 1 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 RepliesCurrently I am using this code to check for Firefox on a 32 bit machine
Code:
Dim Firefox32 As String
Firefox32 = My.Computer.Registry.GetValue _
("HKEY_LOCAL_MACHINESOFTWAREMozillaMozilla Firefox 5.0in", "PathToExe", Nothing)
MsgBox("The value is " & Firefox32)
If the value is found then the above message is fine, but if the entry is not found I want it to display a message like: "Firefox could not be found" instead of "The value is: " What code would make this appear?
[Code]...
I want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
I have a data table whose one column is related to a column of another table. I have a listbox in a form which shows a column (which is sorted by another column value by ORDER clause) of the parent table and other columns are in textboxes. The child table is represented by a datagrid. When I add a new item in parent table and click save, the newly created item is listed at the bottom of the listbox violating my ORDER clause. When I wrote some codes to fill data again after updating, it shows an error message[code]...
View 3 RepliesHow do I copy a table to another table without overwriting the contents of the second table?
View 2 Replies- Where (what folder) is the vbc.exe to be found?
View 2 RepliesSo it's clearly there, and functioning, though visual studios believes otherwise. it's becoming quite the nuisance when I'm dealing with 10+ controls.
Note: This only occurs for my user controls.
In created a small window's form app and when I try to install it on a cpu running Vista I get the following error when I run the app:"the procedure entry point lstrcpyml could not be located in the dynamic link library MSDART.dll"
View 3 RepliesFile Not Found when it's there
View 12 RepliesVS 2008 .NET 3.5 Windows XP I have got an exception in the following code:
<DllImport("user32.dll", CharSet:=CharSet.Auto, SetLastError:=True)> _
Public Function GetNextWindow(ByVal hWnd As IntPtr, ByVal wCmd As GW) As IntPtr
End Function
Private Sub Form1_Paint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles MyBase.Paint
Dim w = GetNextWindow(Me.Handle, GW_HWNDNEXT)
End Sub
I have an issue with the VB IDE My project was working fine.I was adding some combo boxes and adding some code for the combo boxes to the form "iNet_MDI". I ran it in debug a few times to watch it and the next thing I know, I see "Key not Found Parameter name:key" in the Warning list. It says the Warning is on line 369 in iNet_MDI.Designer.vb.When I click on this message, it takes me to line 369 which is "Me.gb_RTO.Font = NewSystem.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Regular,System.Drawing.GraphicsUnit.Point, CType(0, Byte)I can comment this line out and the warning still exists and it still points to the same line.
I have tried to rebuild the project and clean the project.I have tried commenting out alot of the code, but nothing seems to clear this warning message. I can't get to the Design screen to try to remove any tools from the form. An error screen appears in place of the Designer I t gives me the option to "ignore and continue", which does not work.I see the Call Stack here on this page and it says:
at System.ComponentModel.ReflectPropertyDescriptor.SetValue(Object component, Object value)
at
[code]....
" An error occurred while signing: SignTool.exe not found"Vista Utlimate x64 Service Pack 1 Microsoft Visual Studio 2008Version 9.0.30729.1 SPMicrosoft .NET FrameworkVersion 3.5 SP1
Installed Edition: Professional When I attempt to publish my application using the publishing wizard, sign code not checked. I get the error above.Looking back through previous posts, this was a problem in earlier beta releases, but was to be fixed by the final release of Visual Studio.Searching my machine using the search function shows SigntTool.exe is not present on the machine.Frankly it has been a while since I tried to compile and publish a project using click once, but it worked then now it fails. So I cannot firmly blame it on the Sp1 installation, I'm suspicious.How do I make it work??Ed Warren
what are other ways to do ping in vb.net or c# other than the way found here:
Dim pinger As New System.Net.NetworkInformation.Ping
MessageBox.Show(pinger.Send("192.168.0.119").Status.ToString)
Gives me an error, Project dll not found for Trim, Ucase functions. visual basic for applications dll is available, what else could be missing.
View 1 RepliesPublic cnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=K:\Auto\Autonew\automaint.mdb;Persist Security Info=False"
Public Function OpenRS(ByVal S As String, ByVal blnEdit As Boolean) As ADODB.Recordset
[Code]....
I have basic window to enter a service category and description with add, clear, and dashboard buttons. When I try to add a record to the Access database, I get the following:
"Provider cannot be found. It may not be properly installed."
The code and database is on a jump drive. When I run this at work, it works fine. At home I get the above message.
At work, we use Windows XP and Access 2002, at home Windows 7 and Access 2003. The database was saved as an Access 2000 format.
I Have this dll OBIDISC4NET.dll i added it to the reference
Imports OBID
class reads
Public Sub run()
Dim back As Int32
Dim fedm As New FedmIscReader
when i run the program and call the run function im getting error "The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
it only happens when i put "new" without it im not getting any errors it looks like it generates error when i create the instance.
Visual Basic 2010.I just started learning visual basic (im an extreme beginner) and whenever i mess around with creating code, it always gives me this error: sub main () not found in (my projects name). I searched this error up and Microsoft said it was a bug.
View 4 RepliesAfter getting a test WCF hosted in a windows service, I'm trying for another one (practice, practice, practice). I created a WCF service library, added one function. Then created a Windows Service, and added my WCF to the project. Did the rest of the stuff located here ([URL]) Now I'm getting this "Sub Mian was not found in [WCF app]" error when I try to build the solution. I didn't think WCF projects required a Sub Main as they are services and not applications. What am I doing wrong? I didn't have a sub main in my last project.
View 1 RepliesLet's say, I have something like a table in the WebBrowser component, it's not actually a table, because the data organized in flash, but, it's organized like a table, it has like rows and columns. You can see more in the attached file. Can I transform this text organized as table into DataGridView or some another tool that serves as table. like_a_table.JPG
View 3 RepliesI have a large form that is set up from master-detail datasets in Visual Studio 2008.I havene master table with a large amount of detail tables. Several of the detail tables also have detail tables linked.Now I need to add a master table that sits on top of my existing master table making it a detail table.
View 7 RepliesI have a login form that consists of 2 text boxes: txtUser, txtPass. Now these are not bound to any data table & I don't what them to be bound. When a new user enters his user name & password, I want to add these on a data table that has two columns: User, Pass. Data table information: Data Source = Login.accdb, Data table = LoginTable, Connection = LoginCn. I use visual basic 2010. So how do I do this?
View 1 RepliesI created a function that creates a global temporary table to stage data from a excel sheet I need the table to persist for me to map the columns using a form. The table is still there when the code goes back to the sub that calls the function until I call the form where I do the mapping. I am trying to avoid create/drop table scenario with a perm stage table.How can I get this table to persist until the data gets loaded into the perm table?
View 8 RepliesI have this code to edit the datarow of my table adapter but t doesnt update the table. I think i have a missing code that's why but i cant figured it out. by the way im using vb2008 and SQL as my database. [code]
View 3 RepliesI have a database that has two tables in it. One is a table of items (table1) and the other is the table of current items (table2).On form load I need to generate a random amount of the items from table1 and populate table2 with them. I was trying to do something like this:
[Code]...
I currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
I got an error when I tried to save a deleted record in a table which I use to store username and password.
I can delete with no problems but the error message popped up when I clicked on the update icon
My login code is like this
Imports System.Data.SqlClient
Public Class Form1
Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As
[Code]....