Access Database Path On A Networking Computers
Apr 18, 2012
Am 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.
View 15 Replies
ADVERTISEMENT
Jan 22, 2012
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 Replies
Jun 2, 2011
In 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 Replies
May 17, 2012
I want to back up the database type from Access, but my problem I could not generate code to determine the path of the database, I noticed that the database path (C: Users george AppData Local Apps 2.0 Z1KL8MCD.3ET 62KCKET3.2TX )But this path is changed when the program re-installation ( final folder change as it is known)note, I use Windows 7 & Microsoft Visual Studio 2010 note , I use this code >> but does not work.[code]
View 7 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
Jun 10, 2011
I'm writing small VB.Net app which should build reports based on data gathered from some external MDB-files (Access 2007).
It was planned that this app will use parametrized SQL queries to collect data from DBs.
One of the parameters for these queries is path to the external MDB-file.
Here goes sample code:
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:TempTemp.mdb;")
conn.Open()
[Code]....
Looks simple but doesn't works. After launch my app throws following exception - System.Data.OleDb.OleDbException: Disk or network error.
Have spent a whole day to make it work with no success. What have I done wrong?
View 2 Replies
Jun 10, 2011
I'm writing small VB.Net app which should build reports based on data gathered from some external MDB-files (Access 2007). It was planned that this app will use parametrized SQL queries to collect data. One of the parameters for these queries is path to the external MDB-file.
Here goes sample code:
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:TempTemp.mdb;")
conn.Open()
[Code]....
View 1 Replies
May 22, 2012
I am trying to read and display a file using MapPath as follows :
Response.ContentType = "Application/pdf"
Dim FilePath As String = MapPath("../Document/123.pdf")
Response.WriteFile(FilePath)
Response.End()
This procedure will work fine and display in the browser. However, if I save the file to C:Document123.pdf, how can I access this file using relative path in MapPath function. Is there an option to access the file which is saved out of IIS server? I am using vb.net 2003.
View 1 Replies
Feb 28, 2010
i want to know how to access the client computers using the vb.net program
View 1 Replies
Sep 21, 2009
needs coding in vb6 to access personal computers processor id / sl number, hard disk id / serial number. The pc is running with xp operating system.
View 4 Replies
Apr 20, 2012
how to share sql database through LAN computers, here what I have done after I did a research.I enabled remote connections for sql server as using both tcp/ip and names pipes.In firewall, I added an exception for sqlservr.exe and sqlbrowser.exe as allowed in the firewall.cplTCp for sql server network configuration is enabled.
Therefore, I connected the sql server database into the vb.net where I chose the wizard for connecting the database as "add new data source"...I selected from there a Microsoft SQL Server (SqlClient). And Then finished the connection of sql server database and vb.net...Therefore, I built the program and its running....In the project properties
Setting tab, I got my connection string :
Data Source=MUSTAFAMUSTAFA;Initial Catalog=CustomerRegister;User ID=sa;Password=123
Or where exactly can the connection string be found?OR that conection string i found the setting tab is enough for other computer to detect my database server?Please here i am stressed about it.So what should I do next...can I publish the program and it will run another machine where database will be looking for my machine...or there other steps I need to do?
View 3 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
Jul 25, 2008
when i try to write to a file I get the error:
Quote:
Access to the path "PATH HERE" is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path "PATH HERE" is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.But when I add: <identity impersonate="true"/ to web.config I get the following error when my application trys to open a DB to read it:
Quote:
Unspecified error
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Unspecified errorLine 55: objConnection.Open()
View 1 Replies
Nov 12, 2010
I have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
View 4 Replies
Jun 4, 2011
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 Replies
May 1, 2012
1. First off, how do I make my path to my database relative? The path is currently absolute and is: Data Source=J:/College/AS_DSFinalDatabase1.accdb
2. Second of all, where do I save my database in the project? I want it to be included in like project folders...kind of like the App_Data folder in ASP.Net.
3. I'm recieving an error whenever I try to populate more than 1 DataGridView upon form load for some reason...I've tried 5 different ways of writing the code, and I get the same error...there's no error description, so does anyone know what the issue is? Here's the error:
View 5 Replies
Jun 11, 2011
i want save image in directory path and also save path in database...sqlserver 2005 and retrieve in in same folder and path?
View 1 Replies
Mar 23, 2009
how should i implement networking through vb.net 2008?
View 6 Replies
Oct 15, 2011
I 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 Replies
May 25, 2010
How can I return the IPv4 address in VB.Net? E.g. 192.168.1.5
View 3 Replies
Aug 2, 2011
why 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...
View 1 Replies
Aug 25, 2011
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]...
View 1 Replies
Oct 29, 2011
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]...
View 1 Replies
Nov 3, 2010
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 Replies
Aug 14, 2009
As winsock, in the case of VB, what is the control or package available for networking in .net?
View 2 Replies
Dec 4, 2011
I 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...?
View 1 Replies
Jan 2, 2009
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 Replies
May 16, 2011
Is 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 Replies
Dec 7, 2010
I 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 Replies
Mar 30, 2009
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 Replies
