来自VB.NET的AS400 [英] AS400 from VB.NET

问题描述

您好，


我们的数据位于AS400（V4R5M0） - DB2-400。我需要从我的vb.net应用程序访问

。我对AS400一无所知。

是否有可能从表格和存储过程中获取数据？


可以有人给我显示的代码怎么做？


谢谢

解决方案

你好Sehboo，


这是在这个新闻组，只是搜索AS400然后你看到一个誓言

答案来自Jay B.，来自Scott Johnson，


这是他在此消息中提供的链接

http：/ /www.sqlthing.com/Resources/St...StopDebug.html


我希望这会有所帮助，


Cor

我们的数据位于AS400（V4R5M0） - DB2-400上。我需要从我的vb.net应用程序访问
。我对AS400一无所知。
是否可以从表格和存储过程中获取数据？

有人可以给我一些代码来说明如何做到吗？
谢谢

谢谢Cor，


我也看到了...但我的问题是我甚至不知道怎么用
定义AS400的DSN。就像在那段代码中一样，他们有以下

行

CON1.OpenDSN = MYAS400; UID = HARNER; PWD = SECRET;"


我不知道如何创建AS400 DSN。当我尝试为它创建

数据源时......我没有看到任何AS400驱动程序。


我在哪里可以获得驱动程序？它是免费的吗？怎么样的Ritmo驱动程序

（一些第三方驱动程序）......这是非常昂贵的（大约4000美元b $ b美元）。我们不能花那么多钱。


谢谢

" Cor" < no*@non.com>在消息新闻中写道：< #w ************** @ TK2MSFTNGP11.phx.gbl> ...

嗨Sehboo，

这是在这个新闻组，只是搜索AS400然后你看到来自周杰伦B.在斯科特约翰逊的回答

这是他在此消息中提供的链接

http://www.sqlthing.com/Resources/St ... StopDebug.html

我希望这会有所帮助，

Cor

我们在AS400上有数据（V4R5M0） - DB2-400。我需要从我的vb.net应用程序访问
。我对AS400一无所知。
是否可以从表格和存储过程中获取数据？

有人可以给我一些代码来说明如何做到吗？
谢谢

Sehboo，

" DSN = MYAS400"告诉你它正在使用标准的ODBC连接来获取AS / 400.


您需要使用控制面板下的ODBC数据源来定义

MYAS400数据源，您需要选择IBM Client Access驱动程序。


最好使用Client Access V5R2或更高版本（当前所有的PTF）从.NET完全支持

。 （我知道你可以保留在OS / 400 V4R5上，

它是需要当前的客户端。）

http://www-1.ibm.com/servers/eserver...edb /index.html

http://www-912.ibm.com/n_dir/nas4apa...ight=2,ii13341


以上链接是从6月3日开始的，不确定是否有更多支持更好的现有版本的b $ b版本...


如果你环顾一下SQL Thing网站和上面的网站你应该来一些样本和更多信息来获得
。


希望这有助于

Jay



" Sehboo" <毫安********* @ hotmail.com>在消息中写道

news：7b ************************** @ posting.google.c om ...

谢谢Cor，

我也看到了......但我的问题是我甚至不知道如何定义AS400的DSN。就像那段代码一样，他们有以下


CON1.OpenDSN = MYAS400; UID = HARNER; PWD = SECRET;

我不喜欢我不知道如何创建AS400 DSN。当我尝试为它创建
数据源时......我没有看到任何AS400驱动程序。

我在哪里可以获得驱动程序？它是免费的吗？怎么样Ritmo司机
（一些第三方司机）...这是非常昂贵的（约4000美元）。我们不能花这么多钱。

感谢

Cor < no*@non.com>在消息中写道

news：< #w ************** @ TK2MSFTNGP11.phx.gbl> ...

这是在这个新闻组中，只是搜索AS400，然后你看到来自周杰伦B.在Scott Johnson的回复，

这是他在此消息中提供的链接

http://www.sqlthing.com/Resources/St...StopDebug.html

我希望这会有所帮助，
Cor

