Wednesday, March 7, 2012

ODBC SQL Server error

I have a ASP.Net application. I'm trying to access access data using SQL Server

my web config has

<addkey="connectionString"value="DRIVER={Sql Server};Server=(local);initial catalog=ymquizco_registration;User ID=sa;pwd=test"/>

MY CONNECTION STRING HAS THIS VALUE

"DRIVER={Sql Server};Server=localhost;initial catalog=ymquizco_registration;User ID=sa;pwd=test"

But the conn.Open();is throwing this error:

{"ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\\ASPNET'.\r\nERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute\r\nERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WORK\\ASPNET'.\r\nERROR [01S00] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute" }

My SQL Server is configured at mixed mode authentication. This seems like a install issue. Can someone think of something.

Fromhttp://www.connectionstrings.com, your connection string should look more like this:
Standard Security:

"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"


No comments:

Post a Comment