DB/Reporting :: Database App On Windows 7?
Jan 15, 2012
I have a database app that I wrote in VB6 a while back that uses Access as the backend. I have installed the app on Windows 7 pc's and all works fine....most of the time.On some pc's I see an issue where if I replace, rename, or even remove the DB, my app (b/c of something to do with Windows 7) still sees and reads the information from the old DB. It seems no matter what I do, I cannot "remove" the .mdb file from the system. As one can imagine, this is making it very hard to replace the outdated db with an updated version. I never experienced anything like this running the app in the XP environment.
View 3 Replies
ADVERTISEMENT
May 14, 2008
1. I have a windows service type of application that first creates a database on the local SQL server (and a table). It then starts putting data into the table.
2. This works fine when running as a normal application but due to permissions, when it is run as a service, it can create a database but then fails to connect to it to create the Table. I understand that because its a LOCAL SYSTEM service, SQL might have problems but why does it let it create a database but not a table?? .
3. Is there anyway I could hard code a USER NAME for this database my application creates and then use it to get in? As it uses an exclusive database, I don't want to prompt the user for an SA account (and their sql may not be mixed mode).
View 2 Replies
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
Mar 30, 2008
I am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 Replies
Sep 20, 2011
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 Replies
Aug 16, 2009
I am using VS2008 using VB. I have a datagridview sourced to a dataset. There are 5 fields mapped to the datagridview, three are read only. I am using the 'RowLeave' event to do some processing.
I am using the 'CellEnter' event to 'SendKeys" a tab in the read only cells. The question is simple: how do I allow the user to enter data into one of the 'editable' cells and change the 'Enter' key into a 'Tab' key, so that the data they entered is in the cell and I tab over to the next 'editable' cell, even if it is in the next row?
View 1 Replies
Jul 30, 2008
Now that my application uses windows authentication to connect to the database, how will I authenticate the username and password that the user supplied? I've read about WindowsPrincipal and WindowsIdentity but still I have not found a way to do this.
View 5 Replies
Nov 19, 2008
I have a typed dataset with table adapters. I use this method because it makes it easier to design the layout of my DataGridView.The problem is I have added a new table to my dataset. When I go to the "Data Sources" list view, I can see the new table.However, if I add a new DataGridView to my form then attempt to bind it to my new data table, the table will not show up in the list of tables for that dataset.
View 1 Replies
May 6, 2009
I'm developing a windows form app in visual studio 2008 express. I'm usin a sql compact 3.5 database on it through the program, several changes are made to database data, and so, i have on form1_closing event, a code to save the dataset back to database, something like:
Private Sub Form1_Closing(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Validate()
[CODE]................
But when i run my program on the debugger, the changes i mkae, don't get saved, are lost...is this a charecteristic of debugger, or is my "saving code" wrong?
I already built the program, and the data is not being saved. how to saving the data ? by the way, all changes to dataset are made something like this:
[code]:......................
View 1 Replies
Mar 26, 2009
I'm using SQL 2008 Express with a multi user VB.NET Windows application. Do I have to add each user to the SQL user account? Does NT AuthoritySYSTEM work? I do not know how this works. So far I have NT AuthoritySYSTEM in the Security-Logins of the Server. But do I have to add it also in the database? In the databse Security-User, I have the following:
[Code]...
View 1 Replies
Jul 22, 2009
I need to programmatically add a row to a MS Database.How is this done?
View 2 Replies
Feb 25, 2011
I don't actually know if I can use any XML file as a database that I can edit and make some changes to it using vb.net 2008 and save them. Because I'm working aboard a war ship and we have a central automatic system to control all the internal communication using standard telephones. to reprogram the extinctions we used to have a MS DOS program and it's so old and now it's totally lost and not found and after a long searching I have found a file that could maintain the extensions and reprogram the system but it's an XML file.
[Code]...
View 1 Replies
Jul 10, 2008
I'm using Visual Basic 2008 Express Edition. What I have is an Access database that will have several tables. What I want to do is connect to the database, enter the name of a table in a text box and query that table. The code that I have now is: [Code] I'm not sure how to modify this code so that tablename = whatever I type in the text box.
View 5 Replies
May 26, 2008
I am using SQL server managment express. I have 4 databases in it and got a bug on my computer which I could not get rid of. I saved these to disk and reinstalled windows, I reinstalled SQL server and I am now trying to add my 4 databases. Can any one help me with this, I can add a new database but not an existing.
View 2 Replies
Nov 16, 2009
I have working on a project to add details to a database. I'm having trouble with the connection string, the code is as follows:
Code:
Public Function AddContactToDatabase(ByVal sFirstName As String, ByVal sLastName As String, ByVal sAddress1 As String, ByVal sAddress2 As String, ByVal sAddress3 As String, ByVal sAddress4 As String, ByVal dDOB As Date, ByVal sPhone As String)
[Code]......
View 2 Replies
Jan 24, 2010
[Code]....
Thought I should probably say im using Windows 7 and the 2010 beta Visual studio
View 1 Replies
Feb 4, 2009
Using VB 2008 Express /Using SQL Server Express/Database name is "StopData"/Computer name is "LAPTOP"?Here's what I have.
Code:
Imports System.Data.SqlClient
Public Class frmMain
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
View 1 Replies
May 18, 2011
below is the coding i want to ask :[code...]
this code is used for login by querying into the database....the logic is like this..it query accoding to the username text box and pass word text box...if there is indeed such rows in the table, then the bacadata.read, else something else happens...i have a few question :
1.is this the right way of login in by checking the row is available or not?
2.is there any enlightment and solution for the appropriate way to login system by using database other than the one teached by my lecturer?
View 2 Replies
Mar 2, 2011
I am trying to use the .net connector within my program. I have got add, delete and update working however cannot get search to work. What I would like the program to do is, you enter a value into a textbox and then press a button. The value in the textbox is searched and then the values in the database corresponding to that value are entered into the other text boxes. This is what I have so far:
Private Sub PrescriberSearch()
pre.SelectCommand = New MySqlCommand("SELECT Name FROM Prescriber WHERE Name =?Name like Name = ?Name")
[code].....
View 8 Replies
Mar 9, 2012
Well my problem is that I have a image stored in a database which is a OLE Object.
My Problem is that I am trying to view the database in Vb (windows form) but the image does not appear.
All I can see is a small red cross where the image should be.
I have tried both Datagrid view and Detail View.
View 2 Replies
Nov 12, 2010
I am developing a software that connects to a database and manipulates product and user data. It works on my computer but it will have to be used by many computers maybe even world wide (who will access the same database) so I have no idea what kind of systems people will have. I still don't know how to ensure that they will be able to connect to the database for I have already had problems in Windows 7 computers which don't have jet oledb.4.0
I am a bit lost here because I don't know if I should first try to do a connect, or if I should first look for a jet oledb engine on the computer where the software is installed. And in case they don't have it installed should I prompt them to install it before running the program further? Or should I pack the engine along with my program? What is the line of thought here to make the program run on (almost) any machine?
View 5 Replies
May 1, 2010
how do I use notepad as a database inside a vb.net program.I am making an athletics database/profile program which will include all school records for each and every student.So what I want to know is, how do I use a notepad file, filled with data, to perform search functions on records (like finding the fastest times in a particular event) and sort functions (assending order of times etc.) and view them on a form.
View 1 Replies
Mar 17, 2009
I'm working on a multi user VB.Net windows application with back end as SQL Server 2008 Express. The SQL Server is installed on the intranet network drive. This is the connection string I will be using. Is this correct?
Data Source=.SQLEXPRESS;AttachDbFilename=Q:DatabasePrintDB.mdf;Integrate d Security=True;Connect Timeout=30;User Instance=True
View 3 Replies
Mar 17, 2011
i am doing project of Order Accepting system for five star hotels.Scenario is Waiter will accept order using Window Mobile which is Connected to WiFi present in hotel.I want to communicate to database(Sql Server) present on My Machine (Computer present in kitchen) through WiFi and Add order into table present inside database. This should notify my application present on Compter and should print order. After completion of Order Application from kitchen will notify to waiter about completion. My problem is How to Communicate with database present on Remote computer using WiFi from windows Mobile.
View 2 Replies
May 23, 2009
i'm using vb 2008 express editor, and 3.5 compact sql, through my program, i make changes, like altering rows, deleting or adding new rows, to a dataset. i want, that when button 1 is pressed, all changes made to that dataset, are updated to my database. what is the line of code that does this? [Code]
View 1 Replies
Sep 29, 2010
---3 laptops running same VB.NET application locally AND access/share same database located on one of these machines. Is this Possible? an easy way? ---OR would the best sollution create a website with database ?
View 1 Replies
Aug 21, 2008
I'm building an aplication with an MS Access database behind the scene. In many of my forms I'm gonna use DataGridViews to show data from the database, not an entire table but data based on manually built queries. So, I have few questions without answers, by now. Solutions or 1. I haven't decided how will I bring the database into the project: from the menu -> Add New Data Source, or within the code, at runtime. I still don't know which one's best or why.2. How exactly can I execute any SQL query (SELECT, INSERT, UPDATE, DELETE etc) on my Access database from my aplication?
View 3 Replies
Dec 3, 2009
i have an ACCESS database with 3 columns. I establish the connection with the VB 2008 Express and put the data in the form but i don't know how to add the text of a textbox in the database.
View 5 Replies
Aug 29, 2009
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 Replies
Apr 28, 2012
I have this code that Deletes a record by its IP address inputted by the user. How do you check if that record is available? how do evaluate first that the IP address inputted is not in the database before deleting anything? in vb 6.0 I used to do this line:If rs.EOF And rs.BF Thenbut it doesn't work anymore in vb 2008
Code:
If TextBox1.Text = "" Then
MsgBox("Input IP Address", MsgBoxStyle.OkOnly, Title:="")
[code]......
View 9 Replies
