[Info-Ingres] Can't log in using .NET Provider (invalid username/password)

[Bobby]

Hi,

I'm very new to Ingres. I've installed ingress successfuly and created
a database with a table. I have a .NET application which accessed the
database with an ODBC connection to the database with the following
connection string

"Provider=MSDASQL.
1;"DRIVER=Ingres;SRVR=MyServer;DB=MyDb;Uid=MyUser;Pwd=;"

This all works fine, with an account i created with no password. I
then discovered the .NET provider (ca.Ingres.Client namespace). I've
changed the code to use the .NET classes and have the following
connection string:

"Host=MyServer;DatabaseMyDb;User ID=" MyUser;Password=;"

When i try this and open the connection, i get an exception saying
that the password cannot be blank. I then tried putting a password on
the account, but when i pass in the username & password, it always
tells me the username/password are incorrect. I then tried the ODBC
version with the passworded account and it gets the same problem.

I've double checked the username & password and they are correct. Can
anyone please tell me why i cannot use a blank password using .NET
provider, and why i cant connect with .NET or ODBC when i put a
password on thh account?

Thanks in advance.

Regards

Bobby