Datablade List Forum

Re: Connectivity problems with DDW application.

Posted By:
Date:

I just thought of one more thing to check (if re-creating sysmaster
doesn't fix your problem):
I vaguely remember one case where one user of DDW could not connect to IDS
(while other users in the same shop could connect). As I recall, there
was some problem with case (upper vs. lower). The server name or host
name in SetNet32 (either the server / host name in the "Server
Information" tab, or the host name in the "Host Information" tab, or
possibly INFORMIXSERVER in the "Environment" tab) was upper case, but the
host / server name on the IDS server machine (server / host in sqlhosts,
and/or possibly DBSERVERNAME / DBSERVERALIASES in onconfig) was in lower
case. Or something like that. I think DDW insists that a given value
(host or server) be the same case everywhere, even though other Informix
client apps don't. Sorry so vague...

Changing the case of the name in SetNet32 (in the "Server Information" or
"Host Information" tabs) might have been tricky: might have had to rename
the server / host to something else, then back to the right name in the
right case; or simply delete the entry and re-create it. Or directly edit
the registry entries (*carefully*): run regedit.exe, find key
HKEY_LOCAL_MACHINE\SOFTWARE\Informix\SQLHOSTS\
, find your server key, and rename either the key (server name) or the
value data for value name "HOST".


HTH. Let me know whether any of this works!

Regards,
- Don

Donald E. Payne -- Sr. IT Specialist
IBM Software Services for Data Management, OLTP Practice
phone / fax / pager 212-745-4380 (tie 243-4380)
mobile office: New York, NY
Certified IBM Informix Professional
http://www.ibm.com/software/data




Kam Bernard <bernard_kam2002@yahoo.com>
03/18/2003 08:18 AM


To: Donald Payne/New York/IBM@IBMUS
cc:
Subject: Re: Connectivity problems with DDW application. [9]



Hi Donald,
Sorry for late reply, pls see my comments embedded on your emails,
Thanks and best regards,
Bernard.
Donald Payne <payned@us.ibm.com> wrote:
> Are you thinking that DDW Site Manager tries to connect first to
> sysmaster, before connecting to your database with the Web Blade
> registered? Maybe it does, I don't know. It does need to get a list of
> databases, to display them in the left pane; and sysmaster would have
that
> list. Does Site Manager display that list?
It just not display the list of database belonging to instance server
db_sales, other databases belonging to another instance server is listed
here when i set up them via setnet32.


> When Site Manager is failing to connect to database "sales", can you run
> onstat -g sql
> and see what the SQL and ISAM error codes are for the Site Manager
> session? (Since Site Manager is not nice enough to tell you...) Also,
> what database is Site Manager connected to, sysmaster, sales, or none?
Site Manager often fails to connect to instance server db_sales listed at
left panel with error mesg "Failed to connect to db_sales" , at CLI prompt
, i can use informix utility to work with databases belonging to db_sales
well, onstat- g sql allows us to see what userthread/session doing by SQL
command, Site Manager intended to connect to all databases withing
db_sales.



> From SQL Editor, can you connect to sysmaster@db_sales and execute this?
> SELECT * FROM sysdatabases ORDER BY 1;
Yes, it's no problem.

> From Site Manager, can you connect to another database in server
db_sales?
No, because as mentioned that at first time when i connect to server
db_sales via Site Manager, the problem issued as mentioned, so that i can
not connect to any databases in server db_sales.
(If no others exist besides "sales", create one.)

> If you think sysmaster is damaged, I believe you can rebuild it. As user

> informix, run the script $INFORMIXDIR/etc/buildsmi (on Win NT,
> buildsmi.bat).
Ok, if this can help me to resolve this.

HTH.
Regards,
- Don

Donald E. Payne -- Sr. IT Specialist
IBM Software Services for Data Management, OLTP Practice
phone / fax / pager 212-745-4380 (tie 243-4380)
mobile office: New York, NY
Certified IBM Informix Professional
http://www.ibm.com/software/data




"Kam Bernard "
Sent by: forum.subscriber@iiug.org
02/28/2003 01:15 AM


To: datablade-list@iiug.org
cc:
Subject: Connectivity problems with DDW application. [7]


Hi Friends,

Before i could still operate with my database for web site management
deals by DDW2.0 (Data Directory Web application) but now the problem
issused that prevented me from accessing to this database (e.g: my
database named "sales" on database server named db_sales), the only error
message said that "failed to connect to DB": db_sales"), however i can
still ! connect & work with this database via SQL editor normally, also
operating well with other database servers that i had established
connections to them via setnet32 setting.

My Questions: in case of the problem above, what right procedure to
correct this problem, i suppose that the databse sysmaster on db_sales but

i don't know which portion of sysmaster is damaged or wrong ?.

Anyone know this, pls teach me how to correct it.

Messages In This Thread

• Connectivity problems with DDW application.
  Kam Bernard -- Friday, 28 February 2003, at 1:15 a.m.
  • Re: Connectivity problems with DDW application.
    Kam Bernard -- Monday, 3 March 2003, at 1:21 a.m.
  • Re: Connectivity problems with DDW application.
    Donald Payne -- Tuesday, 4 March 2003, at 11:39 a.m.
    • Re: Connectivity problems with DDW application.
      Donald Payne -- Tuesday, 18 March 2003, at 10:48 a.m.
      • Re: Re: Connectivity problems with DDW application.
        OZ SHIMONY -- Wednesday, 19 March 2003, at 12:14 a.m.

Datablade List Forum is maintained by Administrator with WebBBS 5.12.