ASPNETDB.MDF

Abdulhafeezo

I uploaded the default aspnetdb.mdf database an my web server but i still cannot figure out a way to make my web application interface with de data base. the connection string on my localhost is: Data Source=.\SQLEXPRESS;AttachDbFilename="D:\Documents and Settings\Abdulhafeez\Desktop\Runningcodes\App_Data\ASPNETDB.MDF";Integrated Security=True;User Instance=True could any1 pls help me modify it to a working connection with a web server?

Vimalsoft Pty Ltd

Do you get any Errors ? and what are the Erros ?

Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

Abhishek Sur

Do not attach file when you are in the production server, rather do like this : 1. Create a Login for ASPNET Account to the SQL Server instance 2. Attach the ASPNET.MDF file to the SQL Server itself using CREATE DATABASE [ASPNET] ON ( FILENAME = N'D:\Documents and Settings\Abdulhafeez\Desktop\Runningcodes\App_Data\ASPNETDB.MDF' ), ( FILENAME = N'D:\Documents and Settings\Abdulhafeez\Desktop\Runningcodes\App_Data\ASPNETDB_log.LDF' ) FOR ATTACH Run it in Master Database. :)

Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.

My Latest Articles-->** Windows7 API Code Pack
Simplify Code Using NDepend
Basics of Bing Search API using .NET

Abdulhafeezo

I still did not get the explaination you did. pls explain it to me cos am a bit too dol.

Abhishek Sur

I meant you need to attach the database to a database instance installed in your operating system. :)

Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution.

My Latest Articles-->** Windows7 API Code Pack
Simplify Code Using NDepend
Basics of Bing Search API using .NET

suyogm

try changing the AttachDbFilename attribute in Connection string. It might help you. Data Source=.\SQLEXPRESS;AttachDbFilename="|DataDirectory|ASPNETDB.MDF";Integrated Security=True;User Instance=True