Sorry to repeat myself if this is the same question I asked in the past, but
I have finally made a connection to our AS400 through ODBC. I tried to get
the connection using the data connection wizard and the OLE DB connection,
but I was getting a winsock error. Is there a better way for me to connect?
ODBC seems to be slow and cumbersome.
Thanks for the information and any tips on using .NET with AS400 would be
appreciated.
Thanks again.
Brad
14  2092 
"Brad Allison" <ba******@ukcdo gs.com> schrieb Sorry to repeat myself if this is the same question I asked in the
past, but I have finally made a connection to our AS400 through ODBC.
I tried to get the connection using the data connection wizard and
the OLE DB connection,
but I was getting a winsock error. Is there a better way for me to
connect? ODBC seems to be slow and cumbersome.
Thanks for the information and any tips on using .NET with AS400
would be appreciated.
Please ask in the database group instead. This group is about VB.Net related
questions.
microsoft.publi c.dotnet.framew ork.adonet
--
Armin
How to quote and why: http://www.plig.net/nnq/nquote.html http://www.netmeister.org/news/learn2quote.html
Brad,
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 an older
OS/400 such as 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 ( http://www.sqlthing.com) and the
above sites you should come across a number of samples and further
information.
As Armin suggested, the microsoft.publi c.dotnet.framew ork.adonet newsgroup
will provide "better" ADO.NET support.
Hope this helps
Jay
"Brad Allison" <ba******@ukcdo gs.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Sorry to repeat myself if this is the same question I asked in the past,
but I have finally made a connection to our AS400 through ODBC. I tried to
get the connection using the data connection wizard and the OLE DB connection,
but I was getting a winsock error. Is there a better way for me to
connect? ODBC seems to be slow and cumbersome.
Thanks for the information and any tips on using .NET with AS400 would be
appreciated.
Thanks again.
Brad
Armin,
The one who answers AS400 questions very clear is in my opinion Jay B.
And there are more however in my opinion all from this newsgroup.
Cor
"Cor Ligthert" <no**********@p lanet.nl> schrieb Armin,
The one who answers AS400 questions very clear is in my opinion Jay
B. And there are more however in my opinion all from this
newsgroup.
This newgroups is about VB.Net language related questions.
--
Armin
Armin,
* "Armin Zingler" <az*******@free net.de> scripsit: The one who answers AS400 questions very clear is in my opinion Jay
B. And there are more however in my opinion all from this
newsgroup.
This newgroups is about VB.Net language related questions.
Full ACK. > 95 percent of the questions here are OT.
--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
Hi Herfried,
I counted the questions you did give an answer on, more than 5%, you are
not obliged to do that.
:-)))))
Cor
(You know of course that I did not count them really)
"Herfried K. Wagner [MVP]" <hi************ ***@gmx.at> schrieb
This newgroups is about VB.Net language related questions.
Full ACK. > 95 percent of the questions here are OT.
95% ?? Pretty much! :-)
--
Armin
Brad,
Another option would be to use a fully 100% managed ADO.NET provider
for DB2. This solution would not require any client software from IBM.
DataDirect's Connect for .NET has such a provider that can be
downloaded from their website. The jump page for Connect for .NET is: http://www.datadirect.com/products/dotnet/index.ssp
The download is a fully functional trial version and should be much
faster than the ODBC solution you are currently using. As it is also
100% managed code, you'll also be able to take advantage of .NET
framework features such as security and automatic memory management.
The footprint for this provider is also much smaller than that of the
ODBC solution as you won't need to install the DB2 client software.
Hope this helps,
Bill Fahey
(bill dot fahey at datadirect dot com)
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message news:<uM******* *******@TK2MSFT NGP09.phx.gbl>. .. Brad,
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 an older
OS/400 such as 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 (http://www.sqlthing.com) and the
above sites you should come across a number of samples and further
information.
As Armin suggested, the microsoft.publi c.dotnet.framew ork.adonet newsgroup
will provide "better" ADO.NET support.
Hope this helps
Jay
"Brad Allison" <ba******@ukcdo gs.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. .. Sorry to repeat myself if this is the same question I asked in the past,
but I have finally made a connection to our AS400 through ODBC. I tried to
get the connection using the data connection wizard and the OLE DB connection,
but I was getting a winsock error. Is there a better way for me to
connect? ODBC seems to be slow and cumbersome.
Thanks for the information and any tips on using .NET with AS400 would be
appreciated.
Thanks again.
Brad
* "Cor Ligthert" <no**********@p lanet.nl> scripsit: I counted the questions you did give an answer on, more than 5%, you are
not obliged to do that.
I never said that I am not replying to OT threads or that I am replying
to all OT threads.
:-)))))
Cor
(You know of course that I did not count them really)
:-)
--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/> This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Niyazi |
last post by:
Hi,
Our company uses IBM AS400 and DB2 (version 4.5 I guess). I have to do some
report but I donot know how to access the AS400 DB2. I search IBM
unfortunately IBM site in mess. Can anyone tell me how to access AS400 DB2 so
I can use VB.NET for my application to create a report?
I also learn from IBM site that there is a DB2 Data Connection for Visual
Studio.Net and acts as IBM Explorer in conjunction with Server Explorer and
toolbar...
|
by: Amanda |
last post by:
From a guy in Microsoft newsgroups:
| In *comp.databases.ibm-db2* there are always IBM guys
| from the Toronto labs on line.Post with the
| -for the love of god please help-
| line and I'm sure you'll get their attention.
| Their usually very good:)
So here's my transplanted post
==========================================
|
by: alan_sec |
last post by:
Hi.
Does the com.ibm.as400.access.AS400JDBCDriver driver that is part of
JTOpen (http://jt400.sourceforge.net) works with db2 udb version 7 that
is installed on windows 2000?
I' m trying to access db2 from java aplication like this:
Class.forName("com.ibm.as400.access.AS400JDBCDriver");
Connection connection =
DriverManager.getConnection("jdbc:as400://hostname","user","password");
|
by: Matthew Wells |
last post by:
Can someonne please tell me an ADO connection string to use to link an AS400
table to Access WITHOUT using a DSN? I want to use:
currentdb.tabledefs(td).connect = sConnectionString
currentdb.tabledefs(td).RefreshLink
I CAN ALREADY CREATE AN ADO CONNECTION. THE WEB SITES PEOPLE ARE SUGGESTING
ONLY GIVE CONNECTION STRINGS NOT A STRING I CAN USE FOR A TABLEDEF.
|
by: Matthew Wells |
last post by:
FIRST OF ALL, I APPRECIATE PEOPLE SENDIUNG ME LINKS TO WEB SITES FOR
CONNECTION STRINGS BUT AS I'VE SAID BEFORE THAT IS NOT WHAT I NEED. I CAN
EASILY OPEN AN ADO CONNECTION OBJECT TO AS400. I NEED TO REFRESH A DAO
(Access) TABLEDEF OBJECT'S CONNECTION STRING WHICH MUST INCLUDE A CLAUSE FOR
THE TABLE NAME. THIS IS WHAT I NEED. PLEASE READ AGAIN.
Can someonne please tell me an ADO connection string to use to link an AS400
table to...
| | |
by: Sehboo |
last post by:
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
|
by: John |
last post by:
We are doing integration with an AS400 running websphere - webservices. When
the customer (AS400) calls the .Net webservice the customers java code
(every other request or so) throws the following exception. We are both
researching the possible cause of this. Any suggestions on the .Net side for
resolving this would be helpful.
John
java.io.IOException: Broken pipe.
at java.lang.Throwable.<init>(Throwable.java:195)
|
by: Nathan Given |
last post by:
Hello All,
I've been struggling on and off for 3 months trying to connect to an
DB2 database running on an IBM iSeries machine.
I FINALLY figured out how to connect with Coldfusion (see instructions
below).
So, now I am trying to connect to the same database with MS Access. I
want to link the tables within Access so I can quickly query and answer
|
by: Darth Ferret |
last post by:
This thing is about to drive me crazy. I have about 50 queries in the AS400
that I need to put on a menu. Once I conquer this I have a bunch more rpg
reports that I need to pass a date to. In the AS400 I have a stored
procedure (SPRUNQRY) that runs the RUNQRY command with the name of the query
as a parameter. In the AS400 I would type "RUNQRY SUNTR401A" on a command
line to run this query. My connection is opening, and I can run some...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
