asp.net - Azure site only works when running locally with remote database -


i have site that's running off windows azure , have hooked database via linked resource , looks site should using database. i've included proper connection string in web.config file.

when run website locally , use azure database's connection string default connection, works , i've seen updating data local machine reflected in remote database.

whenever try access page makes database hits (ie, logging in or looking @ basic index (from scaffolded out views)), 500 error. tried turning on custom errors 500 error get. tried debug local machine didn't @ since worked when running site locally , connecting azure database.

i have pulled down web.config files , web.configs on both sides identical.

i figure has configuration issue, i'm not sure what.

is there maybe i'd have asp.net mvc 5 make work windows azure? looks .net framework set on azure .net 4.5. i'm guessing has fact azure doesn't know should using database supplied in web.config.

here web.config connection strings:

<add name="defaultconnection" connectionstring="data source=####.database.windows.net,1433;initial catalog=####_db;persist security info=true;user id=####;password=####" providername="system.data.sqlclient" /> <add name="defaultconnectiondeploy" connectionstring="data source=####.database.windows.net;initial catalog=####_db;persist security info=true;user id=####;password=####" providername="system.data.sqlclient" /> <add name="defaultconnection_databasepublish" connectionstring="data source=####.database.windows.net,1433;initial catalog=####_db;persist security info=true;user id=####;password=####" providername="system.data.sqlclient" />

windows azure makes use of transforms manage connection strings. connection strings merged in @ runtime, , can controlled configure tab on web site management page. whenever set azure database linked resource, automatically configures azure database server firewall rules allow connection web server, , adds connection string. using connection string, naming same string used in development, not necessary modify code prior deployment. if don't set azure database linked resource, necessary modify firewall rules hand, doesn't play nicely scalability of azure websites, it's not recommended.


Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more