Insert Data From Local To Remote?
Apr 15, 2010How 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
ADVERTISEMENT
Quickly Insert Data To Remote Mysql Server
Jun 24, 2011I have small application in vb.net
I have one table in msaccess, which is having around 20,000 records,
now, I want to insert these records to remote server of mysql,
I tried as below code, it takes around 3-4 hours to insert data, dst in code is having all records from ms Access
[Code].....
Local & Remote Service Monitoring?
Mar 10, 2011I 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?
Local And Remote Database Sync
Dec 5, 2009I'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.
.net - Opening A File Which May Be Local Or Remote (via Http)
Feb 20, 2010In 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
Backing Up Database From Remote Server To Local
Mar 25, 2010I 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 RepliesDetermine Whether File Path Is Local Or Remote?
May 9, 2011I 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 RepliesLocal And Network Printers For ALL Users On A Remote Pc?
May 30, 2012I 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]...
Modify Local Security Settings For A Remote Pc In Lan?
Mar 17, 2010how to modify local security settings for a remote pc in lan with vb.net?
View 3 RepliesTrying To Check A Remote Text File Against A Local One
Jul 9, 2011i'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.
Update Local Tables From Remote Server?
Apr 19, 2010I 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
Add A Domain User To A Local Group On Remote Computers?
Mar 6, 2009add a domain user to a local group on remote computers
View 2 RepliesDetect Local Computer Name On A Remote Desktop Session?
Apr 30, 2010I 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
Detecting Local Computer Name Etc On Remote Desktop Session
Nov 13, 2009I have a VB.net 2008 Windows forms application which runs on W2k3 server and is accessed by 15 Remote Desktop users I would like to be able to store information such as the default printer for each RDC session plus other info To be able to do this I need to know the local computer name (or some other identifier) so I can store computer specific information (such as default printer) how I can get info about the RDC session from VB
View 1 RepliesVS 2005 Impersonation With Account Local On A Remote Server
Mar 19, 2009I need to impersonate with an account that is local on the remote server not the server where the application is running.
View 1 RepliesLocal Group Policy Editor - Force Shutdown From Remote System
Aug 3, 2010The following steps give a Guest shutdown policy.
1- Click run, and type the gpedit.msc, to start "Local Group Policy Editor".
2 -Expand "Computer Configuration" -> "Windows Settings" -> "Security Settings" -> "Local Policies" -> Then click "User Rights Assignment".
3- In the Policy window, Select "Force shutdown from a remote system", double click it, it will pop a properties window.
4- Click "Add user or group button", add a user and name it Guest.
I need to know if it's possible to manipulate and add the user or group programmatically. I'm using Visual Basic 2008.
Use Directory Services For Listing The Members Of The Local Administrators Group On A Remote Pc
Sep 22, 2010how to use directory services for listing the members of the local administrators group on a remote pc in the following format?
[Code]...
VS 2005 Connect To A Remote Server And Copy A File To Local System
May 27, 2009I 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 RepliesBulk Insert To Remote SQL Server 2005?
Dec 8, 2009Ok where am I messing up here, I had this working to a local SQL 2005 instance. However I am unable to get this to work to a remote SQL instance. Why?
[Code]...
Insert Remote Image Onto Windows Form In Program?
Jun 7, 2009Inserting remote image onto windows form in vb.net?
View 1 RepliesRemoted DateTime Values Can Not Be Converted To The Equivalent Local Time Of A Remote Computer That Is In A Different Time Zone
Aug 24, 2011I used .NET Framework 1.1 in C/S project before. Now I have updated the project to use .NET Framework 3.5 without modifying source code, but I have found that : the Remoted DateTime values can not be converted to the equivalent local time of a remote computer that is in a different time zone. In .NET Framework 1.1, the DateTime values can be converted automatically.
[Code]...
Copy A File From A Local Computer To A Remote Computer On The Network?
Dec 19, 2006I need to copy a file from a local computer to a remote computer on the network, if i try to use File.Copy without logon i get the following error:"Logon failure: unknown user name or bad password."How do I provide user name and password for file copy?
View 2 RepliesOpen Excel On Local Desktop Using Remote Desktop Application ?
Jun 11, 2012We have a Windows Forms VB.NET application running on Windows Server 2008. Users access this app using Remote desktop.The app displays information in Excel, but Excel opens on the server.Is there a way for the .NET app to launch Excel on the users local desktop?
View 1 RepliesCall A Remote Modem Using A Local Modem Connected Via USB?
Oct 12, 2011I am attempting to call a remote modem using a local modem connected via USB. Programming language is VB.NET and I am using the SerialPort control to talk to the modem.
Communication is as follows:
I send: ATZ0[CR]
Modem responds: ATZ0[CR][CR][LF]OK[CR][LF]
I then try to dial a number:
I send: ATDTnnnnnnnnnn[CR] where nnnnnnnnnn is a valid number
The modem responds with:ATDTnnnnnnnnnn[CR][CR][LF]ERROR[CR][LF]
All other commands seem to work without any issues
For info the modem is a MultiTech MT5634ZBA-USB-V92
If I use hyperterminal and type the same commands in it works as expected and dials the number, so it must be something I am doing in my code, possible some setup in the SerialPort control
INSERT Query - Insert Data To Database?
Jun 22, 2010im in the middle of doing sql queries i can search my data base usingGetDateFrom (Select, from, where) Me.nameTableAdapter.FillBy(namenDataSet.descip, Me.box1TextBox.Text,Me.box1TextBox.Text, Me.box2TextBox.Text, Me.box2TextBox.Text)i have this working fine im struggling with inderting data to my databse i have made the query ..
INSERT INTO `details` (`Forename`, `Surname`, `Username`, `Password`)
VALUES (''& ForenameTextBox.Text &'', ''& SunameTextBox.Text &'', ''& UsernameTextBox &'', ''& PasswordTextBox &'')
[code]....
Insert Some Data Into A Table With The Insert Function?
Aug 2, 2009I have run into a problem. When I insert some data into a table with the Insert Function, I want it to return to me Id key.Say a table is like this
ProductId
Product
Quantaty
If I run
Code
Insert Into [table](Product, Quantaty)Values(Cd, 3)
I want it to return to me the value of the ProductId so that I can use it, is this possible?
Populate Local Database Table With Remote Server Database Table ?
Aug 11, 2012I 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 RepliesInsert Data With Insert Command?
Feb 3, 2012I am developing vb.net windows application. I am trying to insert data with insert command.I am getting the insert data as long as the application is running. But when i close the application and reopen again the inserted data was not in the access database and i am getting no result. what is the problem, is it in code? i am using like
strsql=" Insert into table(col1,col2) values(val1,val2)"
selectCommand as new oledb.command(strsql,strConn)
selectCommand.ExecuteNonQuery()
Not inserting in the database but showing in application. how?
Displaying Data From A Local Database?
Oct 27, 2009i have managed to add a database to my project its kind of a client database tells me their first, second name, email, date they last called etc etc anyway everything works fine it allows me to add, delete edit etc no problems.What i wanna do is on my main form i have a DateTimePicker1 if i select a date on the DateTimePicker1 how can i make it display last client calls in a RichTextBox?
[Code]...
How To Store Data In Local Memory
Jul 4, 2011I need some informations to do my project. From webservice I get mye data as a List and this is stored in my application in bindingsource.datasource. The list do have many properties which displays as columns in the datagrid successfully.But my problem is how do I store the data in my local memory? You might say just make some local dataset or datatable....,but how do I convert the list to datatable? Or how do I convert bindingsource.datasource to datatable?
View 4 Replies