Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    attach db and sql express (2000 and vb 6.0)

    in other (google site) i have see when the pregrammer use the string connection for sql express and vb it use the statement ATTACH .... ecc
    but why i must use the tipical string and not the statement ATTACH...????
    Don understand the strategy...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: attach db and sql express (2000 and vb 6.0)

    Could you explain in more detail what you mean, and perhaps post a link to the revelant website?

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: attach db and sql express (2000 and vb 6.0)

    Please edit your post and change the URL to a clickable link.

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: attach db and sql express (2000 and vb 6.0)

    http://bytes.com/groups/asp/756264-adodb-c...tion-sqlexpress

    Note:
    For future i want to use the connection in asp page...

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: attach db and sql express (2000 and vb 6.0)

    I can't find information about an Attach statement. I think you'll have to create an ADODB.Connection object with a connection string like

    ConnectionString = "Provider = SQLNCLI;" & _
    "Data Source = .SQLEXPRESS;" & _
    "Initial Catalog = <db name>;" & _
    "User ID = <username>;" & _
    "Password = <password>;"

    substituting the correct names for the database, username and password.

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: attach db and sql express (2000 and vb 6.0)

    ok tks for the good info...
    but the "dot" before SQLEXPRESS... i msut substityuite whit the or name of client where is installed the instance similar 178.254.36.148 SQLEXPRESS?
    In the string you have posted have a dubt about how to the vb code find the instance in my lan...

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: attach db and sql express (2000 and vb 6.0)

    It's worth a try. I cannot help you with that, I don't use SQL Server Express or ASP.

  8. #8
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: attach db and sql express (2000 and vb 6.0)

    no prob, tks in other case.

Posting Permissions

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