cannot open database

[Ashlesha pude]

i am doin project using vb.net 2005 and using this sql query for connection
sql = "select username from login order by username"
con.ConnectionS tring = "Data Source=" & hostname & "; Initial Catalog=college ;integrated security=sspi"
but m getting the following error:
Cannot open database "college" requested by the login. The login failed.
Login failed for user 'CI4\Admin'.

[MrMancunian]

Does 'CI4\Admin' have access to your database? And do you realize that in the piece of code you posted, the sql query (sql = "select username from login order by username") isn't executed?

Steven

[tlhintoq]

i am doin project using vb.net 2005 and using this sql query for connection
sql = "select username from login order by username"
con.ConnectionS tring = "Data Source=" & hostname & "; Initial Catalog=college ;integrated security=sspi"
but m getting the following error:
Cannot open database "college" requested by the login. The login failed.
Login failed for user 'CI4\Admin'.

That's a description of conditions. What is your QUESTION?

[Ashlesha pude]

yss (sql = "select username from login order by username") isn't executed.
CI4 is the newly changed computer name and it cant access database

[MrMancunian]

yss (sql = "select username from login order by username") isn't executed.
CI4 is the newly changed computer name and it cant access database

So, perhaps that is the reason the login failed?

Steven

[tlhintoq]

yss (sql = "select username from login order by username") isn't executed.
CI4 is the newly changed computer name and it cant access database

please see this thread with same issue

[MrMancunian]

ROFL, didn't even see that...Well, you've got to give him credit for doing some more explaining :-p

Steven

[Frinavale]

Please take a look at the article called How to use a database in your program for an example of how to create an SQL query using parameters.

-Frinny