473,804 Members | 2,998 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Connected, Unable to Work

Hello All,

I've got an odd situation on my hands, and I'm hoping someone here can
help. I've got DB2 v8.1 Express Edition set up on a Windows 2000 Server
system, and it appears to be working properly: I took all the defaults
during the install, and I can connect to and manipulate it via the
local Control Center.

However, when I attempt to connect from a remote system -- whether it
be a Control Center on another machine or Perl's DBD::DB2 module -- I
get a very odd error:

SQL0901N The SQL statement failed because of a non-severe system erorr.
Subsequent SQL statements can be processed. (Reason "Unsupporte d
function for SPMDB connect".) SQLSTATE=58004

Unfortunately, there is *no* information whatsoever about this error's
"reason" on the web -- the one thing I've seen in all my hunting was
someone saying "call IBM, they'll know." The problem I have is that I
can't do this: since I'm actually just a security researcher trying to
verify some vulnerabilities and grab network captures, I and my company
are in no position to pay for a support license (and sadly, I doubt IBM
will give us a free one, even if we will be trying to help them by
writing Snort signatures to detect these attacks).

Does anyone have any idea what's going on here? Alternately, is there
anyone who would mind occasionally lending me the use of a DB2 database
so that I can test vulnerabilities (unlikely, but it can't hurt to
ask)?

Thanks in advance for whatever you can do.

Alex Kirk

Nov 12 '05 #1
2 3107
"schnarff" <al**@schnarff. com> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.com...
Hello All,

I've got an odd situation on my hands, and I'm hoping someone here can
help. I've got DB2 v8.1 Express Edition set up on a Windows 2000 Server
system, and it appears to be working properly: I took all the defaults
during the install, and I can connect to and manipulate it via the
local Control Center.

However, when I attempt to connect from a remote system -- whether it
be a Control Center on another machine or Perl's DBD::DB2 module -- I
get a very odd error:

SQL0901N The SQL statement failed because of a non-severe system erorr.
Subsequent SQL statements can be processed. (Reason "Unsupporte d
function for SPMDB connect".) SQLSTATE=58004

Unfortunately, there is *no* information whatsoever about this error's
"reason" on the web -- the one thing I've seen in all my hunting was
someone saying "call IBM, they'll know." The problem I have is that I
can't do this: since I'm actually just a security researcher trying to
verify some vulnerabilities and grab network captures, I and my company
are in no position to pay for a support license (and sadly, I doubt IBM
will give us a free one, even if we will be trying to help them by
writing Snort signatures to detect these attacks).

Does anyone have any idea what's going on here? Alternately, is there
anyone who would mind occasionally lending me the use of a DB2 database
so that I can test vulnerabilities (unlikely, but it can't hurt to
ask)?

Thanks in advance for whatever you can do.

Alex Kirk

Did you catalog the remote node and remote database on your client machine?
Does the remote database show up in the Configuration Assistant on the
client?

DB2 comes with a sample database that can be installed using the First Steps
program.
Nov 12 '05 #2
Yes, I've cataloged it, and Perl can actually establish a connection --
the error comes when I attempt to run any SQL statement at all, even
"select * from sample.emp_acct " (I apologize, I could have been more
clear when I posted; I'm trying to beat back a cold, I guess my brain
was a little foggy). As you can probably see from the SQL statement
here, I'm using the sample database from the First Steps tool.

Of course, it could be that I've cataloged it incorrectly somehow --
though I'm not entirely certain how I'd recognize such an error. FYI, I
cataloged the database using the Configuration Assistant tool, by
searching the network for discoverable databases.

Thanks for your help here...hopefull y this clarification will make
getting to the bottom of the a problem a little easier. :-)

Alex Kirk

Nov 12 '05 #3

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

Similar topics

3
4115
by: David N | last post by:
I got a solution that contains about 30 projects, three of which cannot be open. When I open the project, I always receive the error message "Unable to get the project file from the Web Server" My machine is running Windows 2003. My colleagues are using the same hardware and software as I do, but I am the only one running into this problem. I searched the Internet and see that quite a lot of people having the same problem in the...
3
1766
by: leveraged | last post by:
Why can I only connect to or create a web app in VS 2003 using localhost while I am connected to the internet. I have no problems using VS 2002 but for some reason I get Microsoft Development Environment dialog that says 'A connection with the server could not be established.' whnever I try with VS 2003. I've read a number of other posts (through google) but none seem to ever finish with a resolution. I suppose I could continue to work...
4
1389
by: Mindy Myers | last post by:
I have been working on a web application for a while. All of a sudden, I can only open the project when connected to the Internet. If I'm not connected, I get an error message stating that "a connection to the server could not be established." It is strange because it used to work just fine. Any help would be appreciated! Thanks!
16
4229
by: Serdar Kalaycý | last post by:
Hi everybody, My problem seems a bit clichè but I could not work around. Well I read lots of MSDN papers and discussions, but my problem is a bit different from them. When I tried to run the project in debug mode (by hitting F5) it gives an error message "Error while trying to run project: Unable to start debugging on the web server.
0
2452
by: Sam Fields | last post by:
I have found very little regarding the error "Unable to find an entry point named EnumerateSecurityPackagesW in DLL security.dll. ". I have an ASP.NET Web Service being accessed via SSL. I found a website indicating that if any of your .dll names are security.dll, it could cause this issue. I happened to have named the service that -- so I renamed the service's dll, and it still didn't work. I decided to start from scratch, and built...
1
947
by: Eitan M | last post by:
Hello, I have a .NET web application. I have a *.mdb file, the connectionString is something like : conMain.ConnectionString = "provider = microsoft.jet.oledb.4.0; data source = " _ & Server.MapPath("./db/mydb.mdb")
6
3640
by: Brad | last post by:
I have a win2003 server workstation with multiple webs, each web has it's own ip address. In VS2005, if I select to open an existing web site, select Local IIS, the dialog correctly displays a list of all of my webs, however if I attempt to open a site under and web other than localhost I receive the message: "Unable to open the Web 'http://localhost/anywebappname'. The Web 'http://localhost/anywebappname' does not exist" Obviously...
0
1909
by: NSF12345 | last post by:
Iv developed a small program that looks for a file over our network, and copy it to the location of another computer. Im using the "If FileExists("\\oldpc\main share\Folder\file.txt") Then" way of finding if the file exists, but i want to make it so that it tries to look for the computer, not the file. At the moment this is how i am finding and copying the file: If FileExists("\\oldpc\main share\Folder\file.txt") Then FileCopy "\\oldpc\main...
7
16947
by: semedao | last post by:
Hi all, I view many posts about this issue , the connected property does not tell us the current status of the socket. based on couple of suggestions of msdn , and some article here , I try to write an helper method that will tell if the socket is connected or not , but it's not working good continue to tell me that the socket is connectedeven if the other party already call shutdown(both) + close , or , even if the other party close the...
1
5718
by: Benedict Verheyen | last post by:
Hi, i get an "Unable to relay for" when trying to send an email from within my network to an email address not on my domain. I don't understand why it says "relaying" as i'm sending from an internal domain user to an external user. Email server is exchange 2003 See this trace
0
9579
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,...
0
10578
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10077
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9152
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6853
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5522
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...
0
5651
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3820
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2991
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.