f# - SqlDataProvider connection string in Suave on Azure -


i can't sqldataprovider work when executed in fsx script running in azure web site.

i have started samples tomas petrecek has here: https://github.com/tpetricek/dojo-suave-fshome.

in short fsx script executed using iis httpplatformhandler http requests azure web site forwarded f# script.

the f# script use suave handle requests.

when tried adding database access http handlers got problems.

the problematic code looks this:

[<literal>] let connstr = "server=(localdb)\\v11.0;initial catalog=my_database;integrated security=true;"  [<literal>] let resolutionfolder = __source_directory__ fsharp.data.sql.common.queryevents.sqlqueryevent |> event.add (printfn "executing sql: %s")  // following line fails when executing in azure type db = sqldataprovider<connstr, common.databaseprovidertypes.mssqlserver, resolutionpath = resolutionfolder>  let savedata somedatatosave =   let ctx = db.getdatacontext(environment.getenvironmentvariable("sqlazureconnstr_queries"))   .....   /// code using context here

this works fine when run locally, when deploy azure site fail @ line type dbis created.

the error message (line 70 line has type db = ...:

d:\home\site\wwwroot\app.fsx(70,11): error fs3033: type provider 'fsharp.data.sql.sqltypeprovider' reported error: network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: sql network interfaces, error: 52 - unable locate local database runtime installation. verify sql server express installed , local database runtime feature enabled.)

the design-time database in connstr not available in azure site, thought why have getdatacontext overload takes connection string used @ run-time?

is because running script , not compiled code trying access database when creating typeprovider? if yes, mean option compile , provide database code compiled assembly load , use in suave fsx script?

reading connection string config file not work in azure site. need connection string environment variable (which set in azure management interface).

hmm, bit unfortunate - @fyodor mentioned in comments, problem script-based deployment azure compiles script on azure machine - , need have statically-resolved connection string works on azure.

there 2 options:

  1. use compiled project instead. if compile f# code locally , deploy compiled code azure work. sadly, there no samples that.

  2. do clever trick make connection string accessible script @ compile time.

  3. send pr sql provider can give name of environment variable , reads connection string there.

i think (3) quite nice , useful feature.

i'm not sure best way (2) be. think might able modify app.azure.fsx creates file (say connection.fsx) contains like:

module connection let [<literal>] connstring = "<contents of sqlazureconnstr_queries>"

then app.fsx load script , use connection.connstring in argument of sql type provider.


Comments

Post a Comment

Popular posts from this blog

angularjs - ADAL JS Angular- WebAPI add a new role claim to the token -

i have created angular spa webapi backend using adal js authentication.as there no roles in ad, need manually add role claims in order give users access different api controllers. the roles stored in database. expecting inject claim through call webapi after authentication ad. webapi code might this. identity.addclaim(new claim("role", "user")); var ticket = new authenticationticket(identity, props); var accesstoken = startup.oauthbeareroptions.accesstokenformat.protect(ticket); is possible replace adal idtoken new token? is viable solution or there other better way handle this? as initial token generated azuread, possible edit token add new claim? appreciated. graph api supporting group claims. see here: http://justazure.com/azure-active-directory-part-4-group-claims/ if @ examples on page, users assigned groups , app can check group in claims. in current version of portal, need app manifest , modify it.
Read more

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

php - CakePHP HttpSockets send array of paramms -

i problem when make request (i can request). $link = 'http://uri/path/?param1=1&sid=2&sid=3&sid=4' $http = $httpsocket = new httpsocket(); $res = $httpsocket->get($link); if check request pr($http); i see : [line] => /url/path/?param1=1&sid%5b0%5d=2&sid%5b1%5d=3&sid%5b2%5d=4 http/1.1 and i'm getting empty response because server doesn't know parameters sid%5b0%5d=2 when try send parameters array : $data = array('param1' => '1', 'sid' => array('2','3', '4')); i see same changes %5b0%5d - additional indexes. how fix it? unfortunately , can not change server side, if send request in browser, i'll normal response in json format. when make request, can parameters this: $param1 = $_get['param1']; $sid= $_get['sid']; tip: use diferente names parameters. have multiples sid. use sid1, sid2, sid3... update: can parameters this:...
Read more