I have installed ingres.
I have created the user tester and have created my database under this user.
My problem seems to be when I try connecting to the database as this user. I have used odbc and dotnet and each are complaining of bad username/password.
Do I have to do something in particular to enable me to connect to this database as these users?
Thank you
Andreas
Answer Hello Andreas,
First, you must distinct 2 way of working with users : os mode and Ingres mode.
In Ingres world, you do not need a ling 1 for 1 between OS user and Ingres User. The owner of a database must exist in Ingres (cf accessdb) but do not exist necessary on OS (/etc/passwd for Unix and so on).
In your case when you try to access your database via ODBC you are using a node (Ingres/NET, cf netutil).
When Ingres complain about user and password it mean "os user and os password". Your client app (ODBC in fact) use and ingres node (created or updated via netutil) to connect to the remote machine (the machine where Ingres is installed). In this case the user and password mentionned in the node must match with the server definition.
If you are on the same machine (on Windows for example) and Ingre still complain about password it is perhaps because the user (OS level) you are using to connect to is not known by Ingres. For example :
1/ I install Ingres R3 as user "mat" on WNT
2/ logoff and logon with the user "bob"
3/ as "bob" is not known in accessdb, the command "isql iidbdb" will prompt for a password
