My client keep on insisting that they want there database to be ms access and not sql server. But they also what to be remotely accessible in there network.
Is it possible to use ms access as a remote database? would the database locked up once a connection is made?
i have written an application in vb.net 2008 that i want to access a remote database.when it tries to connect, this is the error message:[code]
View 2 Repliesquerying a remote Access database! We are currently using this because thus far we have failed at hooking up a sp_linkedserver. I feel like it's a terrible hack and want to be done with this whole network mapping business once and for all!
[Code]...
Client form need an access to the ms access database located at the Server. I've just created a database in MS Access in the format .mdb, 2000 version. Forms created in the platform Visual Basic 2010. Kindly post procedure or source code to do it. I preferred to use OleDB connection since i used it on a stand-alone access to database.
View 4 RepliesI am currently developing in Visual Studio 2008 (Visual Basic) and I have no problem reading, editing, saving, etc. to a 2007 Access database that is stored locally using the following code:
Dim NotifyDS As New DataSet()
Dim NotifyCon As New OleDb.OleDbConnection
NotifyCon.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|DataSettings.accdb"
NotifyCon.Open()
Ultimately I am going to be installing this program in my office on multiple computers, but would only like to have one "server" program where the database is installed. All of the other computers will have access to this one database over the LAN. For some reason I am unable to access this remote database file over my LAN. I have tried all sorts of things (including a username and password for the server computer),
[Code]...
I'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 have an issue with am access database source located on a remote computer.I tried using ADODB to access it, it works, but when I change( update insert or delete) the database on the remote computer, the changes is not reflected in my application
View 1 RepliesI'm currently designing a client application that connects to a SQL Server 2005 database. My app is being used to display data, allows users to run reports and stats on the data. It is being developed using VB2008. Within my VB2008 project, the connection string to the DB is made via SQLEXPRESS.
The road block that I'm running into right now is that it only allows me to connect to a local DB file (.mdf) only. I tried to connect to a different DB file on a server within the same network domain, and it generated the following error:
"The file "U:Data.mdf" is on a network path that is not supported for database files. An attempt to attach an auto-named database for file U:Data.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." (where U: is a mapped network drive).
Below is the actual connection string in my code:
"SERVER=.SQLEXPRESS;AttachDbFilename=U:Data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
The intention is to have the DB reside on a server, where there is another application that runs as a service to collect the data and then populates this DB. Then my app would just connect to the database, and allows users to run reports based on the data in the DB.
I heard that this is the limitation of SQLEXPRESS: it will not allow connection to a remote database. This is true? If so, is there anyway that I can get around this limitation?
The main reason that I chose SQLEXPRESS in the first place is that because of the licensing issue. The company that I work for do not want to make the users of our software app have to purchase additional license for the full-blown SQL Server Enterprise edition. I also heard that SQL Server Enterprise edition does allow you to connect to a remote DB (.mdf) file.
I have an MS Access 2003 database built that resides on a shared network path at the company I work for.The database works perfectly for users connected directly to the company network.However, when a user tries to open the database while connected remotely to the company network (they can still access the shared path), they receive the following error:The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.At the time that they tried it, they were the only person accessing the database.They tried a local copy as well as a copy on the network shared drive.[code]
View 4 RepliesI have to access remote connection from XP os to Vista os in vb.net How to do that?
View 1 RepliesI'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
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 RepliesI've found a few examples of using vb.net to access an sql database, so far none of them have worked . They all involve using DataReaders. Maybe its the fact that the sql db is not on the same machine as the application.I was just wondering if anyone had a more comprehensive example of using VB.NET to access a remote sql server.
EDIT:I've received a few helpful comments an replies already. So far my connection string looks like:
"server=sqlblah.myhost.com;uid=myuser;pwd=pass;database=testdb"
Probably also good to mention their is no editing of the tables a this point, just reading.
I was wondering can I make a program that I can send to other computer so i can access their screen. is this something that can be done in visual basic? i ask how to do this because Verizon did this to me the other day i saw him moving the mouse around and checking the connection but of course i had to accept this and it showed me a thing saying he was off when he was done.
View 1 RepliesRemote registry access using WMI VB.Net..I just need simple example of how to access a remote registry (2000, XP) using the "System Registry Provider" (WMI) in VB.NET.
View 6 RepliesI have a web site that connects to a remote SQLServer, and is running just fine.I have some pretty simple 'batch' type tasks that I want to run (as a Windows application) on a scheduler (I'm more comfortable with VB so I prefer that).
Looks like VB Express won't allow me to access the remote data. Everything seems to be pointing to having to buy VS Professional for $545 (I don't have an original one to upgrade). Is there a more economical VB option?
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 RepliesI am looking to access a folder on my web server to retreive a picture and to replace a picture in that folder. I am using VB.Net 2005.
View 3 Replieswhat are the requirements needed on how to control a terminal pc in terms of programming it. i am planning to use vb.net when we develop the system.
View 1 Repliesi want to access com port of my remote pc. this pc is connected through LAN.how can i access com port of remote pc?
View 1 RepliesI have a working code snippet that I use to Execute processes on remote machines. This works great against my Windows 2008 machine but I get an access denied when executing against my Windows 2003. The access denied is thrown when connecting the scope in the code below. I believe I have give this user all kind of rights but some setting is missing. What settings are required? This is a local admin. Is there any special DCOM settings or?
Public Shared Function ConnectToScope(ByVal nc As NetworkCredentialClass, ByVal strHostName As String) As ManagementScope
Dim scope As ManagementScope = Nothing
Dim Path As String = CType(IIf(strHostName.ToUpper() = Environment.MachineName.ToUpper(), _
"ROOTCIMV2", "\" + strHostName + "ROOTCIMV2"), String)
[code]....
Is there a way to enable and than configure routing and remote access on windows server 2008 r2 using a (c#,vb).net script? What i need to do is:Enable Routing and Remote access
Configuration:
Select: Virtual Private Network (VPN) and NAT
Choose Network Interface to use based on given IP subnet
Select: Assign IP: Automatic
...and so on.
I have to develop a project by which my office employees can record their time to enter into the office and leave from the office. I have 10 PCs in my office. All PCs are under network environment. This project is highly related to date and time factor. All PCs are used by an individual employee and can not be restricted to change their own PCs local date and time. So I think my project took the date and time from a central server.
View 4 RepliesI'm trying to return from a webpage, the remote HKCUVolatileCLIENTNAMEHere's what I'm doing so far:
Get the Machine Name via DNS - this bit works great:
Public Shared FunctionGetMachineName(ByVal String
[code].....
I have an existing VB6 application which permits two or more users to work with local relicated MS Access databases. At start-up and shut down the local database synchronize with the master database (if the network permits dialogue) using
mDb1.Synchronize etc.
I am trying to port the application over to VS2010 and I cannot find anything equivalent to permit occasional synchronizing of various replicated MS Access databases with the master database (again, if the network permits contact between the two machines). Has anyone found a way of doing this for Access databases (not SQL Server databases)?
Works fine in VB6 but VS2010 has me beaten at the moment.
how can i access remote sql server 2005 work on windows 7 ? and in the seem time i donot like turn off firewall .
and how i can make sql server listen to it port 1433
I'm trying to write a console application that can modify registry subkeys on remote pc's in the same network. I have it working in my own environment but when I install on the customer machines I'm getting unauthorized access when it hits the OpenRemoteBaseKey. The security settings in the application properties is set to full trust application so I'm not sure why it won't work.
I'm using Visual Studio 2010 and first I just installed it on the customer machine and when it wouldn't work I ran the source code in Visual Studio 2005 which is on the customer machine but got same results.I can run the app directly on the remote machine and it will change the registry subkeys as directed, I just can't do it remotely. RemoteRegistry service is started. Both machines are logged in as administrators.
Here is the source code:
Imports Microsoft.VisualBasic
Imports System
Imports System.IO
Imports System.Security.Permissions
[code]....
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 RepliesI am trying to change the "logon as" userid and password for a service on a remote machineMy user is a domain admin Here is the code I am using...
Dim wmiScope As ManagementScope
Dim wmiConOpts As New ConnectionOptions
wmiConOpts.Impersonation = ImpersonationLevel.Identify
[code].....
how to enable remote database
View 2 Replies