Solved

Transfert Data from AS/400 to SQL Server via VB .Net

Posted on 2004-08-04
3
196 Views
Last Modified: 2012-05-05
Hi,
   I'm trying to update the data of a table on SQL Server with the data of a table on AS/400 (both with the same structure) using VB .NET. I can fill dataSets with the data of both and merge them, I can also display the result of the merge in a data grid and everything seems fine. But still the update seems to fail because of a conversion problem between fields of Date and Time type. Is there a way to do this without using to much code since I'll probably have to repeat this with 400+ tables? Or is there a completely different way to do this transfer with or without VB .NET ?

Thanks in advance

Olivier
0
Comment
Question by:lussier
  • 2
3 Comments
 
LVL 17

Expert Comment

by:AerosSaga
ID: 11719275
There is built in functionality for such issues:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctdatevalue.asp

If you tell me the formats that you want I could work out a lil snippit for ya.

Regards,

Aeros
0
 

Author Comment

by:lussier
ID: 11720410
Ok on the AS/400 the format we have is 'YYYY-MM-DD' and on SLQ Server it seems to be 'YYYY-MM-DD 00:00:00', the date and time are in the same field. Is there a way to separate date and time in a SQL field?
0
 
LVL 17

Accepted Solution

by:
AerosSaga earned 400 total points
ID: 11720442
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
More on Time zones in vb 2010 12 38
Advice on Xojo as a development tool over VB. 4 53
VB.Net - Project Software to help the Developer 7 33
Variable Event ? 3 27
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question