c# - Using existing Database File but using SQL Server Express -


i have existing database named financialhub.mdf in app_data folder. using (localdb)\mssqllocaldb if i'm not wrong. want change sql server express because i'm encountering major errors when publishing website onto iis when wanting access database.

i'm using visual studio 2015 , think saw control panel i'm using microsoft sql server 2012 can't seem find sql tools. how check if have tools?

may ask how connect sql server express? tried find sql server configuration management or in computer can't seem find anything..

could please provide step-by-step guide on how use existing .mdf database file , getting connection work database sql server express?

i tried using web.config

<connectionstrings>     <!--<add name="connstr" connectionstring="data source=(localdb)\mssqllocaldb;attachdbfilename=|datadirectory|\financialhub.mdf;integrated security=true" />-->     <add name="connstr"           connectionstring="data source=\\.\pipe\localdb#faa25ac9\tsql\query\sqlexpress;initial catalog=c:\users\dom\documents\visual studio 2015\websites\financialhub\app_data\financialhub.mdf;integrated security=true;user instance=true"           providername="system.data.sqlclient" /> </connectionstrings>

but doesn't work @ all.....

first link previous questions

second link previous questions

currently programs have microsoft sql server control panel:

picture

connectionstring sqlexpress editing marc_s connectionstring:

<add name="connstr" connectionstring="data source=dominic-lim\sqlexpress;initial catalog=c:\users\dom\documents\visual studio 2015\websites\financialhub\app_data\financialhub.mdf;integrated security=true;" providername="system.data.sqlclient"/>

if can't find in sql server configuration manager - don't have installed - plain , simple. first step: sql server 2012 express (or newer version), install it, , check again if see in configuration manager.

then, once you've installed sql server express, find in configuration manager , see instance name - default installs .\sqlexpress (but can change @ installation time).

then, using management studio, connect instance (specify .\sqlexpress server/instance name), , attach existing .mdf file database in sql server express.

once that's done, can access database in sql server express using connection string this:

<connectionstrings>     <add name="connstr"           connectionstring="data source=.\sqlexpress;initial catalog=financialhub;integrated security=true;          providername="system.data.sqlclient" /> </connectionstrings>

Comments

Post a Comment

Popular posts from this blog

javascript - Create a stacked percentage column -

i have collection of data : var data = [ {"p301a":"10","p301b":"7","p301c":"7","p301d":"3","p301e":"8","p301f":"8","p301g":"8","p301h":"8","p301i":"8","p301j":"8","p301k":"8","p301l":"8","p301m":"8","p301n":"8","p301o":"8","age":"31-40 years","profesion":"2","position":"2"}, {"p301a":"5","p301b":"4","p301c":"4","p301d":"4","p301e":"4","p301f":"4","p301g":"4","p301h":"4","p301i":"4","p301j":"4","p301k":"4...
Read more

Optimising Firebase database by automatically overwriting data -

in firebase app have following structure: posts latest all users can write posts > latest . want limit entries 20 posts save space in database. , posts beyond 20 unnecessary never shown on homepage. how can limit posts 20, when user writes posts > latest posts @ end drop off (be deleted) automatically? this sample should you. you need : const max_log_count = 20; exports.removeold = functions.database.ref('/posts/latest/{postid}').oncreate(event => { const parentref = event.data.ref.parent; return parentref.once('value').then(snapshot => { if (snapshot.numchildren() >= max_log_count) { let childcount = 0; const updates = {}; snapshot.foreach(function(child) { if (++childcount <= snapshot.numchildren() - max_log_count) { updates[child.key] = null; } }); // update parent. removes children. ...
Read more

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -

Image
each grid cell can have more 1 customtemplate loaded. have directive holds watcher on model_col_field listen cell updates on scroll when dom rows updated , recompile celltemplate . without watcher , $compile rows repeat on scroll, showing same set of rows. is there more angular way of approaching or way improve performance? relevant controller code: create gridoptions.data & gridoptions.columndefs : var customtemp = '<div ng-repeat="opt in grid.appscope.colvalueoptionsmodel" ng-init="tempstring=model_col_field.clazz+opt.key;"><comparison-directive dbo="model_col_field" attobj="opt" fff="grid.appscope.getattributetemplate(tempstring)" /></div>'; $scope.gridoptions.columndefs = [ { name:'yindex',pinnedleft:true,celltemplate: customtemp, displayname:'index'}, { name:'col1',celltemplate: customtemp}, { name:'col2',celltemplate: c...
Read more