Professional Web Applications Themes

TO CONNECT A DATABASE TO MSDE - Microsoft SQL / MS SQL Server

I have an application that uses MSDE as base of data. I already know as installing MSDE in my customer, however I am not getting to execute the command correctly to register the database in MSDE, without the aid of Access. I already read everything that had at the Forum, but even so I didn't get. I already consulted the Manual Online. I only need to know which the command to access my database for my application. I already tried: osql healthy /U /P " " /S nameserv /??? and now...

  1. #1

    Default TO CONNECT A DATABASE TO MSDE

    I have an application that uses MSDE as base of data. I already know as
    installing MSDE in my customer, however I am not getting to execute the
    command correctly to register the database in MSDE, without the aid of
    Access. I already read everything that had at the Forum, but even so I
    didn't get. I already consulted the Manual Online. I only need to know which
    the command to access my database for my application. I already tried: osql
    healthy /U /P " " /S nameserv /??? and now


    Frank Guest

  2. #2

    Default Re: TO CONNECT A DATABASE TO MSDE

    I think what you need is either

    if you are on a domain or on a NT/2K/XP workstation
    OSQL -E -d"master"
    -OR-
    if you are on 9x/Me
    OSQL -U"username" -P"password" -d"master"

    Then all you should need to do is
    1>sp_attach_single_file_db 'c:\MyDir\MyDatabase.mdf'
    2>go

    IF you don't have a database file already you can script out the CREATE
    batches and run them with the -i switch of OSQL.

    HTH

    Semper Fi,
    Red
    "Frank Dulk" <com.br> wrote in message
    news:%phx.gbl... 
    which 
    osql 


    Stephen Guest

  3. #3

    Default Re: TO CONNECT A DATABASE TO MSDE

    Hi Frank,

    If you ahven't done anything special to your MSDE installation and your are
    logged on as a member of the local Windows administrators group you should
    be able to connect to it using NT Autentication with:
    osql -E

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Frank Dulk" <com.br> wrote in message
    news:%phx.gbl... 
    which 
    osql 


    Jacco Guest

Similar Threads

  1. Can not connect to database
    By tomrippity02 in forum Coldfusion Database Access
    Replies: 3
    Last Post: April 7th, 05:19 AM
  2. Cannot connect database
    By A-Face in forum ASP Database
    Replies: 9
    Last Post: October 4th, 09:37 PM
  3. How to use “RDS.Connect” to connect to a MS Access database?
    By hannaman@msn.com in forum ASP Database
    Replies: 0
    Last Post: August 2nd, 11:09 PM
  4. VERY frustrated -- can't connect to MSDE
    By Jeff Cooper in forum ASP Database
    Replies: 1
    Last Post: September 25th, 01:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139