Deployment of a .NET application making use of SQL Server 2008 -


i have searched internet thoroughly type of issue, there responses hasn't found concrete solution yet.

i have application makes use of sql server 2008 r2 , makes connections database file have set up. application executes successfully, makes connections database , retrieves/inserts/updates data , fro database.

however when come create deployment project i.e. setup project, fail transfer database files other computers , make database connections. have checked sql server 2008 prerequisite in publish settings of application , has included database files.

can suggest best way type of setup?

thanks

if using built in visual studio stuff, generates default connectionstring:

data source=|datadirectory|\database.sdf 

i possibly try change connectionstring absolute file path make sure able find database, possible |datadirectory| not being translated findable path.

you stated fails transfer database files other computers , make connections.. i'm not sure if mean files not existant, if aren't need make sure included them in file system portion of setup project view, , placed in proper location (again, |datadirectory| translates , finds db, or must provide absolute data source path)

it more helpful in future if provided maybe stack trace, exception details, or sort of error message, bit more specific go off of.


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -