Can't log in using .NET Provider (invalid username/password)

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

.

Relevant Pages

  • Re: Login issues
    ... Depending on the computer or username, ... There is not way to enter to the database using ... If I enter as usual from my computer, the FM server automatically ... Perhaps someone changed your script, or the user name on your computer, or the default account in File Options. ...
    (comp.databases.filemaker)
  • ASP.NET & Integrated Security setup?
    ... integrated security in your connection string. ... I tried this in test page to connect to the Northwind ... have it's own ASPNET-type account so it only has accesses ... Northwind site and the Northwind database) ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Help with connection string
    ... The connection string looks correct. ... Is that E drive accessible to the user account under whose context the ... IIS process is running (if your website has Anonymous enabled, ... connect to an unpassworded Access 2007 database for use in a small ...
    (microsoft.public.inetserver.asp.db)
  • Re: Delph7 + ADO conenction to advantage & oracle
    ... >connect to a database and then login to the program based on matching the ... >supplied username & password with a username and password stored in a table ... You connect to and OleDb connection using a connection string. ... your next step is to find the username and password the user provides on login ...
    (borland.public.delphi.database.ado)
  • Re: Getting User Info
    ... database, but now the user is my Windows account. ... connection string as Uid, as well as User ID and it still comes back the same. ... >> elevated access in order to do the migration, and that is alot of sprocs. ...
    (microsoft.public.dotnet.framework.adonet)