Printable View
Resolved
Dim oSQLConn As SqlConnection = New SqlConnection
oSQLConn.ConnectionString = "Data Source=(local);" & _
"Initial Catalog=Con_Test;" & _
"Integrated Security=SSPI"
oSQLConn.Open()
this doesnt work as i get an error,
login failed for user 'computername'
Line 33: "Initial Catalog=Con_Test;" & _
Line 34: "Integrated Security=SSPI"
Line 35: oSQLConn.Open()
Line 36:
Line 37:
anybody any ideas of connecting to a databse for asp.net
i really want to get connected but cant
Mmmmmm.... try looking here: ConnectionString.com it looks as though your connectionstring isn't quite right.
Also, make sure that the user you are loging in as has permissions to the server & database. You may think you are loging in as yourself, but ASP runs under it's own user context and logsin to database as that ASP user.
Tg
how do i go about changing the permissions????, i was trying to write to a text file as a test and access was denied this may be my stumbling block,
thanks keep the change
yeah it connects , thanks a million buddy ;)
SO, does it work now then? Or is there still a problem?
Tg
sorry i didnt edit the message too good.
aye she connects now for theres no errors coming up.
what now would be my next plan of action, after the connection.
i want to have like a registration page and want to write then from the textboxes to the database.