我们有数据位于AS400（V4R5M0） - DB2-400。我需要从我的vb.net应用程序访问
。我对AS400一无所知。
是否可以从表格和存储过程中获取数据？

有人可以给我一些代码来说明如何做到吗？
谢谢

Hello,

we have data sitting on AS400 (V4R5M0) - DB2-400. I need to access
that from my vb.net application. I don''t know anything about AS400.
Is it possible to get data from tables and stored procedures?

can somebody give me the code which shows how to do that?

Thanks

解决方案

Hi Sehboo,

This was in this newsgroup, just search for AS400 then you see a greath
answer from Jay B. at Scott Johnson,

This is a link he provided in this message

http://www.sqlthing.com/Resources/St...StopDebug.html

I hope this helps,

Cor

we have data sitting on AS400 (V4R5M0) - DB2-400. I need to access
that from my vb.net application. I don''t know anything about AS400.
Is it possible to get data from tables and stored procedures?

can somebody give me the code which shows how to do that?

Thanks

Thanks Cor,

I also saw that...but my problem is that I don''t even know how to
define the DSN for AS400. Like in that code they have the following
line

CON1.Open "DSN=MYAS400;UID=HARNER;PWD=SECRET;"

I don''t know how to create the AS400 DSN. When I try to create
datasources for it...I don''t see any AS400 driver.

Where can I get the driver from? is it free? What about Ritmo driver
(some third party driver)...that is very expensive(around 4000
dollars). we can''t spend that much money.

thanks
"Cor" <no*@non.com> wrote in message news:<#w**************@TK2MSFTNGP11.phx.gbl>...

Hi Sehboo,

This was in this newsgroup, just search for AS400 then you see a greath
answer from Jay B. at Scott Johnson,

This is a link he provided in this message

http://www.sqlthing.com/Resources/St...StopDebug.html

I hope this helps,

Cor

we have data sitting on AS400 (V4R5M0) - DB2-400. I need to access
that from my vb.net application. I don''t know anything about AS400.
Is it possible to get data from tables and stored procedures?

can somebody give me the code which shows how to do that?

Thanks

Sehboo,
"DSN=MYAS400" is telling you that it is using standard ODBC connection to
access the AS/400.

You need to use the ODBC Data Sources under Control panel to define the
MYAS400 "data source", you will need to select the IBM Client Access driver.

Its best to be on Client Access V5R2 or later (with current all PTFs) to be
fully supported from .NET. (I understand that you can remain on OS/400 V4R5,
its the client that needs to be current).

http://www-1.ibm.com/servers/eserver...edb/index.html

http://www-912.ibm.com/n_dir/nas4apa...ight=2,ii13341

The above links are from June 3rd, not sure if there are more current
versions with better support...

If you look around the SQL Thing site and the above sites you should come
across a number of samples and further information.

Hope this helps
Jay


"Sehboo" <ma*********@hotmail.com> wrote in message
news:7b**************************@posting.google.c om...

Thanks Cor,

I also saw that...but my problem is that I don''t even know how to
define the DSN for AS400. Like in that code they have the following
line

CON1.Open "DSN=MYAS400;UID=HARNER;PWD=SECRET;"

I don''t know how to create the AS400 DSN. When I try to create
datasources for it...I don''t see any AS400 driver.

Where can I get the driver from? is it free? What about Ritmo driver
(some third party driver)...that is very expensive(around 4000
dollars). we can''t spend that much money.

thanks
"Cor" <no*@non.com> wrote in message

news:<#w**************@TK2MSFTNGP11.phx.gbl>...

Hi Sehboo,

This was in this newsgroup, just search for AS400 then you see a greath
answer from Jay B. at Scott Johnson,

This is a link he provided in this message

http://www.sqlthing.com/Resources/St...StopDebug.html

I hope this helps,

Cor

we have data sitting on AS400 (V4R5M0) - DB2-400. I need to access
that from my vb.net application. I don''t know anything about AS400.
Is it possible to get data from tables and stored procedures?

can somebody give me the code which shows how to do that?

Thanks

这篇关于来自VB.NET的AS400的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！