473,544 Members | 2,424 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

HELP - Need to connect to DB2 database on AIX from NT server. Also AS/400 from NT Server

HELP - Need to connect to DB2 database on AIX from NT server. Also
AS/400 from NT Server

-- I am experienced in ORACLE and a novice at DB2. What tools would
be the equivalent of Net*8 or SQLNET in ORACLE that would allow me to
connect to a database on a remote box (either AIX or AS/400)? I have
read that DB2 Connect appears to be the ticket for the Db2 server if
it is on AS/400 or OS/390. What if it is on AIX? Does the same tool
apply?

All help is appreciated.
Nov 12 '05 #1
4 5573
hi,
To connect to DB2 db on AIX from windows you will just be needing the
db2 client and then you have to catalog the db.
Regards,
Ashish Vijaywargiya

sc***@oax.com (Scott Holland) wrote in message news:<22******* *************** ****@posting.go ogle.com>...
HELP - Need to connect to DB2 database on AIX from NT server. Also
AS/400 from NT Server

-- I am experienced in ORACLE and a novice at DB2. What tools would
be the equivalent of Net*8 or SQLNET in ORACLE that would allow me to
connect to a database on a remote box (either AIX or AS/400)? I have
read that DB2 Connect appears to be the ticket for the Db2 server if
it is on AS/400 or OS/390. What if it is on AIX? Does the same tool
apply?

All help is appreciated.

Nov 12 '05 #2
Ian
Scott Holland wrote:
HELP - Need to connect to DB2 database on AIX from NT server. Also
AS/400 from NT Server

-- I am experienced in ORACLE and a novice at DB2. What tools would
be the equivalent of Net*8 or SQLNET in ORACLE that would allow me to
connect to a database on a remote box (either AIX or AS/400)? I have
read that DB2 Connect appears to be the ticket for the Db2 server if
it is on AS/400 or OS/390. What if it is on AIX? Does the same tool
apply?

All help is appreciated.


To connect to DB2 on AIX, you just need the DB2 Runtime client, which
is free.

To connect to DB2 on AS/400, you either need DB2 Connect Personal
Edition or DB2 Connect Enterprise Edition, which are licensed products.
I recommend you read the following article for info about these two
products in order to make the appropriate decision:

http://tinyurl.com/2pmfz
Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #3
OK. Thanks for the help. We have downloaded the client software and
were able to get the connection to work on the same AIX box as our
test database. We are now installing the client on an NT Server box
and trying to connect to the DB on the AIX box on the LAN. Assuming
we need no extra pieces for this, we will hopefully have this working
today.

The next and more interesting step is the AS400. This will be the
production DB, and we will need our program to attach to the DB2
instance on this platform. Our application will supposedly need to
run on an NT Server platform. I understand from here that I will need
the DB2 Connect piece for this to work. This piece would reside on
the NT Server correct?

Can I use DB2 Connect in my test environment here between the NT
Server and the AIX box? Or is it strictly for connecting to the AS400
and OS390 environments?

Thank you in advance.

Scott

Ian <ia*****@mobile audio.com> wrote in message news:<41******* ***@corp.newsgr oups.com>...
Scott Holland wrote:
HELP - Need to connect to DB2 database on AIX from NT server. Also
AS/400 from NT Server

-- I am experienced in ORACLE and a novice at DB2. What tools would
be the equivalent of Net*8 or SQLNET in ORACLE that would allow me to
connect to a database on a remote box (either AIX or AS/400)? I have
read that DB2 Connect appears to be the ticket for the Db2 server if
it is on AS/400 or OS/390. What if it is on AIX? Does the same tool
apply?

All help is appreciated.


To connect to DB2 on AIX, you just need the DB2 Runtime client, which
is free.

To connect to DB2 on AS/400, you either need DB2 Connect Personal
Edition or DB2 Connect Enterprise Edition, which are licensed products.
I recommend you read the following article for info about these two
products in order to make the appropriate decision:

http://tinyurl.com/2pmfz
Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Nov 12 '05 #4
Ian
Scott Holland wrote:

Can I use DB2 Connect in my test environment here between the NT
Server and the AIX box? Or is it strictly for connecting to the AS400
and OS390 environments?


I think DB2 Connect includes the normal DB2 client, so from your server
with DB2 connect you should also be able to connect to the AIX server.

\
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
5455
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- Hello, I have a very simple problem but cannot seem to figure it out. I have a very simple php script that sends a test email to myself. When I...
0
2549
by: Nate Hekman | last post by:
I'm trying to set up a Membership/Role Provider for an ASP.NET 2.0 beta 2 site using SqlMembershipProvider, and am having problems configuring SQL Server. I'm comfortable with ASP.NET but very new at databases, so please help me out on the database side! When I run aspnet_regsql I get this error: Setup failed.
15
2067
by: DavidS | last post by:
Have Visual Studio.NET installed on MS 2000 Professional OS laptop. No issue ever with web development and SQL connections. Purchased new laptop with XP Professional SP2!!!!!!!! & Visual Studio.NET installed. Nothing but headaches. Continually getting System.Data.SqlClient.SqlException : Timeout expired message - The timeout period elapsed...
16
2290
by: peshekeedweller | last post by:
Using asp.net 1.1. vb.net 2003. I am trying to connect to a remote sql server 2000 on a virtual machine running windows 2000 server. I can connect through the server explorer in visual studio, but cannot connect through code. I have done it before and can not do it now; I don't know what changed. (I also cannot connect to local Access...
2
2229
by: cryon.b | last post by:
Hi To All, I took up the IBM sample testfor Exam 700 today and I have the test tomorrow,I have some questions for which Iam not sure about the right answer,can anyone please guide me as to what is the right answer for these questions are.This would mean a lot to me. 1..A developer is building an embedded SQL application on AIX that will...
0
5532
by: gunimpi | last post by:
http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help wanted ******************************************************** For this teeny job, please refer to: http://feeds.reddit.com/feed/8fu/?o=25
13
2830
by: Jennifer.Berube | last post by:
well I'm not sure how to go about making my SQL connection string... The code below is what I need to replace with my SQL connection...I just don't know if that code is for DSN or access... I don't want to use DSN just a connection string...help? function GetConnection() const DSN = "membershipdb" const UID = "webuser"
6
2968
by: zaina | last post by:
hi everybody i am nwebie in this forum but i think it is useful for me and the member are helpful my project is about connecting client with the server to start exchanging messages between them. to be more clear we process this purpose we serve this to the student in the university. how?? student will send a message that contains his...
12
2431
by: =?Utf-8?B?ZGdvdw==?= | last post by:
I designed a "contact_us" page in visual web developer 2005 express along with EW2 after viewing tutorials on asp.net's help page. Features work like they should, but I cannot figure out how to send contact info to email or data base when the "send" button is pressed. I've watched the tutorials over & over again. I just can't get it. Link:...
0
7438
marktang
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...
0
7632
Oralloy
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. ...
1
7392
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7720
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5931
agi2029
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...
1
5309
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3422
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1850
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
0
677
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.