connecting to a db

Gladiator

hai everyone......

A small issue here........ I was trying access a
remote database....... i issued the following commands.....

db2 catalog tcpip node <node name> remote <ipaddress> server <portno>
remote_instance <instance name>

db2 catalog db <dbname> at node <node name>

the database manger is started on the remote server...

then after i am trying to connect it is giving the following
error......
" [IBM][CLI Driver] SQL30081N A communication error has been
detected. Communication protocol being used: "TCP/IP".
Communication API being used: "SOCKETS". Location where the
error was detected: "9.184.56.80". Communication function
detecting the error: "connect". Protocol specific error
code(s): "10061", "*", "*". SQLSTATE=08001 "
Can anyone tell me wht it is..... pls let me know wht i have to
do........
Regards
kamal

Jun 28 '06 #1

Subscribe Post Reply

1494

Larry

Gladiator wrote:

hai everyone......

A small issue here........ I was trying access a
remote database....... i issued the following commands.....

db2 catalog tcpip node <node name> remote <ipaddress> server <portno>
remote_instance <instance name>

db2 catalog db <dbname> at node <node name>

the database manger is started on the remote server...

then after i am trying to connect it is giving the following
error......
" [IBM][CLI Driver] SQL30081N A communication error has been
detected. Communication protocol being used: "TCP/IP".
Communication API being used: "SOCKETS". Location where the
error was detected: "9.184.56.80". Communication function
detecting the error: "connect". Protocol specific error
code(s): "10061", "*", "*". SQLSTATE=08001 "
Can anyone tell me wht it is..... pls let me know wht i have to
do........
Regards
kamal

10061 means connection refused. You need to be a lot more specific on
platforms, os levels, DB2 levels, what you did on the server side to
enable this, etc. There are steps that need to be followed on the server
side. See the Quick Beginnings for Servers Guide and Installation and
Configuration Supplement at

http://www-306.ibm.com/software/data...manualsv8.html

Check your DB2COMM variable. Check your dbm config file on the server
side. Check your etc/services file on the server side.

Larry Edelstein

Jun 28 '06 #2

by: Google Mike | last post by:

After a lot of thought and research, and playing with FreeTDS and InlineTDS, as well as various ODBC connections, I have determined that the fastest and cheapest way to get up and going with PHP on...

PHP

Connecting to Analysis Services using HTTP

by: Ramir Santos | last post by:

my analysis server is hosted on a win2k server with IIS, the hosting page is on another machine. I have followed everything as per MS KB article and I could not connect through the analysis server...

Microsoft SQL Server

Kinds of drivers for connecting to DB2 on os390

by: TP | last post by:

Hi, This is probably my 7th post of the day. not spamming, just want to get the questions out, so that I can find the answers and post them back or some good soul can help me out. Right now I...

DB2 Database

Separate Webserver and SQL Server -- error when connecting asp.netapp to a database

by: Ann Marinas | last post by:

Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed...

ASP.NET

Connecting to MySQL

by: Jeremy Dillinger | last post by:

I am trying to design a program that will use data from a MySQL database. Currently all the data is being used with PHP scripts from a website. I am also trying to build a software solution that...

Visual Basic .NET

SSH connection script connecting to Cisco devices

by: NewsReader | last post by:

Hello, I have been looking around the net for a script to help me connect to and help gather information from Cisco routers/switches. I have pieced together a couple of different scripts from...

PHP

Pocket PC connecting to named instance of SQL Server 2000

by: cj.snead | last post by:

Hello, I am having trouble connecting to a remote named instance of SQL Server via Pocket PC. I have had absolutely no luck connecting with VS 2005 (even to a default instance), so I wen't back...

C# / C Sharp

connecting to sql express 2005 with C#

by: =?Utf-8?B?R2lkaQ==?= | last post by:

Hi, I've my win32 application which connecting to my sql database. till now i used MSDE as my database and now i want to upgrade to sql express 2005. after the upgrade i tried to connect to the...

C# / C Sharp

Error connecting to V9 remote database

by: mairhtin o'feannag | last post by:

Hello, I'm having problems connecting to my new v9 db box. The pertinent information is below: DB2_db2inst1 60000/tcp DB2_db2inst1_1 60001/tcp DB2_db2inst1_2 60002/tcp DB2_db2inst1_END...

DB2 Database

Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote

by: aboutjav.com | last post by:

Hi, I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property ...

ASP.NET

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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,...

General

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics