Database throwing 'attempt to attach an auto-named database for file....' error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • robertybob
    New Member
    • Feb 2013
    • 116

    #1

    Database throwing 'attempt to attach an auto-named database for file....' error

    Hi,

    I am packaging a single downloadable file via Inno Setup from a VB setup file and all is fine. However when it reads the following db connection line ....
    Code:
    Dim connStr = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\abcd.mdf;Integrated Security=True;User Instance=True"
    it throws the following error...

    "an attempt to attach an auto-named database for file...."

    I have a feeling that I need to check if the database abcd.mdf is already on the user's computer but it doesn't throw the error when debugging etc. I thought this connection line just connected to the db but it seems to suggest that it is attaching something each go.

    Bit confused as to how to solve this one.

    Thanks
Working...