I am using the following code to copy files from one folder to another...
Public Shared Sub CopyFlashScriptFile(ByVal SourceDirectory As String, ByVal DestinationDirectory As String)
Try
[Code]....
Is there anyway I can programmatically stop SQL Server and copy the files, then start the server again?
A user scans a series of documents which are sent through a program that places a .tif or .pdf of each document into a folder on a remote VM Server and sends the image location to a VM instance of SQL Server(along with other OCR extracted data).
It is my job to create a program that will:
1. Allow another user to see the filenames on a form, chose which files need to be processed (either by typing them into two textboxes {ie. start and end filenames} or by clicking on a start and end filename on the form {from a databound SQL container maybe?}.
2. The program then must show the images in a picture box as it is copying them to the destination folder.
3. Then the software must somehow be able to regonize which documents were processed, and not include them in new searches.
[code]...
i have 2 application clinet/server the server broadcast media files to client i used tcp/ip protocol the server code is work good but i have a problem in client code i need ineed someone to correct the code .iwll show where the error is in the code note: i call the class in the main form dim a as recive in the starter of the main form class to be gloable .
[Code]...
I am trying to make a copy of an existing database, I use .net framework data provider for SQL Server.I get error "Unable to connect to source server for Transfer" when it runs to oPackage.Execute().
oConnection = oPackage.Connections.New("what the providerID should be?")
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSTransferObjectsTask")[code]......
I need to copy my SQL Server DBs to a folder. The files are attached to SQL Server, which I have detached using my code. When I try to copy these files using My.Computer.FileSystem.CopyFile(filePathToCopyFrom1, targetFilePath1)
[Code]...
I have developed a vb.net application which creates a csv file from database. When I run it from my system it works perfectly but when I copy the files from release folder to a folder on the server and runs the .exe file it give me IO Exception error. "The device is not readyť
[Code]...
basically i just want client to say "C: emp" ENTER
then, server must reply with all its files in c: emp
I have to query one table and insert the result in a table on another database in another server The query is "select ID, name from Table" The other table exists and have the same fields. How can I do this?
View 5 RepliesHow should i copy contents of Datagridview to SQL Server
View 2 RepliesWhat I tried was using My.Computer.Network.DownloadFile(), and created a shared folder in the other computer to do downloading stuff.But, in fact I didn't know how to fill the path to the other computer, the error was: "...path not supported..."
How about this:
ServerName1 = cmbServerName1.Text.Trim()
database = cmbDataBase1.Text
[code]......
How to copy folder from client to server using fso.
View 2 RepliesIs it possible to code to copy store procedures from one SQL server to another SQL server in vb.net application without using SQL server replication?
View 3 RepliesI have a VB2008 application that uses SQL Server 2005 Exspress Edition. I was modifying my application and then decided to add a table to the mdf (named "Pipe.mdf"), which I have don many times before, but I must have messed something up when I made other changes. After I added the new table I opened the Dada Source Configuration Wizard to add the new table to the dataset and I don't see the new table to select it. However, it added a copy of "Pipe.mdf" and named it "Pipe.mdf1" to the Server Explorer.
If I delete this copy of the mdf, it appears again in the Server Explorer when I open the Data Source Configuratuion Wizard.
If I add a Table to the copy of the mdf ("Pipe.mdf1"), it shows up in Dada Source Configuration Wizard.
what to change so that the new table appears in the Data Source Configuration Wizard for the original mdf (Pipe.mdf) and not add the copy of the mdf?
I need to copy data from one database to another using a VB.NET program. The target database is SQL Server the source database is some proprietary ODBC compliant database.
I need to loop through a list of table to copy. Read the data from the source database table for a given modified date. Delete the corresponding date from the target database table and insert the records from the source table. The databases are of the same structure i.e. table names and field names, but the data types may differ (however they are compliant e.g. double in source, float in target). No primary keys exist.
Heres how I may do it :
Firstly execute a Delete command to the target. I could then use a DataReader to obtain data from the source, loop through the Items and create an Insert Command for each row. Add Parameters to the Command with the appropriate values and execute. And wrap the whole thing in a Transaction.
is there any code to copy and rename data within the sql server.actually i reated a database which will be like default template and ever company will have the similar database with different name.So what i want when a new company is created, a copy of default database will be created with new name.
View 2 RepliesI'm trying to upload a file to a remote server by using vbscript
below is a code :
Dim fso, f, myFile
Set fso = CreateObject("Scripting.FileSystemObject")
myFile =$URL
[code]....
the problem is with this code i can copy the file only in the same PC but it didn't work when i try with different machin i mean from client to server?
I have 2 tables that are related,both have identity columns for primary keys and i am using a vb form to insert data into them,My problem is that i cannot get the child table to get the primary key of the parent table and use this as its foreign key in my database.the data is inserted fine though no foreign key constraint is made.I am wondering if a trigger will do it and if so how. All my inserting of data is done in vb.The user wont insert any keys. all these are identity columns that are auto generated. If a trigger is my way out please illustrate with an example.
View 2 Replieswhat is the best approach in VB.NET to get the entire table from the Ms SQL 2008 R2 database and save it in the program (dynamic?) array or something which is easy to translate into bytes and send to other device via socket communication?
View 1 Replieshow to do it through my VBA code, or at least tell me which MSDN forum would know how?I've created a Vista "Network Location" (an XP "Network Place") which I'll call "portalToServer" which behaves as a kind of FTP portal into a web server.Manually, I can very easily drag a file (e.g., test.txt) from my destop and drop it onto this "portalToServer" object in my Computer folder, and magically a copy of the file is FTP'd to the server.How can I do this copy task programmatically in VBA???I have found that this object is actually stored in a folder at: [code] (or any variation that expands that explicitly, with or without trailing , with or without destination file name appended) returns a path not found error error 76, I think it was.(FYI, I've confirmed a line like ' FileCopy "C est.txt", "C: ext2. txt" 'does copy files.)I've also observed that if I use either a DOS window or the Run command (with CMD /c prefix) to do a COPY with those arguments, it reports success but actually fails.These DOS-like modes actually place a copy of the test.txt file in a "portalToServer" folder (in this example) on my PC which also contains a "target.lnk" file which I assume points to the FTP site on my server.(I can navigate to that into folder in the DOS window to see inside it.) I'm guessing the Windows GUI does some magic on any files dropped into that folder, but that magic is bypassed by the DOS windows or Run CMD instruction.
View 2 RepliesAs far as I can work out I should be able to copy a web project/application to my IIS Web server and be able to see it as I do when designing it on my development computer.
The problem is once I copy the folder over to my web server and then try to view it the browser it says Error 404 not found. There must be a real simple fix for this. I would like to be able to develop ASP.NET sites using the Visual Web Developer instead of Dreamweaver but this little issue is stopping me.
In our project logs files are stored in clients local only . So during any production issues we have to be waiting till they provide us the log file. What is the best way to copy the log file from clients local machine to some common path in one of our servers .
View 2 RepliesScenario: I want to develop an application.The application should be able to connect to my remote server and download data to the local disk , while downloading it should check for new files and only download the new ones simultaneously creating the required(new) folders.
Problem: I have no idea how to compare the files in the server with the ones in the local disk.How to download only the new files from the server to the local disk?
What am thinking?: I want to sync the files in the local machine with the ones in the server. I am planning to use rsync for syncing but i have no idea how to use it with ASP.NET.
I am using vs 2010 web..I want to know that:how to upload only modified files/file to server instead of upload full project.if a made a small change in a aspx file and want to see how it look like live . then vs 2010 upload each time all pages/files to server and it take time.
View 1 RepliesI'm doing a project where we are re-creating a very old system.The client wants the same base functionality and some improvements.One of the things I'm currently working on is the note-system. These are used as flags of some sort, but are also used as a comment field for some products or client profiles.In the old system you could write the text and save it like you would get in a .txt file. They want the new one to be able to do word formatting such as:
Different font sizes (Only some parts of the text)
Different font colours (Only some parts of the text)
Underlining of words
Bolding
Italics
Tab-spaces
Those are the specs they want. What I need to know is the following:
1) How do I do that?
2) Currently they store all these files on the server as text files and the database have paths that refers to each file. I want to be able to save a text file with that formatting to the HDD of the server like in the old system.
3) If possible I would like to save that text to the database with the formatting.
I am trying to create an application, which in first phase will read the content of an XML file, count the products, and copy the content of the XML to a sql server database TEMP table, which i have already created. I have already created the code to read the content of the XML file and view it in a datagrid view. But i dont know how i should copy the content to the database i have created....
The code i wrote till now:
Imports System
Imports System.Xml
Public Class FrmXMLRead
[code]....
I need to copy each product (code, category, subcategory, part_no, titlos, timi, availability, anakykl, lianiki) to the TEMP table of ABC databaseHow should i proceed to copy the data to a database ABC and table TEMP?
I have a console application created in VS2005, with a web reference created via WSDL.When I run on my local machine (and I have a browser up) I can access the web service fine (if a browser is not up I get the 407 error).I understand this,since my local client machine MUST go through the company proxy (I assume the proxy is resolved when I sign start the browser).When I copy the application to our server, the 407 proxy authentication required error ALWAYS comes up.The thing is, on the server all check boxes in internet options/connections/lan settings are NOT checked. i.e. the server DOES NOT go through a proxy.I installed wireshark to help track down the problem and it shows that when i access the web service wpad is being called and our proxy server is being called.is there a .net configuration that allows me to say "ignore the proxy".I have already tried variations on the system.net section of the app.config file: [code]It seems that no matter what we do (including changing registry settings) this application ALWAYS tries to go through a proxy.
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 need to download all files fron FTP server folder. is it possible to download the folder from FTPserver? if not is it possible to download all files from folder because i have a requirement that i need to download all the files from that folder in FTP server. even i don't know the files name. So is there any sample code for this? i have xml files in that FTP server folder.
View 2 Repliescreate a script that will download folders and subfolders from a FTP server to a local server.
example:
server = 192.168.1.1
user: user
password: 12345
[Code].....
I am using the web client to download a file. Which works ok. However, now I have to download many and the number of files to download will change everyday. I am not sure how I can get the web client to know which files have been downloaded or not? I was thinking of using a for loop to download each file. But I will never know how many there are to download? The web client could download the same file twice?
[Code]...