I'm having some issues with a game I've been writing for several years. It's an on/off project and recently I purchased a new computer and formatted my old computer so all of my installations of windows and visual basic 2005 (express edition) are fresh. I'm getting the following error:
View 11 RepliesIs it possible to add, edit, view and delete records using a file only (instead of a database) and .Net 2005 (VB.Net/C#)? The concept is that a file that'll work more-or-less like a database. One can add, edit, view, delete and query data to and from the file. The file, either cannot be opened directly or data inside the file should be in some encrypted form so that even if the file is opened no one can comprehend it. Data inside the file can only be manipulated by a front end application i.e. .Net 2005.
View 1 RepliesI have an issue with am access database source located on a remote computer.I tried using ADODB to access it, it works, but when I change( update insert or delete) the database on the remote computer, the changes is not reflected in my application
View 1 RepliesWhat i would like to do is change the color of a column in excel. I cannot seem to get the right command string to accomplish it.
View 2 RepliesI have am using an XBee ZigBee wireless module to communicate with a project of mine. I currently have it set up to the point where I can open a hyperterminal session to COM 4 (which is the usb com port), and recieve the data that is being sent via the microcontroller on the other side of the wireless link.
I would like to make an app that takes the data and puts it in to a more user-readable format. (Via VB 2005) So far all I have come up with is some problems. It doesn't seem like I can use the built in serial port tool to access a "virtual" com port. From the following link:Quote:
Note You cannot use the Microsoft .NET Framework classes to directly access other types of ports, such as parallel ports or USB ports.[URL]..Do I have to use a "COM port redirector" to make it seem like a real COM port? Or is there some easy way that I am not thinking of?
I have 10 threads each using the same sub to do work. This sub is calling a function to save the results. How are the threads accessing the sub? Is each one getting a fresh copy of the sub to do its thing or are they using the same piece of code and need to wait for each other to finish processing? I don't get any hits when searching for such a specific scenario. I am wondering because it is about using sockets (usually lightweight stuff) to retrieve a resource and the cpu is working at 100% all the time. Still it is very fast, 900 internet queries finish in about 3 minutes.
View 4 RepliesI am trying to programatically use my SQLdatasource in my code behind so that I can select a certain field from a table based on the selectedindexchange event of a listbox control on my form. I have one datasource already set to the listbox control but i want a seperate datasource to select a field based on the value of the listbox. I declared a new datasource sqlDataSource2, set the connectionstring to the same database/table and i have the following line set for the select statement
View 1 RepliesI have been doing some research into accessing devices on a USB port and it's kind of helped, but not really. From what I understand, I can use the IO.Port namespace to access a device on a USB port (usually). Let me know if this is incorrect.
First, I made a simple program that looped through the ports available. I get COM1 and COM3, but I have 4 USB ports. Where are the others?
My
Dim comm As New List(Of IO.Ports.SerialPort) 'list of comm ports
For Each PNstr As String In IO.Ports.SerialPort.GetPortNames() 'get a list of Com Port Names
[Code].....
I have a small databse program. Form1 uses the Private Sub OpenToolstripmenu to Openfiledialog box and creates a connection and adapters. I need a second form that will access the same connections and adpaters what is the best /correct way to do this? Also other sub functions on form1
View 8 RepliesMy problem is that i have a usb-to-serial device which creates a virtual serial port ( Com 4 for example )on the computer i need to connect to it and get the data stored on it I already have worked out how to use the System.io.ports to connect to the port ( baud rate, stop bits, parity ,ect) and it connects to the usb fine. But once the connection is open i don't know how to retrieve the data. Everything i have tried relies on events. But as the usb does not send data i don't know how to access the serials memory.
View 3 Replies"Getting a list of system tray icons/programs has been a thorn in my side for the past year can get the list as long as explorer is running, but the second explorer is closed, the list will not populate. I'm frustrated beyond belief that I can't find the proper API calls to get the information. If anyone knows how to do this, PLEASE share it here!! I know it is possible, because other shells do it. -Ray"
View 9 RepliesI'm debugging a VB app where I'm using a comm port attached to a bluetooth radio paired to another bluetooth radio in order to communicate with a remote barcode scanner. The pair of bluetoooth devices basically work as a serial cable replacement. Sometimes it works fine, but after a while I get an UnauthorizedAccessException message which breaks the program (see attached jpeg).
I only get this when I use the radios and not when I use a direct cable. I wonder if it has something to do with other bluetooth devices nearby trying to communicate with mine. I've used the .NET Framework 2.0 Confuration tool to adjust the zone security to give full trust to MyComputer, so I don't think it has to do with security, but I'm really going beyond my area of expertise here. I don't know what's going on.
[Code]...
I have to make some automatization on a web server, I use Visual Studio 2005 Visual Basic Windows Console Application. I want to make a load/performance test of the web server, so I open several Internet Explorer instances, and I login the application, that is not a problem. But after that I have a mess on the page and I cannot make any more automatization...The composition of the page after the login is like this: I have the default form, another form and a multiple data window(mdw) controller, which dinamically can switches the forms on this part.
The problem is that I don't know how to access the controls of this mdw forms. I couldn't find much about this mdw controller and I am not an expert.
My code is here:
Imports System
Imports System.Diagnostics
Imports System.Web.Ui.Webcontrols
[Code].....
I am currently working on a project for school. I have the project all laid out in my mind and everything but there is one thing that stops me. I can not access the data from the database itself ...
(detailed info)
I am using an AMD Athlon x64 bit processor with a windows vista 64 bit operating system. I am writing the program on visual basic 2008 express edition. When I open up the visual basic 2008 express edition and create a new project the first thing I do is go to the view menu and activate my database explorer. I connect to the database in question through the database explorer. The database I am connecting to is an access 2007 database (ive opened up the access 2007 files and they do open and display information properly, in otherwords, they do work) I then put in a listbox and use the following lines of code in a form load event to both A) create the datatable and B) automatically fill the listbox with the database info.
Dim dt As New DataTable()
Dim connStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=MEGACITIES.MDB"
[Code]....
When I test the program the listbox does not fill up with any information from the MEGACITIES access 2007 database. Ive tried connecting to the database by establishing a connection through the datasources window. Ive tried establishing a connection to the database through both the database explorer and data sources window. No matter what I try I can not get that information accessed.
Im almost confident that this has to do with my processor being 64 bit.
I have a table called Cashiers. In that table are three columns: the primary key, badge and pin.
The user inputs the badge number into, let's say, textbox1.
I want to locate that row and store the corresponding pin number into a variable called pinVar.
This way I can compare it to the input received when it's time for them to enter their pin.
Is somebody having problems accessing a sql database in windows 7 64 bit?
View 5 Repliesi started using VB 2008 recently (with perl background, its a big leap) and having a problem with database.i am trying to access a database that is attached to a different form. i managed to get my code to work if i was writing on the same form.example of code that will work just fine Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
[Code]...
i'm using
Public con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Tramsco\Tramsco\payroll.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True")
as my connection string and when i run the .exe from the other computer to access the database on the host, it gives me this error:
An attempt to attach an auto-named database for file C:\Tramsco\Tramsco payroll.mdf failed. A database with the same name exists, or specified file cannot be Opened, or it is located on UNC share.
but when i use the computer where the program is, i can run it with no problem.
Im using vb.net and developed a project of payroll processing i need to access this project from another system which is connected via LAN by which everyone can use it, but i cant get it this is my connection string which im using .
Public con As New OleDbConnection("Provider=203.94.227.70;Data Source=path\pay.mdb")
I want to create and populate populste several databases on my server MySQL. I pretty much know how to handle the data and queries once I have a connection, it is connecting that I don't know how to do. I have read all the help file I can find till I am sick of reading about "Northwind" which doesn't help me a t all. What I need are the three or four lines that establish a connection to MySQL at [URL] I need to be able to establish this connection transparent to the user who needs only to put thier user name and password for the site into a configuration file. Then I need to be able to create a database and give the user access with thier username and password. I know how to create the database but not how to set the username, password and permission.
View 9 RepliesI have saved documents into my SQL Server 2005 database and they have been converted to bytes. My web page is made with VB.NET in Visual Studio 2008 with ASP.NET. The following is exactly what I need to achieve;
1. Allow user select document with a button
2. Select the document from the SQL Server table
3. Allow the user to download this document.
The error I am getting is that Category is set as Byte and it can't be passed through GetDocument because filePath is a String. I think that I am pulling the file path from the database wrong
[Dim Category As Byte() = NothingDim fs As FileStreamDim br As BinaryReaderDim document As Byte()Dim documentFilePath As String
Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton1.Click
myConnection = New SqlConnection("server=ORLA-PCSQLEXPRESS;database=Edpac;
[Code].....
I installed Visual Studio 2008 and Office Enterprise 2007 in my new computer.I made some codes for a data reader to get data from an Access dabase. On the step where it will open the connection an exception appeared which says "Microsoft.Jet.Oledb.4.0 provider is not registered on the local machine".
View 7 RepliesI've just started learning Visual Basic 2008 and I am stuck with accessing a database through VB, I am using the Data Source Configuration Wizard. Everything goes fine until I start debugging, there is no information in any of the fields. However if I use a different computer in the house I can look at different records.
[Code]...
I have a problem with accessing a data file from Access database. Data Source configuration Wizard comes back with a dialoge box saying "Error Message: Could not load type 'Microsoft Visual Studio.DataDesign.SynDesigner.SyncFacade.SyncManger' from assembly
'MicrosoftVisualStudio.DataDesign.SynDesigner.DslPackage,version = 9.0.0.0, Culture = netural,PublicKeyToken=b03f5f7f11d50a3a
My computer is a Vista and it have known to have lots of problem, but not sure if this is one of it.
I developed a small application which accesses a MS access database on my computer using VB.net. I developed the program on windows xp 32 bit. At the moment I am using windows 7 64 bit and the program simply will not run. I get a null reference exception when I try to do anything to the database. I have narrowed this down i THINK to the db provider. I was using Provider=Microsoft.Jet.OLEDB.4.0; and tried using Provider=Microsoft.ACE.OLEDB.12.0;. Neither seems to work. The path to my database is 100% correct. This is the error I am getting:
Null reference exception was unhandled.Object reference not set to an instance of an object.
Like I say the program runs fine on the windows xp machine. If it helps the access database file extension is mdb.
I developed a project in VB.NET..In this project I want to use data from MySQL that is resides in my WEB Server.I can communicate with the MySQL server of my localhost but can not communicate with the WEB Server.In my CPanel I added Host from the Remote Database Access..But I can't communicate with WEB MySQL Server.
View 2 RepliesI am trying to follow this userguide url... to basically build an application that will allow users to connect to my database, from an exe file. I'll try to explain as best i can. The plan is, users will launch an exe file that i have built in Visual Basic(VB) 2010 Express. When they launch the application they will see a 'login screen'.I am following the example guide (see link above), and will customise it once i can connect to the database. For some reason whenever i connect to the database it gives me two errors, the first is if i use the 'debug' mode in VB to test the script (note it doesn't produce any build errors), the second is if i build the application and run it as my users would.
1)Error Connecting to Database:Access denied for user 'mike'@'92.**.**.***' (using password:YES)
2)Error Connecting to Database:Unable to access any of the specified MySQL hosts..The ip address starred out (*) is my local machine ip address.The server is the server in which my Database runs on. 'mike' is a listed user on my 'user' table, the password i use is the password assigned to this user on my table.
3)I've rebuilt the whole VB project, but still no joy, wern't expecting it to as there were no errors generated.
4) I've read, but don't really understand that it could be something to do with my database not being able to be controlled remotely, only locally. I started digging into 'Access Your MySQL Server Remotely Over SSH', didn't really know if i was going completely off the mark, it didn't mention needing to do any of this in the guide i've been following, but just a thought. It might be the case as i've tried to access my database through a programme called MySQL Administrator. I punch in the host,username etc and connect to my database, for some reason it won't allow me to add new users, could this be because i can't control my database remotely? Would this stop what i'm trying to do working?
5) When trying to install the MySQL.Data.dll file i had great difficulty in choosing one and finding it, adding it to my project using the 'Add reference' in VB. Finnally got it how it should be (i think), installed MySQL.Data.dll Ver 6.1.2.0 into my project.
code to access SQL Server database in connected and disconnected mode through ADO .Net.
View 4 RepliesI was reading from a book, and there's a way of creating database and accessing its tables using tools available in IDE. i-e DataSet, BindingSource, TableAdapter, BindingNavigator. Is this the correct way of using database or through the code??
View 2 Replieshow to connect different vb applications to a database server.like accessing data from one database by different applications...
View 4 Replies