By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,424 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,424 IT Pros & Developers. It's quick & easy.

Emergency

P: n/a
I found the problem is the conneciton string seems did not take effect. Does
any one met this problem? I dragged connection string from Server exploer in
Visual Studio into web form. the form in this time only one dropdown list
box. and only one line code that tried to open the connection. I changed the
connection user id to I created login id, but SQL server still use the
blank name to login to the sql server. How do I resolve this?

Shawn
Nov 16 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
where did you change the database login details? (I'm assuming in
InitialiseComponent?)

SqlConnection con = new SqlConnection(<connection_string.);
con.Open();

check out http://www.connectionstrings.com/ for help on connection strings.

HTH
sam

"Shawn Zheng" <sz********@rogers.com> wrote in message
news:en**************@TK2MSFTNGP10.phx.gbl...
I found the problem is the conneciton string seems did not take effect.
Does
any one met this problem? I dragged connection string from Server exploer
in
Visual Studio into web form. the form in this time only one dropdown list
box. and only one line code that tried to open the connection. I changed
the
connection user id to I created login id, but SQL server still use the
blank name to login to the sql server. How do I resolve this?

Shawn

Nov 16 '05 #2

P: n/a
also make sure trusted_connection=false (or not present) if you're passing
in username and password

"Shawn Zheng" <sz********@rogers.com> wrote in message
news:en**************@TK2MSFTNGP10.phx.gbl...
I found the problem is the conneciton string seems did not take effect.
Does
any one met this problem? I dragged connection string from Server exploer
in
Visual Studio into web form. the form in this time only one dropdown list
box. and only one line code that tried to open the connection. I changed
the
connection user id to I created login id, but SQL server still use the
blank name to login to the sql server. How do I resolve this?

Shawn

Nov 16 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.