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;"
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 RepliesI'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 RepliesI 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 RepliesI 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 RepliesCan 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 Repliesi 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 RepliesI can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 RepliesI have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 RepliesI have sqlserver database in my server folder c:data How can i access this data from other computer with my vb application?
View 8 RepliesCan anyone provide the resource to learn making connection between computers over the LAN and retrieve files? EDIT: And can I browse the folders like its done in the local machine?
View 3 Repliesit's been awhile since I've been here. Is there anyway to access the computer monitor's menu? I have done a lot of searching over the past week.
View 8 RepliesActually it is possible to find the mac address of host computer using but i just want the code for access the visitor's computer mac address in c#.net
View 1 RepliesI'm trying to download a file from the internet by clicking a button in MS Access.
I'm trying to use My.Computer.Network.DownloadFile as described here: [URL]
Private Sub Command2_Click()
My.Computer.Network.DownloadFile("http://www.example.com/temp/xml_test.xml", "C:xml_test.xml")
End Sub
but the 'Microsoft Visual Basic for Applications' IDE that I'm typing this into seems to have no idea what I'm talking about (text just turns red).
Can I just not do this through the built in VB editor or can I simply load a library or something to make it work?
Sorry but I'm very new to VB and to Access so search results are not specific enough for me to understand - lord knows I've tried.
I'm using Access 2010 but the DB was created in an previous version - not sure if that matters.
I have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset
View 1 RepliesI am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 RepliesI 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.
How to check if a computer has access to the internet?
View 2 Repliesvb.net
Public Sub AntiCorrupt()
Dim DirInfo As New IO.DirectoryInfo(HardDrive)
DoneGather = False
Results.AddRange(IO.Directory.GetFiles(HardDrive, "*.*", IO.SearchOption.AllDirectories)) 'Admin Access
[code]....
I tried running this application as administrator, even though I am on an admin account. I even disabled UAC. Nothing seems to work. I do not want to just skip the file, I want to read it.How does a antivirus program scan every file on your computer for errors? How do it read the file if Vista prevents it?
I'm trying to figure out, how I could access a webcam on another computer withing our network. It could be P2P as well.
View 1 RepliesI am trying to access the "AppData" of a user on a remote computer. I have all the rights needed. I tried this:
r = RegistryKey.OpenRemoteBaseKey(RegistryHive.Users, MachineName)
r.OpenSubKey(SIDValue & "SoftwareMicrosoftWindowsCurrentVersionExplorerUser Shell Folders")
AppData = r.GetValue("AppData")
The fact is that it retrieves my own appdata folder...Actually the SID Value of the account on the distant computer and on mine is the same (I am under a domain). I don't know if it is the reason why I get my own appdata folder.How should I proceed?When I browse the HKEY_Local_Machine, I manage to have information about the remote computer..But not when browsing HKEY_USERS.
Visual basic 8.0. I used Access to create a datbase and am using it without a hitch in a program that I wrote. However, I am about to replace my computer with a new one and wish to know how a move the existing database into the new computer. I used Microsoft's "one key (?)" distribution vehicle to deploy the program after compiling it. The database has been updated using the .exe version of the code. With enough work, I think I can find the execution data base by looking in the place Microsoft hid it. I will re-deploy the program on the new machine but how do I handle the database?
View 1 RepliesI'm using vb2008 with DB Msaccess 2003 in the first my language it's not very well so I'm sorry fro bad expression I have two computer ( Pc1,Pc2)I put the program(exe) with DB on the PC1 , then I put the program(exe) on the pc2 the pc1 connect to pc2 how do I deal(connect) with DB from Pc2 ?
View 13 RepliesI'm trying to access a web server to download a file, but when I run the statement gives me the following WebException:
[Code]...
how to connect to a database of another computer in same local network using vb.net? We already enable remote connection in the sql server configuration and also sql browser and we already connected with one another using wireless network. Here is our connection in vb.net
"Data Source=NEWUSER0602akzSQLEXPRESS;Initial Catalog=sample;Integrated Security=True" is there something wrong with this? because when i input a data it always show me the error "An network-related or instance-specific error occurred while establishing to SQL Server"
Im doin project in vb.net as front - end and sqlserver 2005 as back-end
View 8 RepliesI created an executable file of an application done in VB Express 2010 which connects to a Access 2010 database. When installling the executable file at one of the user's computer, the file is installed correctly, but it fail's when trying to connect to the database. It says that Microsoft Dataengine cannot open the database. The user's computer doesn't have Access installed, does it need to be installed? or can I install a framework or application to avoid installing Access at the user's computer?
View 8 Replieshow to detach SQL database and attach it to other computer and run also the VB.NET windows application SQL project there.i want to get rid in this. or if there's a existing thread for this.here's the screenshot of the database and need to transfer it and debug it to the other computer.
View 1 RepliesWhen I try to install the application from the files it produces when I follow the prompts from Build - > Publish (Visual Studio 2010) onto another computer, and then run the application on the other computer, it wont connect to the SQL database on the original computer. I've been receiving a timeout error or one which says it can't find the server.I have no idea where to start looking to fix this, both computers are running XP and 4.0 .NET Framework. The computers are linked on the same network.I think my connection string is the culprit, but I don't know how it should be set up to run on multiple computers. Here's my connection string:[code]The connection string works on the application I've installed on the original computer, but not the second computer I've tried installing the application on.My second thought was that it could be the server which is wrong, I've just used the name of my computer for that, is this correct? I thought it may be because all the computers are connected on the network.
View 3 RepliesI have created a simple window forms application which link to microsoft access 2007 database.
I build the application exe file already. The exe file is run well on my computer, but when i transfer it by copy and paste the whole folder to another computer it cannot run. I am wondering why this happen? the error is as below :
"selected collating sequence not supported by the operating system".
Will it cause by the different .NET Framework version? How can i solve this? Or any others way to transfer the exe file to another computer?