473,804 Members | 3,190 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Cannot Connect in DB2 Control Center

Hello,
>From the 'Object View' in Control Center, I right click on the
database in the left panel and select 'Query'. The 'Enter Credentials'
box appears, and I type in my User ID and Password. The password
contains an exclamation mark. When I attempt to connect with my
credentials, I get the following error message:

------------------------------ Commands Entered
------------------------------
connect to (server) user (user Id) using ********;
------------------------------------------------------------------------------
connect to (server) user (user ID) using !2Dw
SQL0104N An unexpected token "!" was found following "<identifie r>".
Expected tokens may include: "NEW". SQLSTATE=42601

SQL0104N An unexpected token "!" was found following "<identifie r>".
Expected tokens may include: "NEW".

Explanation:

A syntax error in the SQL statement was detected at the specified
token following the text "<text>". The "<text>" field indicates
the 20 characters of the SQL statement that preceded the token
that is not valid.

As an aid to the programmer, a partial list of valid tokens is
provided in the SQLERRM field of the SQLCA as "<token-list>".
This list assumes the statement is correct to that point.

The statement cannot be processed.

User Response:

Examine and correct the statement in the area of the specified
token.

sqlcode : -104

sqlstate : 42601
*************** *************** **********
I've tried to input the password in single and double quotes. How do I
correctly express the password?

Thank you for your help!

cdun2

Nov 14 '07 #1
0 1636

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

Similar topics

1
2247
by: revolnip | last post by:
As attached is the code : <% Option Explicit dim lngTimer lngTimer = Timer %> <!--#include file="Connect.asp" --> <!--#include file="Settings.asp" --> <!--#include file="Common.asp" -->
0
8340
by: Kyle Goetz | last post by:
hey, i'm new to mySQL...this meaning that i have tried ~10000 times to install it and get it working over the past few weeks...and it always gives me the same error (scroll further down to see it) despite following the manual's windows installation exactly i have version 4.0.13 for windows and i used the installer once i was done, i followed the instructions in the manual exactly i have no firewall running
0
2947
by: Jim | last post by:
I'm working on my first .net project using c#. I've been using activex controls embedded in a web page and wanted to do the same in ..net. My approach has been to create a windows control library and then reference the dll with a web page as follows: <html> <body> <center> <object id="UserControl1" height="500" width="700" classid="http://wiffle/WindowsControlLibrary3.dll#WindowsControlLibrary3.UserControl1">
3
4976
by: Burkhard Schultheis | last post by:
I'm able to connect to a local DB2 database, but unable to connect to a remote DB2 database from Crystal Reports XI. In the control center I have no problems connecting to the remote databases. SQLCODE is 30081, SQLSTATE 8001. Local DB2 is V8.2.2, remote databases are 7.2 and 8.2.0. What can I do? Regards, --
10
6470
by: Andy K | last post by:
Hi again , I've been trying to connect to a distant database with my control center on WinXp . I'm using a personnal edition DB2 v8.1.9.700 for the control center on WinXp. I've setup a node (a distant connection ) in order to reach this distant database but it doesn't seem to work ... The distant database
1
2067
by: Racerx | last post by:
Hi all: I use db2 v8.1 on aix 5.2 I cannot connect to the database through clp or control center. all the background processes are running when checked using ps -eaf command. The das is also on. Can anyone suggest me a way
12
3821
by: bb nicole | last post by:
I have do a update profile for company where they can update after view their profile, but it cannot function... I need to submit the whole job portal soon, but still got many problem in my coding, could someone help me... Thanks a lot.. Below is the error: Notice: Undefined index: company_ID in C:\Apache2\Apache2\htdocs\comProfile_update.php on line 28 where line 28 is if(is_numeric($_GET)) { My whole coding as below: <?php ...
3
2123
by: bb nicole | last post by:
Below is my job post code, it cannot post into database... WHAT IS THE PROBLEM OF IT?? <?php session_start(); ob_start(); //connect to server and select database
0
1077
by: SecretSquirrel | last post by:
Hi, I have created a small local web app with ASP.NET. I run Microsoft Application Center Test and create a new test project. Then, I create a new test dynamically. MS ACT pops up a new browser window for me to execute my test in. When I run the test, I get a connection error - "Internet Explorer cannot
0
9706
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
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
10332
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
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
5651
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4300
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
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.