The connection's current state is closed.

[anguna...@yahoo.com]

Hi,

Great tool you have!

May I know why I'm getting the error below?

---
I provided the connectionstring by following here (http://www.risetobloome.com/Page_1_S.aspx?ITEM=1525) but I'm still getting errors below.

ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
ERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute

10/4/2010 6:58:34 PM
ExecuteReader requires an open and available Connection. The connection's current state is closed.
---

I provided the correct connectionstring by following here (http://www.risetobloome.com/Page_1_S.aspx?ITEM=1525), the connection I use is the same connection from my web.config file but I'm still getting the above error.


Thanks,
Jim

[Ola Hellgren]

Hi,

Thanks!

There was an error, fixed now, on the help page, providing a
misleading connection string when connecting to SQL Server with
explicit userid and password. Perhaps, that's the one you're using? If
so, it should be:

Driver={SQL Server}; Server=myServerAddress; Database=myDatabase;
Uid=myUserID; Pwd=myPassword;

Also, if connecting to SQL Server using windows authentication is an
option use this instead for security reasons.


Regards,
Ola