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 RepliesI 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 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 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?
How 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'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.
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]...
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 RepliesI 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'm trying to pass a variable between two datagrids. The first is on an main form, and the second is in a dialog form.
I tried using functions and also through public variables like this:
Invoice_new (Parent FORM):
Controls:
DatagridView: invoice_items
Public WriteOnly Property ValueFromChild() As String
Set(ByVal Value As String)
[Code]....
i have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
View 1 RepliesI want to know how you can export data from a disconnected database that could be access or ms sql to an sql server database.
Here is the scenario:
I have several software in a remote sites on either sql or ms access databases as back-ends...and I have another sql server database that i want to consolidate data from the remote sites.
One solution I have been thinking about is to use email to send incremental backups of the databases to the main database using a separate piece of software and have another one on the main server to pull that data into the database.
Basically am looking at setting up the remote databases as linked servers at the main database and then having incremental backups sent by email to the main database.
I have thought of replication but the internet link at the sites is terrible.
Is that a good implementation? If yes
How do i get to send the incremental backups and get them imported?(the code)
Tools:
Visual basic 2008 standard edition..Net 3.5
SQL Server 2005.
32 bit architecture.
I am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:
strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()
[Code]...
Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.
On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?
I need to copy all data from a Table of a Acces mdb (connected with OleDB) to a Table of a MySql DB (connected with ODBC)
I made a working solution, but it's very slow, and so I want to try other solutions to check if they can give me more performance.
The solution connecting to the mdb, using a DataReader, then for each row in Datareader I make an INSERT into the Mysql Table ( before copy I truncate the table to get it empty)
The records are more than 10K and this operation is very slow, and do be onest I need to do the same thing on other 2 tables also very big as this one.
I cannot make a direct sql insert ( as INSERT INTO A in ..... SELECT * FROM B) because the 1 DB has a OleDB conn and the other has a ODBC conn.
So I thought to try to make this operation using TableAdapters and DataSet, but I'm not able to make it working.
The problem is that the Dataset's HasChanges is false
If you need some code I can post, but what I do is following:
Connection to MDb
Create OleDbTableAdapter
Create DataSet
[Code].....
I'm trying to copy data from some cells value from a datagridview to other datagridview.[code]...
View 3 RepliesI am trying to copy stored Employee id and i want to show it on a customer registration form. Basically i want to show which employee severd which customer. [code]...
View 11 RepliesI am new to VB.net. I want to read and input file and store that data to an SQL Server database. Do you have an sample code that do such?
View 1 RepliesHey guys, I am trying to send data from client to server (encrypted) and the string sent from the client is not the same as recieved from the server. I've been killing my brain for hours to get this to work but I cant manage. Im converting everything to Base64 string.
Client:
Public Sub SendMessage(ByVal msg As String)
Try
SyncLock myclient.GetStream
sw = New IO.StreamWriter(myclient.GetStream)
[code]....
I have a small program which is a tcp client. I send a string from this client to a device over ethernet (it acts as the tcp server). As soon as the device recieves the input string it will respond back with response data. My problem is i am not getting the entire response data back from the server. (device).
Dim serverStream As NetworkStream = clientSocket2.GetStream()
Dim outStream As Byte() = System.Text.Encoding.ASCII.GetBytes("my-cmd")
serverStream.Write(outStream, 0, outStream.Length)
[code]....