open database

• mhh12

  Mr or Mrs. 500

  Points: 577

  More actions

  February 17, 2010 at 3:33 pm

  #220709

  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.SqlClient

  Partial 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?

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  February 17, 2010 at 4:36 pm

  #1120559

  Dim _cnString as string = ConfigurationManager.ConnectionStrings("VanillaConnectionString").ConnectionString

  Dim cn As New SqlConnection(_cnString)

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]