Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mark H
Starting Member
6 Posts |
 Posted - 2010-02-17 : 17:44:24
|
| Once more we can't connect to the database. We get the age old message:Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.Login failed for user 'HKRAM\Mark Hardenbergh'. HKRAM is the name of my computer. Mark Hardenbergh is, obviously, me.Which means to me there is something wrong with my user name. Anybody know what's wrong with my user name? Do I have another name? Where do I find my other name. I understand that I could use sa for my name, but that doesn't work either.Here is the code written on the default2.aspx.vb page, the code behind page.Imports System.Data.SqlClientPartial Class Default2 Inherits System.Web.UI.Page Protected Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cn As New SqlConnection("C:\DOCUMENTS AND SETTINGS\MARK HARDENBERGH\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\WEBSITE5\APP_DATA\VANILLA.MDF;user id=HKRAM\Mark Hardenbergh") Dim cmd As New SqlCommand With cmd .CommandType = Data.CommandType.StoredProcedure .CommandText = "mhhtrial" .Connection = cn .Connection.Open() .ExecuteNonQuery() .Connection.Close() .Dispose() End With End Sub No doubt everyone can recognize what I am trying to do. I am trying to perform the simple taks of running a stored procedure. It is in a database called vanilla.mdb. And, yes, it exist there. However I can't get to square 1 because the fool thing won't let me connect to vanilla.mdb.As you can imagine, I have a gridview that finds a table in vanilla.mdb and displays it beautifully. When I do gridviews and have the connection string turning up in web.config, there is no problem.The connection string that is in the web.config file is: <add name="VanillaConnectionString" connectionString="Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\Vanilla.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />It certainly would be nice, since this connection string obviously works, if I could use it in the vb in the code behind page. But, so far, no forum wants to explain that, much less any book I have bought.Can anyone straighten out this Dim cn as New SqlConnection....... out so I can move along? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
open database