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 > Using Ilogin

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-22-09, 12:10
minhaj_arif minhaj_arif is offline
Registered User
 
Join Date: Apr 2009
Posts: 21
Using Ilogin

Hi,
I am new to Informix, and my understanding is ILogin is used to login into Informix and create database tables etc like you login into oralce and create tables etc if i am wrong please correct me
When I use ILogin and press run it will ask for a host of information like
server name, user name, password , protocol name etc
After i put in all the information and press Ok I get the error
Sql Code = -951
I look up the error and it says:

[I]User username is not known on the database server.

The database server that you tried to access does not accept either your user ID, the login name that is specified for the desired server host in your ~/.netrc file, or the user name that is specified in the USER clause of a CONNECT statement. If you are explicitly specifying your user name in the ~/.netrc file or in a CONNECT statement, check that the name is correct. If you do not have a valid user ID on the server computer, see your system administrator. This message appears with Version 6.0 and later.
[/I]

DO HELP ME WITH THIS ERROR
Reply With Quote
  #2 (permalink)  
Old 04-23-09, 03:43
stanislav.ondac stanislav.ondac is offline
Registered User
 
Join Date: Aug 2005
Posts: 140
Do you log-in with the informix user name?
Does the user exist on you server? It has to be regular operating system user(not just database user, like in oracle) and should be a member of Informix-Admin group.

As i remember, ilogin utility is just demonstration program for testing a connection to the database server.
For createing tables etc. use dbaccess(part of the informix installation) utility or some another sql client.
Reply With Quote
  #3 (permalink)  
Old 04-23-09, 06:59
minhaj_arif minhaj_arif is offline
Registered User
 
Join Date: Apr 2009
Posts: 21
Yes I Login with the Informix USer Name.
Yes it is a regular Operating system User as INformix when installed on your personal ps creates a user by the name INformix which has admin rights
I have installed informix v 11.5 on my personal pc am not connected to any server over the network etc
and IF "ILogin Demo" is just a demostrated program for testing a coonection tht means it is not getting connected with the database when it shows the above error and "ILogin Demo" came in coupled with the informix v11.5
i have tested the connection by going to control panel-->administrativr tool-->DataSource---> etc and it passes the test
I Hope you can help me with this regard
Reply With Quote
  #4 (permalink)  
Old 04-23-09, 07:26
rootdbs rootdbs is offline
Registered User
 
Join Date: Feb 2009
Posts: 51
Can you connect to your database through dbaccess?
Reply With Quote
  #5 (permalink)  
Old 04-23-09, 07:26
stanislav.ondac stanislav.ondac is offline
Registered User
 
Join Date: Aug 2005
Posts: 140
see my older thread, maybe something helps you:
Connect to database
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