If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Connect to database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-09-05, 16:44
stanislav.ondac stanislav.ondac is offline
Registered User
 
Join Date: Aug 2005
Posts: 140
Connect to database

Hi
I create two system users on windows XP.
When I try to connect to database as one of these users(or user informix) -with ILogin Demo (from Client SDK 2.81) it works fine.
But when I try connect from Borland C++ builder (with using IDAC-Informix
Data Access Components) it works only when I connect as user "informix".
When I try to connect as some other user I got an error "951 Incorrect pasword or user XY is not known on the database server.

I dont understand why it works with ILogin Demo but not with Borland C++.

Thanks for any help.
Reply With Quote
  #2 (permalink)  
Old 11-10-05, 07:03
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Hi,

You must grant permissions into Informix for new user.
Run dbaccess, then Query--->New, and run grant connect to username;

Gustavo.
Reply With Quote
  #3 (permalink)  
Old 11-10-05, 07:49
stanislav.ondac stanislav.ondac is offline
Registered User
 
Join Date: Aug 2005
Posts: 140
I granted permissions fot new users at the begining , after ILogin demo got me an error.
After that ILogin could connect but not my application in C++ Builder.
I also checked sysusers table in my database and there are permissions for my users. (first has connect permission , second has resource permission).
Reply With Quote
  #4 (permalink)  
Old 11-10-05, 09:26
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Hi,
run you setnet32 and defined new user ?
Please remember that the new user should not belong to a domain, should be local.

Gustavo.
Reply With Quote
  #5 (permalink)  
Old 11-10-05, 10:05
stanislav.ondac stanislav.ondac is offline
Registered User
 
Join Date: Aug 2005
Posts: 140
Now I ran my Setnet32 and defined new user than apply, than defined second user than apply than make default server.
But C++ Builder always get an error: 951 Incorrect pasword or user XY is not known on the database server

My users are local, on the same machine as informix server.
Reply With Quote
  #6 (permalink)  
Old 11-11-05, 06:33
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Hi,
Please take one user to Informix-Admin group, then test connect.

Gustavo.
Reply With Quote
  #7 (permalink)  
Old 11-11-05, 13:53
stanislav.ondac stanislav.ondac is offline
Registered User
 
Join Date: Aug 2005
Posts: 140
I change the users account type from Limited to Administrator, then I add users to Informix-Admin group and suddenly I can connect do database
But then I change user account type back to Limited and remove user from Informix-Admin group and I can still connect to databse.
Strange but it works now.

Thank you
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On