VB 2008 And SQL Database

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Martin Racette

    VB 2008 And SQL Database

    Hi,

    I have installed VB2008 Express a few months ago, and yesterday I was trying
    to create a new program and that program requires the use of a database, so
    I tried to create the SQL database, but I get an error message that tells me
    that I do not have the appropriate autorisation to create an SQL database,
    and I need to create it manually

    How do I do that, or better yet how do I correct VB so that I can create the
    database from within

    --
    Thank You in Advance
    Merci a l'avance

    Martin

  • Cor Ligthert[MVP]

    #2
    Re: VB 2008 And SQL Database

    Hi,

    This has nothing to do with VB, the same problem you can have with notepad,
    install your SQL server in the way that you are authorisezed as user to use
    it.

    Cor

    Comment

    • Michel Posseth  [MCP]

      #3
      Re: VB 2008 And SQL Database

      You might start by providing the apropriate rights

      :-)

      Michel



      "Martin Racette" <rat7_2001@hotm ail.comschreef in bericht
      news:387245ED-CBD7-4E9B-B9EF-E253E51B7368@mi crosoft.com...
      Hi,
      >
      I have installed VB2008 Express a few months ago, and yesterday I was
      trying to create a new program and that program requires the use of a
      database, so I tried to create the SQL database, but I get an error
      message that tells me that I do not have the appropriate autorisation to
      create an SQL database, and I need to create it manually
      >
      How do I do that, or better yet how do I correct VB so that I can create
      the database from within
      >
      --
      Thank You in Advance
      Merci a l'avance
      >
      Martin

      Comment

      • Miro

        #4
        Re: VB 2008 And SQL Database

        Are you running vista?

        Before you run vb, try right clicking on it, and click on "run as
        administrator"

        If that works, that means that you installed it somehow so your regular user
        does not have all the rights.

        "Martin Racette" <rat7_2001@hotm ail.comwrote in message
        news:387245ED-CBD7-4E9B-B9EF-E253E51B7368@mi crosoft.com...
        Hi,
        >
        I have installed VB2008 Express a few months ago, and yesterday I was
        trying to create a new program and that program requires the use of a
        database, so I tried to create the SQL database, but I get an error
        message that tells me that I do not have the appropriate autorisation to
        create an SQL database, and I need to create it manually
        >
        How do I do that, or better yet how do I correct VB so that I can create
        the database from within
        >
        --
        Thank You in Advance
        Merci a l'avance
        >
        Martin

        Comment

        • Martin Racette

          #5
          Re: VB 2008 And SQL Database

          But it was runnig just fine in VB2005 Express, and I did not touch the
          installation of SQL

          "Cor Ligthert[MVP]" <notmyfirstname @planet.nlwrote in message
          news:505DE8D3-F255-4BD1-875D-5013975744DA@mi crosoft.com...
          Hi,
          >
          This has nothing to do with VB, the same problem you can have with
          notepad, install your SQL server in the way that you are authorisezed as
          user to use it.
          >
          Cor
          --
          Thank You in Advance
          Merci a l'avance

          Martin

          Comment

          • Martin Racette

            #6
            Re: VB 2008 And SQL Database

            And how do I do that, when I was using VB2005 Express, everything was
            working fine

            "Michel Posseth [MCP]" <MSDN@posseth.c omwrote in message
            news:OsCepf4eIH A.1168@TK2MSFTN GP02.phx.gbl...
            You might start by providing the apropriate rights
            >
            :-)
            >
            Michel
            >
            >
            >
            "Martin Racette" <rat7_2001@hotm ail.comschreef in bericht
            news:387245ED-CBD7-4E9B-B9EF-E253E51B7368@mi crosoft.com...
            >Hi,
            >>
            >I have installed VB2008 Express a few months ago, and yesterday I was
            >trying to create a new program and that program requires the use of a
            >database, so I tried to create the SQL database, but I get an error
            >message that tells me that I do not have the appropriate autorisation to
            >create an SQL database, and I need to create it manually
            >>
            >How do I do that, or better yet how do I correct VB so that I can create
            >the database from within
            >>
            >--
            >Thank You in Advance
            >Merci a l'avance
            >>
            >Martin
            >
            >
            --
            Thank You in Advance
            Merci a l'avance

            Martin

            Comment

            • Martin Racette

              #7
              Re: VB 2008 And SQL Database

              I'm running Vista, and whether I start it in Administrator mode or not I
              still can not create a .mdf database

              "Miro" <miro@beero.com wrote in message
              news:O4pIsn%23e IHA.4164@TK2MSF TNGP05.phx.gbl. ..
              Are you running vista?
              >
              Before you run vb, try right clicking on it, and click on "run as
              administrator"
              >
              If that works, that means that you installed it somehow so your regular
              user does not have all the rights.
              >
              "Martin Racette" <rat7_2001@hotm ail.comwrote in message
              news:387245ED-CBD7-4E9B-B9EF-E253E51B7368@mi crosoft.com...
              >Hi,
              >>
              >I have installed VB2008 Express a few months ago, and yesterday I was
              >trying to create a new program and that program requires the use of a
              >database, so I tried to create the SQL database, but I get an error
              >message that tells me that I do not have the appropriate autorisation to
              >create an SQL database, and I need to create it manually
              >>
              >How do I do that, or better yet how do I correct VB so that I can create
              >the database from within
              >>
              >--
              >Thank You in Advance
              >Merci a l'avance
              >>
              >Martin
              >
              --
              Thank You in Advance
              Merci a l'avance

              Martin

              Comment

              Working...