Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bindra.mohit88
Starting Member
4 Posts |
 Posted - 2009-04-21 : 07:24:50
|
| Hello all, I am new to SQL Server 2005, so I have little knowledge to work with it. I am working on a project where I need to host my web application on FTP server, the database resides in App_Data folder and i have to establish a dynamic connection to it, so that it can be easily uploaded with no more technical issues to be resolved.I hope m clear to all.Need a solid answer asap. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-21 : 09:22:50
|
| What type of database - doesn't sound like sql server.What is the application written in? If .net then the connection details should be held in the web.config file.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
bindra.mohit88
Starting Member
4 Posts |
Posted - 2009-04-21 : 12:35:28
|
| Its .mdf file build using SQL Server Management Tool.I want to put it in App_Data folder, the connection works gud for the (local) server but i need to deploy it on web, where i have to upload the database files and set the permissions for that database folder accordingly.This is my problem, what else you need to understand ma problem completely, tell me, i'll post it soon.By the way, thanks for showing your concern to the problem. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-21 : 12:53:06
|
| Nope - you need to attach the database to the sql server - doesn't matter where the .mdf (and ldf) files are as long as the sql server can attach them.Your application will need to be able to connect to the sql server (have a login) and that login needs to be mapped to a user in the database.The sql server service account will need permissions on the App_Data folder but that's all.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
bindra.mohit88
Starting Member
4 Posts |
Posted - 2009-04-23 : 13:33:47
|
| Thank you sir for your worth suggestion.I will try this out, this means i just need to detach the database and attach it keeping my connection string untouched, no matter where my database files are?M i getting it right?Sir, I am new to it so I hope, m not irritating you by asking stupid question always.........Thanx for your concern. |
|
|
|
|
|
|
|
|
Need to establish a dynamic connection to database