Just want a clarification about who to access a database through a network, her's a scenario:there is a client running a vb application, the application starts with a login form, when the user and password is supplied, a new form is shown including a datagridview with data populated from the remote machine running sql server. ide be thankful if u supply a code snippet for the connection part, and ille continue from there.
View 2 RepliesAm working a vb.net 2008 project using ms access database 2007 and i successfuly finished it. i published the project and burnt it with cd. my database path in vb.net was located c:Deploydatabase.accdb.
so i installed the program in to another 2 networking PCs. when i run them and put the database path c:Deploydatabase.accdb in every computer, its working. but the problem is that:
i need the database to be accessed by server or my machine for instance where every other networking computers are able to access my database in this location of my machine (my be as defualt) without not putting it to their pcs.
This enables me to see what every machines users can add information to the program.
for example, i have got 10 computers networked each other (i.e comp1, comp2, comp3, comp4, comp5, comp6, comp7, comp8, comp9, comp10). i have installed the program in every computers so when/if comp1 adds/edits informations to the program, then all other computers are capable of receiving this information which means comp4 can see what comp1 has entered in the program.
I 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 Replieshow should i implement networking through vb.net 2008?
View 6 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 RepliesHow can I return the IPv4 address in VB.Net? E.g. 192.168.1.5
View 3 Replieswhy is this code not working?
Dim tcplistener As New System.Net.Sockets.TcpListener
This does not compile with the error "Overload resolution failed because no accessible 'New' accepts this number of arguments." The thing is, I have to declare it as New because otherwise I will get a null-reference exception...
i've been wanting to do this for a few years now and it amazes me that no one can come up with a solution.i want to write a program (preferably in vb.net) that can send a message to another computer (or device) that is connected to the same network as me. I want the message to appear on the other computer (or device) in a popup message box. Also, it would be ideal if this could be done through some sort of bluetooth connection, if not then local ip connection will do. I don't know how i would go about doing this but i know it's possible because i've seen some programs do it... in fact i've seen a program called blackrain that without any additional software installed, can display messages on an ipod touch screen to instruct the yser what to do, and then display the results from their input on the computer screen, almost instantly. I would like to know how that works as well if anyone has any thoughts please feel free to share them!
[Code]...
I'm realizing a .NET chat application but i still have that error: I can send only a message per connection. For example. With the code below, i can send only one message that can be received correctly by the other peer, but if i send another message message, on the same connection,it won't be received by the remote PC. Here is the code:
[Code]...
I just made my project, I just wanna ask is possible to share your project to the other computer, like file sharing or networking, which you can access your project to the other computer, is that possible? If possible, how should I do that?
View 2 RepliesAs winsock, in the case of VB, what is the control or package available for networking in .net?
View 2 RepliesI am a Network Administrator in the Army so programming is not my strong area. I have been messing with Batch files and WMI, just recently i started VB Scripts (VERY BASIC) like adding an input box to set computer name, scan network for computer name on domain, return wmi info for that remote computer etc... I know there are programs out there that can do all of this, however the Army will only allow certain approved programs to be installed on government workstations, i have been using .Bat files to gather info which is fine, however it is very time consuming when you have entire subnets with computers, networked printers, etc to place into a spreadhseet for higher headquarters tracking not to mention the over 20 columns of required data to track for each computer. I have VB 2010 Express, working on a Windows Form Application Project. Goal is to interface my VB Script (written with notepad) with a GUI that will generate an internal spreadsheet on the form window in a datagridview. So far i have the basic window and i have my gridview with my column headers set. How do i get the data into the columns and rows accordingly.
Application Basic: Execute Program, in main window select button (Scan IP Range) <--- I want this to open an input box for the beginning subnet, input base address to start scan from, next input box for end range, then msgbox for start scan. i want the results of the scan to autofill the datagridview and add new row for each IP address that had a ping reply, returning valid data from WMI results as it receives the data. What would be the best method to achieve my goal. i am not asking you to write the program, i have been looking and studying MULTIPLE sites, think i just need another set of eyes on this to unlock the knowledge i have locked away, if ya know what i mean. Also, if you don't mind let me know what you think of this app im trying to turn out... Super Thanks for your help.This is the Base Batch File running. It calls an external VB Script written in notepad. (I want this implemented into the app form so there is no console window.)This is the inputbox from external VB Script that is called.This the result of the external VB Script (the info i want to put in the datagridview of the app.)I also, for some reason can't get scroll bars to show in the app when i hit F5, theres about 15 columns passed the MAC column...?
A peaceful 2009 to everyone! How could i create a social networking site using visual asic.net 2009, i will need reports as administrator, kindly email your answer to {REMOVED}
View 5 RepliesIs there a way to monitor and determine the total in/out flux from and to the Internet (not just one port or one program)?
View 2 RepliesI have a small application that is currently released. It does not use any database technologies. I built into it some simple copy protection that allows the app to run as a 10 day trial. After this it needs a licence number that I generate based on a code my app provides to the user.This works great for one or two standalone machines but I am now being asked about more flexible pre activated site licencing. Currently this is a bit beyond my skills. I need pointing in the right direction. I assume if I remove my copyprotection and install on a network share, that my app will run.My app also stores some data in the registry which includes the serial number and copy protection data. I could probably switch this to a local file if this helps.What approaches are there for networking my app and copyprotecting it at the same time?
View 1 RepliesI 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 RepliesIn our VB.Net application, we need to get the path to our data folder in Public Documents. In our standalone application this is straighforward using the SHGetFolderPath function. However, for our network application, we run into a problem when we load the application on a Win 7 server and run it from a Win XP workstation. From the workstations, SHGetFolderPath returns the workstation's public documents folder instead of the what we want, which is the server's public documents path.Is there any way within the application to query the public documents path on the server?
View 1 RepliesI made my own advanced networking system which uses System.IO.Streamwriter and Streamreader but offline. I would like to let this use a directory online, I have a webhost available for that, now how do I say to the program it has to look at a specific map with all the users information?
I now have already this into my login form:
Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click
On Error GoTo A
[CODE]...
Just curious if I can let my network grow out international instead of pc. Also I have a second question. I made a create account page which is supposted to make a text file with the txtUserName and txtPassword inputs, but it does create the file, but doesnt write any lines into it.
Code here:
Private Sub btnCreate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCreate.Click
Dim UserGenerator As System.IO.StreamWriter
[CODE]...
I'm writing a social networking application in VB.NET, with a target userbase of 1-2 million users. All user data will be in memory in a dictionary of 'User' objects with properties such as Country, Region, Age etc exposed. I need to perform search against multiple user properties in memory - I'm not using SQL.What's the most performant way to implement a 'user search' against multiple properties?
View 1 RepliesI'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
I am using the code shown below to compare two Access databases with two fields each and write the results to a third Access database. I am getting an error at the "Do While DMReader02.Read = True" line: "Invalid attempt to call Read when reader is closed." Why would the reader be closed at this point if I am using different DataReaders in the two loops?
Imports System.Data.OleDb
Partial
Class Form1
[code]....
I'm using VS 2010, and I did a project using VB and a database in Access. The problem is that when I try to put that "application" on other computers, sometimes, is not working. I thought it can be because on these computers they don't have access, but on one computer, is running another app which is using Access and there is no Access installed. How can I check if my application requires Access to be installed or not?
Here is a example of how I did the connection:
Public AccessOLEDBConnString= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & myfullpath & ";Jet OLEDB:Database Password=password"
Function getConnection() As OleDb.OleDbConnection
[CODE]...
And when I want to have access at the data I'm doing like this:
dim conn as Oledb.OledbConnection
dim sql as string
dim ds as Dataset
[CODE]...
(using VB2008) I am trying to automate Access from VB.Net. To do this, I added two libraries to my project, Microsoft.Office Interop.Access v12.0.0.0, and dao v10.0.4504.0. This seems to give me all the necessary commands, yet when I tried to open up an Access database via the following code:
CODE:
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 RepliesI 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. However, there should be something simpler and faster than that, shouldn't it? Any idea?
View 6 RepliesI have this problem, I can create a setup for my app/database but everyone can open the backend file which is an MS Access database. I want it so we can only access the database using the frontend app.
View 2 RepliesI 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]...
I have 2 access databases in access 2007 I want to be able to up date one from the other.
View 3 Replies[code]
Imports System.Data.OleDb
Imports System.Data.SqlClient
Imports System.Configuration
[code]....
I don't know if these can connect with Access, anyway, I got ERROR on the com.Connection.Open()?