I am making a VB.NET application that can download/backup the database that is currently on a remote server. I have Remote Server IP,Username,Password and Database name. I am also able to connect to it. But I don't know what to do after connecting to it. I don't know what all files are need to be backed up. (I think database and log file both must be backed up, I am not sure).
View 1 RepliesI am having a remote server it has INVENTORY DATABSE , and also iam having same databse in my local system. I want to populate by local database table with my Remote database table through Vb.net code by click a button. How to do this .
View 1 RepliesI have an off-line project. User uses a laptop to input data off line into local SQL server express. Once connected to domain (on line), local data will sync with remote SQL server using sync framework. (It is done, works fine)One job left:Since another user used another program to update some tables in remote SQL server, such as CUSTOMER, SHIPINFO, my off-line program need to update these new data once connect to domain.Here is what I design in Pseudo (take CUSTOMER as example)
1) In remote SQL server, create a store procedure (sp_customer) to select all CUSTOMERS
2) In application, create a dataset (dst_customer) based on sp_customer
3) Insert all customers data which is in remote SQL server but not in local SQL server based on CUSTOMER_ID
I need to impersonate with an account that is local on the remote server not the server where the application is running.
View 1 RepliesI want to know how to connect to a remote system having some shared folder.(ex, \myservermysharedfolder).Actually, I was supposed to copy a particular file which is available in a shared location of a system. To copy that file, first i need to connect to that system with an user id and password.I know copying of file (), But not getting clear idea on how to connect to the shared folder. I have tried with System.Management class, but no use..
View 2 RepliesI'm posting this in the vb.net as I will be using visual studio to perform the task. So here is what I am trying to achieve or at least achieve it more efficiently than what I am doing now.
So I have two identical database setups, both with a table , let call it table tblUsers. The local database is edited through vb.net and is a Access database. The second database is hosted on a remote server and is a MySQL databse.
Currently I have no problem connecting and editing either database through vb.net. I'm using OLE DB to connect and handle the Access database and ODBC 5.1 to connect and handle the MySQL database.
Here is what I would like to do:
User opens the program Presses the "update local" button
The program updates the local database to whatever the remote database is The user uses the program to edit fields in the local database
When done, the user presses the "Update remote" button and the remote database fields that have been edited with the program in the local database will be updated to the remote database.
Currently, the only way for me to do this is to go line by line in a for next and use a command builder to compare each field and update that way.
Im doing a project in which i need to take backup for the database each and every month while doing this the previous backup is replaced i dont want to replace it. every time i create backup it should remain there im using access as database?
View 3 RepliesI am trying to backup an SQL database but can't get rid of the error:"The process cannot access the file 'C:Original.MDF' because it is being used by another process" Once I open a form, using VB2008 from Visual Studio 2008, closing the form and/or connections to the database seem to have no affect.
FileCopy("C:ORIGINAL.MDF, BACKUP.MDF") ' Works prior to opening a form that uses the SQL database
frmTest.Show ' The form uses the ORIGINAL.MDF database
frmTest.Close() ' Has no effect
[code]....
I have written a piece of code for my backup. It looks something like this:
Dim con As SqlConnection
Dim cmd As SqlCommand
con = New SqlConnection("Data
[code].....
I have got a MySQL database stored on a remote server. I can user PHPMyAdmin to access the database and make changes to the table, i can also use a third party piece of software to do the same however when i try and access the database through my program it says that "Access denied for user 'lukefrost'@'%' to database 'PHCAdminSystem'". However it will allow me with the same logon credentials the other ways explained above. Can anyone help me with what the problem might be?
View 1 Repliesi have a site that is running in php with a mysql db and i want creat a app wiht .net 2008 to return/send values to that database what is the best way to do that? i have think in this options:
[Code]...
So I have an application which uses MSSQL server as datasource. Is there anyways I can avoid using any database server and use a local file as datasource ?
View 4 Replieshow can i deploy windows application developed using Vb.net and Sqlserver R2 Express as local database?..how can i make it in setup format(including sqlserver) to deliver to clients?is it compulsory the client should install SQL Server R2 Express in his system apart from the installation of this windows application?
View 5 RepliesVisual Basic 2010 Express, lets the user to add a Local Database with .sdf extension. These databases needs MICROSOFT SQL Server to be created or they can run in the user's pc without any additional software? What are the limit of these databases unlike an external database?
View 2 Repliesis it possible to skip forward or backup to the previous record in a database within a Do Loop of an ExecuteReader routine? For example, with the following code:
DMDatabase01.Open()
DMCommand01 = New OleDbCommand("Select * From DB01Table01 Order By DB01F01, DB01F02", DMDatabase01)
DMReader01 = DMCommand01.ExecuteReader()
Do While DMReader01.Read = True
[Code]...
I have the need as part of a larger data comparison program to not always read the next sequential record - at some points I want to go back to the previous record, or skip forward to the next record, but stay within the Do Loop.
I have an issue with my code. The application interacts with a MySQL database on a remote server, I have access to this server. When my app is running the insert into code I m getting this error: "Conversion from string "INSERT INTO phpvms_fsspireps(pil" to type 'Integer' is not valid."
The variable which holds the Inser Into string, during break point debug gives me this: ""INSERT INTO phpvms_fsspireps(pilotid, code, flightnum, depicao, arricao, route, route_details, distance, aircraft, flighttime, flighttime_stamp, landingrate, submitdate, accepted, log, load, fuelused, expenselist, source,
[code]...
And this is my code.
Dim conn As MySqlConnection
Dim cnString As String
cnString = My.Settings.constr
[code]...
the DB spec:
Total DB size: 190,1 MB
Total Tables: 106
and the table specs. The titles are in Greek but I think you can understand it from the data. [url]
Working in VWD 2010 Express I have an aspx.vb file with the following connection string:
Protected Function getPasswordLength() As Integer
Dim conn As New SqlConnection("Data Source=localhost;database=MyDB;Integrated Security=true")
Dim cmd As SqlCommand = conn.CreateCommand()
[code]....
This works when the code is on the web server / which is collocated with the SQLServer.However, when I want to debug, I have to copy to the server. I would like to be able to "debug in place" on my development machine and only copy files to the production machine periodically. Technically the production machine is not in production at the moment, but that's beside the point.Anyway, I followed the following instruction: [URL] I can now see the remote database, functions, etc. on the other machine (from the VWD running on the development machine). However, I thought I should then be able to execute this same code locally on the development machine using ctrl-F5, but I get the following error:
**Server Error in '/' Application.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)**
I'm developing a remote control program that uses a mysql database as the bound beetween the server and the client.The only problem is that cause of mysql being really varnuable to crashes i made it in a way that it checks for information every 10 seconds so things doesnt get messy. [code] For some reason after 10 seconds the connection is mysteriously aborted and the reader gives a fatal error.How can i extend the time limit to >10 seconds ?
View 3 RepliesI have a chat server / client system running, but I want users to authenticate with my vBulletin forum database.I don't want the client to do it, because it is possible to fake the 'successful login' and connect with a fake username. I want to send the username and password details to the server, and make the server check it with the local vBulletin MySQL database for the username and password.Is there a way to do this? To my knowledge vBulletin has a username and a password entries in the database which is salted, and the salt varies from user to user.
View 7 RepliesHow to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
I put together a small app I want to use on my local network for service monitoring across a few of my servers.
I'm using vb.net express 2010 with system.serviceprocess imported The problem I am having is that my code only seems to work locally, and will not retrieve the service data for any server on my network.
For example, my local machine is called "office-pc", and when running the app on it, I get all the service information.
Dim localServices As ServiceController() = ServiceController.GetServices("office-pc")
For Each localservice As ServiceController In localServices
ComboBox1.Items.Add(localservice.DisplayName)
Next
But, if I want the service info from my web server called "casper", I use the same code, but i change the GetServices() parameter like so;
Dim localServices As ServiceController() = ServiceController.GetServices("casper")
For Each localservice As ServiceController In localServices
ComboBox2.Items.Add(localservice.DisplayName)
Next
After a few seconds delay, nothing happens, ComboBox2 remains empty.
It was my understanding that GetServices() would get the local machines service info unless a machine name was specified, which in both cases is true.
So why isn't it working? Do I need to set something up on the network servers first?
How to write code for connection vb.net to sql server database in standalone system.
View 5 Replieshave this code to connect to local server:
[Code]....
In PHP you can use fopen(Path) to read from a file. The Path can be either a local file (in the usual formats /etc/file or c:file.txt) OR it can be a URL in which case PHP will open a http connection and read from the remote location
I'd like to achieve the same in VB.Net. I'm not aware of any framework function which will achieve this.
I'm currently pattern matching the path against a Regex for a valid URL - If I get a match, I open the file using a httpwebrequest otherwise I try to use the local file system.
Private Function RetrieveBGImage() As Image
Dim Ret As Image
If Not (IsURL(_BackgroundImage) Or IsLocalFile(_BackgroundImage)) Then
Throw New Exception(String.Format("Unable to load from uri ""{0}""",
[Code].....
NB: I'm aware that the logic above is inefficient and actually ends up calling IsURL() more than it has to
I am looking for a way to determine whether a file spec that I provide is local or remote. I am using VB2008. I have a VB6 app that does this by using the PathIsNetworkPath API call, but I am hoping that I can use the .NET framework instead with VB2008. Google gives lots of results on how to determine if a network path is available, but not specifically what I want.
View 4 RepliesI have this partially working but only shows printers for one user, need all local and network printers mapped for ALL users on a remote pc so I can migrate them, I know I need to do some sort of for each method but not sure what will work
[Code]...
how to modify local security settings for a remote pc in lan with vb.net?
View 3 Repliesi'm working in VB.net to create a program that checks the text in a remote text/html file against a local text file, and if the do not match, the program then does something. I keep getting an exception and i can't figure it out.
Here are the details of the exception:[code...]
I'm not at all used to working in VB, and i'm not sure if i did that HTML right either, so that could be the problem.
add a domain user to a local group on remote computers
View 2 RepliesI can get the local computer name on a RDC session using Environment.GetEnvironmentvariable("ClientName") if the application is 32 bit and Server is 32 Bit or when app is 64 bit and server is 64 bit
How can I get the local computer name from a 32 bit application when the server is 64 bit
Environment.getEnvironmentvariable("ClientName") returns an empty string