AllExperts > Ingres 
Search      
Ingres
Volunteer
Answers to thousands of questions
 Home · More Ingres Questions · Answer Library  · Encyclopedia ·
More Ingres Answers
Question Library

Ask a question about Ingres
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Jean-Pierre Zuate
Expertise
Any questions about database Ingres (owned by Computer Associates then Ingres Corp) : - Ingres 6.4 - OpenINGRES from 1.0 to 2.0 - IngresII from 2.0 to 2.6 - Ingres R3, Ingres 2006 (Open Source version) - All tool around Ingres : ABF, Report Writer, Replicator, OpenROAD (3.5 to 2006), Ingres/NET Ingres/STAR, ...

Experience
16 years of computing experience as :
- AS400 programmer
- AIX / Ingres administrator and developer (OpenROAD and korn shell)
- Ingres DataBase Administrator
- Ingres expert - Data modelisation - ETL - Reporting - Many of Computer Associates sofwares - ITIL / CMDB / Change Management

Organizations
http://lafageconseil.fr

 
   

You are here:  Experts > Computing/Technology > Databases > Ingres > Client - Server Connection Problems

Ingres - Client - Server Connection Problems


Expert: Jean-Pierre Zuate - 12/13/2008

Question
I have on my Windows XP Pro installed Ingres Client (Ingres2006-9.1.-103).
I am trying to connect to Ingres Server on Solaris 10 (Ingres 2006 Release 2).
I did setup netutil on both ends. I am able to Test successfully connection from the server to the client and vice versa. I am utilizing the Installation Password - same on the server and client.
I am able to display Nodes Defined on Selected Node (the server) from the client. Unfortunately, when it comes to trying other utilities from client (like Ingres Visual SQL or Ingres Journal Analyzer) I am being prompted for a password. I tried the same Installation Password I used for setting up Ingres on both connections, then I tried any other password that might be associated with user or process on either end (client or server). Nothing works. I am receiveing errors - see attached file. I spent few days trying to make it work but with no success. I would appreciate your help. Thank you. Greg

Answer
Hello,

When Ingres ask you for a password when you are using a vnode and you did not expect to give one, it mean the user involved in the connection is not knowed in the target Ingres server installation.

This is often the case when you are using installation passwords for the first time.

Suppose on your Windows Server (with Ingres client installed) you connect to windows with the user tom (it mean the DOS variable USERNAME is valued to "tom"). Then you use the installation password between your client (windows) and your server (solaris). But the user "tom" is not known in your target ingres installation.

You must try to create this user on the solaris side, by using the ingres utility "accessdb".

Hope this help you,

Regards,
Jean-Pierre ZUATE
http://lafageconseil.fr

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.