Questions tagged as 'as400'

Tagged questions
1
answer

Connect to an IBM DB2 database from ASP.NET Core

I need to access an AS400 db2 database from an ASP .Net 5 or Core application. Try with entity framework through the following packages link Following the documentation on this page: link But it did not work, I presented error...
asked by 01.04.2016 / 23:22
1
answer

How to connect to as400 from csharp

Good afternoon, I need help how can i connect to as400 database db2 d from c sharp calling the data to a datatable and showing them in a datagridview? because I get pure connection information but from a console application I would appreciate yo...
asked by 15.05.2018 / 19:25
0
answers

Text field as400 are seen as varbinary in SQL SERVER

I have an AS400 Server (IBM i) for Linked Server to SQL, the problem is that some values (text type (varchar)) are not displayed correctly, something like this is seen in the result of the query by OpenQuery 0xD4C5C4C9C140404040404040404040...
asked by 22.12.2017 / 17:54
0
answers

Connect .Net Core to DB2 AS400 7.2

I need to connect a .Net Core application with a database on AS400 7.2 server, I tried EF but I have not, I want to do it like in the old days with OLEDB and it seems that it does not work anymore, any ideas? I have followed IBM tutorials but I...
asked by 16.10.2018 / 00:47
0
answers

AS400 Macer VB, In case of erroneous data, Reset to initial state

At work we handle a lot of AS400 mainly to manage issues with the warehouse, I have made a macro to put all the codes in an excel with its quantity, which works. The problem comes if I enter a bad code, the macro is blocked and does not advance...
asked by 01.08.2018 / 11:53
1
answer

Web Service as400 - Error Favicon

I am building a web service in as400, but it throws me the following errors:    The file /www/WebService/htdocs/favicon.ico does not exist   The URI of the GET request /favicon.ico HTTP / 1.0 is not valid The service is an RPG program. T...
asked by 08.03.2018 / 14:41
1
answer

Convert date type DD-MM-YYYY to DD-MM-YY on AS400 iSeries

Good morning. Realizing a date format in As400 I realize that with DAY - MONTH - YEAR, doing the order that you want works but it will always throw me 01-09-1995 but what I want you to show me now is 01-09- 92 Has anyone done a formatting to...
asked by 18.01.2017 / 15:07