Unable To Connect To MS Access Which Is Placed In Another Systems Shared Folder?
Oct 30, 2009I have web service which updates MS access database. Im using OleDB for Updating MS Access database
View 9 RepliesI have web service which updates MS access database. Im using OleDB for Updating MS Access database
View 9 RepliesI am trying to make a new data connection to an Access DB using the Server Explorer. The connection test OK then when I click on the OK button to finish I get the following error message.
Unable to add data connection. Index was outside the bounds of the array.
I am using VS2010 and the 4.0 .Net Framework. I have found several posts on this but done have worked out.
I want to connect Access 2007 with vb.net 2005 but its giving me error while doing same
View 1 Repliesif you could see everthing but the thing I'm having trouble with the Public Shared Function(folder in 'Dim folder As nvironment.SpecialFolder' is the problem)
Option Explicit On
Option Strict On
Imports System.IO
[code].....
I am trying to connect to my remote MySql Database within Visual Studio using the compact framework.
I can successfully add a data source and preview the data within the IDE so assume that the connection is ok regarding Connection strings and remote access.
However, when I attempt to access the data using any run time control I get the following error when the table is loaded using the .fill method.
MySql.Data.MySqlClient.MySqlException was unhandled
ErrorCode=-2147467259
Message="Unable to connect to any of the specified MySQL hosts."
[Code]....
Dim wmins = ("//192.168.1.5/root/cimv2")
objOS = New ManagementObjectSearcher(wmins, "SELECT * FROM Win32_OperatingSystem ")
[code].....
I use this code to share folder:
Public Sub Share()
Dim managementClass As New ManagementClass("Win32_Share")
Dim inParams As ManagementBaseObject = managementClass.GetMethodParameters("Create")
[code].....
creating ones own folder structure through tree view similar to the windows explorer for a windows application,will the application work on all the systems over the network?? will the files added to the folders (of the treeview in the application),visible to all.or would the exe be required to be put onto the shared folder of every system?? what will be the exact architechture???
View 9 RepliesI found how to create a share in C# using the ManagementClass to create an object to reference the Win32_Share class and the ManagementBaseObject class to access the members of the Win32_Share class.My problem is that I want the "Everyone" permissions to default to Read only.When I set the share via Windows Explorer it works fine but the code in my C# application is allowing Full Control and Change permissions along with Read permission.I tried using the DirectorySecurity class but that blows away the Security permissions (under the Security tab)without affecting any Share permissions of the Everyone group (under the Share tab).I don't want to change the Security permissions, I want to change only the Share permission (you know, the permissions that appear when you hit the Permissions button on the Share tab).
View 4 RepliesNetShareAdd API from a VB.NET application (.NET version 2.0) and although I can get the API to just create a basic shared folder I now want to create a shared folder and specify its Share permissions (not NTFS permissions) as well, which means I have to pass in a SHARE_INFO_502 structure rather than just a SHARE_INFO_2 like I was previously doing for creating a basic share. I have spent over 5 hours solid just trying to get this working and am getting to the point now where I really cant think of anything else to try.I've encountered several problems whilst trying to make this work but the one I am finally stuck on is this: When I call NetShareAdd it returns the error INVALID_PARAMETER and the parm_ err object (which is supposed to specify which member of the SHARE_INFO_502 structure caused the error) holds the value 501. I know it is something to do with the security descriptor because if I comment out the line where I set the SHARE_INFO_502 structure's shi502_ security_descriptor field then the code works without an error (just obviously does not set the share permissons I want).I think posting all of the code here might be a bad idea as its currently over 150 lines long (yes that is only code for getting this API working...) so I'll just post my definitions of the SECURITY_DESCRIPTOR structure and the code I am actually using to call the various APIs involved: [code] Each of those API calls prior to NetShareAdd returns a non-error value in the Debug.WriteLine that is done after each one, but there is obviously an issue somewhere with the security descriptor.
View 2 RepliesIs there a code checking that whether a shared folder is available?? Or check whether ftp path is available?
View 2 Repliesi am doing a vb.net windows application. in that i am creating one folder and making it shared and also assigning shared permission to SYSTEM. My code is as given below.
[Code]...
I need to open a file on a shared folder which is in another computer that is conected to my computer through a network switch.
View 2 RepliesCan you give me a function or class which have properties?[code]...
View 5 RepliesIn this question I'm using Visual Studio 2008. My code is quite simple, as it was used from a reference I grabbed off the web. I'm using ASP/VB.Net, IIS6.0 on a Windows Server 2003 box.I've looked at various sources online, and have not been able to piece together a proper result. The purpose of this is to list a slew of directories and their respective files, and allow the user to eventually manage that directory (such as open and delete files).
Here is my ASPX page:
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="DirectoryList.aspx.vb" Inherits="VCMReports.DirectoryList" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
[code]....
When launching the page, the following error appears: 'V:Users' is not a valid virtual path. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: 'V:Users' is not a valid virtual path.
Things I have tried:
On the server, I have mapped out the drive and the directory.Permissions seem to be properly set, impersonate is correct.If I were to list a directory in the actual directory "C:InetpubDirectory", there is no failure.I do understand this is incomplete for the Directory listing portion, this will only list files (so this will need to be modified.I have attempted to create a Virtual Directory, and the application presented the same error. On my local development machine, I have the same path created - same error. How am I able to view the contents of a shared directory and it's files?
I need to open a folder on a remote server with different credentials in a window (explorer.exe).I managed to do it with no credentials (my credentials), but when I do it with another username and another password than mine, it opens a prompt to enter a username and a password, and it says "access denied".
In the access log on the remote desktop, it says that I tried to connect with my own username, and not the other username I entered. So, the process obviously did not work.
[Code]...
If I have a 'Shared' object defined in the App_Code folder; is that object shared amongst all users/visitors of my website? Or is it shared on a per-user basis?I don't know if that makes sense or not; but I've got a puzzle/solver I'd written earlier that I'm trying to incorporate into a simple ASP.Net site. It's probably poorly written, but I'd used a Shared boolean to determine if a solution had been found. The code works, now as an ASP.NET site, but if two visitors to my site were both validating their puzzle at the same time, would they both be accessing the same boolean?
View 3 Repliesgive me a function or class which have properties ?For example:I shared a folder (C:shared)
Dim clsObj as new clsSharedMonitor("C:shared")
'so that I can get its properties like:
clsObj.FullPath() 'Full Path of folder that client are accessing
clsObj.ClientIP() 'IP of computer which access to server
[code].....
I need to find a folder that is shared between all users of a PC, every body being able to read/write to that folder and below, without any errors. I think that the folder "C:Documents and SettingsAll UsersShared Folder" would do the trick. How do I find the path to that folder, regardless of the OS used (Xp / Vista / 7) and regardless of the Windows language (With a french Windows, this folder is called "C:Documents and SettingsAll UsersDocuments partag").
View 5 RepliesI have created a shared add-in in Visual Studio 2008 and using the shared add-in wizard and am coding in VB. When run the add in in Access 2003 I want to check if the user has a database open, so I set a AccessApplication variable to be the application object in the OnConnection procedure and then on a button click I check if AccessApplication.CurrentDB Is Nothing If there is no database open Access will close correctly after the button is clicked. But if a database is open then I have to stop Access in the VS debugger.
[Code]...
I have a problem when i use My.Computer.Network.DownloadFile from a iseries share path
View 2 RepliesAll i am trying to do is read and write files to a shared folder on a network in visual basic (VS 2010). I can go to the folder through windows without a problem and without being prompted for a password. However when i try to do it through visual basic, it cant find the directory. Here is my small snippet of code that i (hope) is telling me that the program cannot connect to the folder. [code] Are there any known issues with VS 2010 that may cause this? Maybe something else in my code that could have an effect? This is in my form_load event though, so it is literally one of the first things that runs.
View 1 RepliesIs it possible to create a folder on a remote machine that has no previously shared folders? I can do this...
vb
Dim fname As String = "\10.1.x.yDocumentsMyFolderName"
IO.Directory.CreateDirectory(fname)
[code].....
I use the following code in order to check if certin user exists in the DACL:
Dim l_managemantObject As ManagementBaseObject() = CType(securityDescriptor.Properties("DACL").Value, ManagementBaseObject())
For Each mObject As ManagementBaseObject In l_managemantObject
l_name = CType(mObject.GetPropertyValue("Trustee"), ManagementBaseObject).Properties("Name").Value.ToString
If CType(mObject.GetPropertyValue("Trustee"), ManagementBaseObject).Properties("Domain").Value IsNot Nothing Then
[Code]...
I am building archiving system, I store the files on shared folder on windows server 2003, the shared folder protected by one user name and password ,on LAN I need vb.net windows forms to open file inside shared folder, how I could open the shared folder and in same time providing windows server 2003 with user name and password for the shared folder
View 4 Replieshow a database software is developed? i tried using sql server, the weak thing is that.....the database software is unable to run in a pc that is not installed sql server program. using others software instead of sql? or is there any other way that possible to let my database program to access database data without required sql installed.
View 1 RepliesI am able to connect to the sql server 2008 express by using this as connection string
View 10 RepliesWhen I click "Connect to Database" I get this error..
View 1 Repliesi installed visual studio ( full installation)then i got xampp from their site i have mysql and apache running i downloaded the connector from mysql site and i created a simple project to check if i can connect to mysql or not i have made this code so far
Imports System.Data.SqlClient
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Connection As String = "Data source=localhost;user=root;password=;Initial Catalog=test;Integrated Security=true;"
[code]....
im having trouble with an exception though it says {"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"}
how can i get rid of this, is it because i installed mysql 2005 with visual studio 2008? and maybe it runs with xampp's mysql and creates these problems?
i added the bindingsource control on my winform. here are the details of my connection:[URL] when i test the connection, it says "the connection cannot be tested because the specified DB file does not exist" the DB is located in [URL]. how should i set up bindingsource?
View 2 Replies