Run Computer But Program Does Not Work As It Cannot Access Database
Mar 18, 2012
I made a program that i want to run on computers at school and it utalizes a MySQL database. When i try to run it the program does not work as it cannot access the database. I open the code up on my computer at school and it has errors saying ti does nto recognize the MySQL code as it does not have it in its .Net library. So i try to download it into the library but that does not work. So my question is, will programs using any kind of database not work unless the user installs the needed add on, weather it be a .Net library add on or a java add on for MySQL? That cant be right it.
View 4 Replies
ADVERTISEMENT
Apr 21, 2008
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 Replies
Oct 13, 2010
I have a similar problem posted in the forum similar to this : started learning VB. I am not able to get my example code to work to access an Access database through automation. The author of my book suggested that I might not have the correct Jet 4.0 engine. The specs I have are: MSJet40.dll, Dated 7/14/2009, Prod Ver 4.00.9756.0.
View 3 Replies
Jun 21, 2010
i'm finish to develop a registration system using vb 2008 exp edition. so, i want to connect my standalone system with LAN network. i want to access database from other computer and be use in my system. i'm use crosscable to connect with 2 computer. before this, i'm just change connection string: 'server = ip address of second computer but it's didn't work.
connectionstring = "server=localhost; user id=root;password=123456;database=vrs;"
View 3 Replies
Sep 23, 2009
I have a program that needs to access the files that are open by another program on the computer.When my application comes up I can easily see if the other application is running with the .net Process.GetProcessesByName method
Dim MyProcesses() as Process = GetProcessesByName("AnApplication")
For Each Instance as Process in MyProcesses
If MsgBox("application is running - do you want to end it?", MsgBoxStyle.YesNo or MsgBoxStyle.Question, "Warning") = MsgBoxResult.Yes then
[code].....
The problem is that the Instance.Kill does not allow the application to end gracefully. In VB6 you could use the SendMessage API to send a close message to the application and it would end gracefully - i.e. give the user the normal closing prompt. This just slays the application - leaving any open files in their potentially incomplete state, etc.
View 4 Replies
Feb 14, 2012
I'm trying to access server database from a remote computer in lan-based network using this connection string "Server=192.168.10.2; user id=user; password=pass; database=sample_db" .. but it can't open a connection.. I don't know what to do, I tried searching for this but no luck.
View 3 Replies
Jul 1, 2011
I have created a setup using INNO which puts a Visual Basic 2010 Express program on the computer to update an Access database. It works on my Windows XP computer. On the user's computer, which is a Windows 7 computer, the Access database comes up as Read Only when opened. I get an "Operation must use an updateable query" error in the Visual Basic program when I try to create a record. The database has Read Only checked off in it's properties. But when you open it in Access 2010, it says Read Only at the top. (This computer has Access 2010. The database itself is in 2002-2003 format.) How can I get this database to be updateable on the user's computer? It works on my computer/does not say Read Only when opened in Access 2007.
View 3 Replies
Sep 3, 2011
Can you give me some tools for LAN. I have a Program and im using SQL database and i wll access to other Computer. Im Using Visual Basic 2010.
View 16 Replies
Aug 21, 2009
I have a form that works on my local Machine I created into. I have Office 2007 on this machine. I created the Form with the Excel 12 Reference. I move the Entire conetence of the Project folder to my work computer. Which has Office 2003. Do I need to recreate the form with the Excel 11 reference. I could not get the form to work on work computer. IT has a com error. I am acessing the EXE for the debug folder w/in the Bin Folder.
View 7 Replies
Oct 11, 2009
I opened vs 2008 and used the server explorer for the first time to create a connection to my SQL 2005 db. The solution explorer pulled in all the tables, the database diagram etc. My question is how do I access that database connection and work with it using ADO objects? Do I need a reference to ADO?
View 4 Replies
Dec 21, 2011
add user to access database but it's doesn't work the problem here
SavInto.ExecuteNonQuery()
View 16 Replies
Mar 10, 2011
my save button not work
Private Sub btn_save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_save.Click
[code].....
View 2 Replies
Mar 24, 2012
I know how to make a setup wizard but when I install my program on other computers, I get an error (SQL Error).
What do I need to install on other computers other than .NET Framework and my program ?
View 4 Replies
Feb 4, 2011
i have encountered a problem, i want to access the data coming to the computer from the in-built bluetooth module of a computer on windows platform, this data has been sent by a remote bluetooth module say a by an autonomous device (just like a bluetooth mouse connecting to the computer). The to be sent is in the form of numbers and i need these to manipulate on the computer.
View 6 Replies
Sep 9, 2010
I coded a program to access a Microsoft Access 2010 database. The program is written using Microsoft Visual Studio 2010. I get the error message that the database I'm trying to access is in an invalid format. look at the code below to see what I missed. The error is in the datasource statement.
[Code]...
View 6 Replies
Sep 20, 2010
I have a program where a lot of the required information for it is stored in text files. I simply read this information into large arrays. However, I don't think it's necessary to load all the information each time. Rather, it would be more efficient if I could simply search through a list of items to find the one I need and then use the data from it, or to find a similar name and use it elsewhere.
Would I be right in using a database? And is database programming done in SQL? I have a book on it telling me to use the SQL Server (IIRC), so I shouldn't be doing it in the VB.NET Express GUI?
Here's an example of what I would do:
Hex = 03 00 => dex number 003
Search in file Pokemon Dex Numbers
003 returns Bulbasaur
Check Bulbasaur base stats in the base stats file
etc
So basically I'm reusing a lot of information. I think a database would be best and it would all be internal right? I'm getting complaints about access denied to a text file (since it's stored in the program directory in the program files).
So to cap up the few questions I have:
-Databases are done in SQL and not inside the GUI?
-Databases would load internally?
-I could search a database without having to load it into like an array or something?
View 2 Replies
Apr 20, 2010
This program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
View 4 Replies
Nov 18, 2010
how to transfer files from 1. computer to the computer with the program made in visual studio 2008 (visual basic)
View 3 Replies
Mar 15, 2012
Has anyone succeeded in creating a class library solution/project in VB.net VS2010 4.0 Net Framework for COM to run on WindowsXP Excel 2003. I created a dll which changed specific data in an excel worksheet. The dll worked just fine on the development computer but wont work on any other. I downloaded .NET 4 framework onto the target PCs and used RegAsm.exe to register both the .dll and .tlb files in the registry. That worked OK and the dll is visible as a reference in excel and can be ticked. The error message I get is RunTime Error -2147024894(80070002): Automation Error The System cannot find the file specified.
I also tried creating a Setup and Deploy project in the original development solution but this created just a vbproj setup file which the target PC cannot read (no VS installed), I hoped the project would create an EXE file I could use. Does anyone know any links that describe how to do this type of stuff as most links I have tried are either for Windows Forms projects are are way above my knowledge. Maybe someone out there has already succeeded with this sort of activity?
View 1 Replies
Jul 7, 2009
For those of you that have been helping me for the last two days thank you first of all, my program is now at the stage where i need to have a windows application that the user can then select databases from, and then using these databases information will be put into a second application that will then run a program to compute some data and spit it into a .xml file.
Is there a prewritten piece of code for choosing databases? And then a set format for choosing cells in that data base to be exported into another windows application?
View 3 Replies
Jun 20, 2012
We have to make a modification on the WPFToolkit.dll to add some watermark text. Now, when we install it on some computers (I can't find what's different about them), I get this
[Code]...
View 1 Replies
Jul 9, 2009
Is there any way to use VB 2008 to create an app to work on a computer that does not require .NET 2.0+? If there is no way to install .NET on the target computer, is there any way to write the app in such a way that it works on the computer?
View 12 Replies
Sep 29, 2010
I want to create program in vb2008 express with ms access database. Can somebody help me so i can learn how to program using classes hard coded. I have learned vb6 before but it has a big difference on vb2008.
I have a database named "DATABASE" in ms access 2003 and the details are: Table :
EMPLOYEE(EmpNo, EmpName), DEPARTMENT(DeptID, DeptName), CATEGORY(CategoryID, CategoryName), SUPPLIER(SupplierID, SupplierName), ITEM(ItemID, Itemname), ITEMLIST(ItemListID, ItemID, ItemDescription), INVENTORY
[CODE]...
All the CAPITALIZED name are Table and all items inside the parenthesis are fieldnames. I don't know where to start on working on this RECORDS. I was able to understand visual basic 6 a bit, and i am trying to apply the coding to VB 2008 but all i get is errors. I am hopeless now and i need help to be able to start my programs. If someone can give me a sample code, i think i would be able to trace the line of code to be able to understand it. I am currently an inventory manager on the small company i was working with and i like to organize my record by using database.
View 1 Replies
May 2, 2012
This would be easier if I were able to have the external computer get its own name and just pass it to a web service as a variable, but I'm not able to do that right now. There are a variable number of computers from several different entities that regurarly access a web service on one of our servers. Changing only some VB.Net code on the server and nothing at all on any of those external computers, how would I be able to get their names programmatically in VB.Net?
View 2 Replies
Jul 13, 2011
I have a access database named login.mdb,which has many tables.i want to update table named "try".in tat table i have two fields viz name and rollnumber.i want to update rollnum of corresponding name.[code]...
View 2 Replies
Jul 5, 2009
1) I want my database should save on default location unlike this:
Dim connectionstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Contacts3mycontacts.mdb;Persist Security Info=False"
Since i'm deploying my project on another computer itz showing me an error of database connection.Then again i've to make one folder of Contacts3 in C drive and then itz connecting the database.please let me know how can i deploy my database as default.
2)When i'm deploying my project on server itz not running and the same pfoject is running on different computers.Itz showing me security errors.
View 8 Replies
Dec 28, 2009
How to backup ms access database in vb.net?We're gonna make a system for a certain company but our teacher doesn't teach us at all
View 1 Replies
Jun 16, 2012
I have a windows application written in VB.net. After finishing it I'll setup the program in more than one pc. I want to connect the program in all PCs to one database in another PC using Microsoft Access, and I also want to limit the level of access of the users to the database in my program.
View 2 Replies
Feb 28, 2009
i an encounting this problem that is...my database is unable to access in client pc and its comes out this error: cannot open database "synonym" requested by the login.The login failed. Login failed for user 'SIDNEY-U1KECH4Tsidey'.
View 8 Replies
Mar 30, 2009
I have started a little program which is linked to an access database, and it basically allows the user to input a name and a picture, with the file path stored in a text box and the picturebox getting the picture location from said text box. At the moment I am using the BindingNavigator to go between data. Everything works fine, however, whenever I press previous or next, the picturebox loads up the picture using the file location of the previous datas picture field. How can I tweak this so that when I press next or previous it loads the picture into the picturebox using the file location of the data I am going to, not coming from? [code]
View 5 Replies
