Quantasoft

Hi

I am trying to set up an sql express (2005) database on quantasoft (qsh.eu). They assure me that they support this type of database and say to use user instances. There is also a connection string generator on their website. I have tried numerous times to get the connection to work, but every time it produces a runtime error with no details about the actual problem. Does anyone know how i can make this connection work?

connection string (database is in App_Data folder)

<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;Database=transmission.qsh.eu_ce00d421-bc1c-4564-a6e3-755632a0d652;AttachDBFilename=|DataDirectory|Database.mdf" />

Hi,

As your hoster provide SQLExpress edition, you can upload your aspnetdb database onto the App_Data folder and make the connection string look like:

<add name="LocalSqlServer" connectionString="data source=ServerName\InstanceName;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />

In the string above, the servername and instancename can be got from your host and the AttachDBFilename is based on the .mdf filename you upload to your server.

Hope that helps. Thanks.

|||

Hi,

I am also using quantasoft and facing the same problem !. i am very new to asp.net and sql . i donot have any roles or membership on my webpage (but i would shurly like to have it someday!). ..i mean it is a simple webpage with 1 database(test.mdf) and 1 gridview which shows the database contents!.

Question:- WHAT IS ASPNETDB.mdf ??- I d'not know about it ,what this file is ? and what it is used for ? or where can i get this file ? or how can i make this file ? - Please tell me all about this file !

Thanks ! in advance. :)

|||

I hate to 'bump' this post but i still have not resolved this problem. I would be grateful if anyone could help me with this. I am now receiving this error:

An attempt to attach an auto-named database for file H:\Home\Webs\qsh.eu\transmission_24be67cf-3e4c-4852-b3ec-fc849ce5b009\www\App_Data\Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.