Posts

Showing posts from August, 2013

ADF Dataset Validation Validation Issues select count(1) from TABLENAME sql query / that is a problem

hi adf v1 azure sql external dataset { "$schema": "http://datafactories.schema.management.azure.com/schemas/2015-09-01/microsoft.datafactory.table.json", "name": "somename", "properties": { "type": "azuresqltable", "linkedservicename": "azuresqldatabase", "structure": [], "typeproperties": { "tablename": "schema.table" }, "availability": { "frequency": "day", "interval": 1 }, "policy": { //"validation": { // "minimumrows": 100 //} }, "external": true } } i thought validating rows on external sql dataset. defined validation rule. rows. but instead of executing validation while copy (i use query source sqlreaderquery) seams "select count(1) schema.table"

MEF2 how to ExportMetaData

hi, i working @ project using mef1 works fine dynamically export metadata on different dlls. now moving forward mef2 in did not see documentation on how handle 'exportmetadata". do need create concrete class attributes metadata? still use attributes in targeted class ? are there samples? thanks maggie hi import dll partially in mef, please check following provide sample mef exports, this: conventions.fortype<mainwindow>() .export<iview>(x => x.addmetadata("name", "main")) https://blogs.msdn.microsoft.com/bclteam/2011/11/01/getting-started-with-convention-based-part-registration-in-mef-2-nick/ best regards, cole wu we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey.

adding a single variable to a dataset

Image
i'm trying write basic c# forms application reads xml config file, displays data in datagridview user edit, , saves changes xml config file. works fine except user wants add version number or datatimestamp file everytime it's written out. have is: xml file format <config_data> <version>1.1</version> <record> <name>jen</name> <num>5</num> </record> <record> <name>joe</name> <num>6</num> </record>...... read in xml file , set dataset: xmlreader xmlfile; //create xml reader , read in file avds=new dataset; avds.readxml(xmlfile); i set databinding bind datagridview dataset: datagridview.datasource=ds; datgridview.datamember="record"; and when user hits save write out: xmlwriter xmlfile; ds.writexml(xmlfile); but writes out data in <record> fields i've shown user editing. since i'm writing dataset directly xml file i'm not sure how can

"Smalltalk’s object-based hierarchy does not work so well".Also c#??

i read book , "thinking in c++".at pg:694( introduction templates) writes: "the smalltalk solution. smalltalk (and java, following its example) took simple , straightforward approach: want to reuse code, use inheritance. implement this, each container class holds items of generic base class object (similar the example @ end of chapter 15). because library in smalltalk of such fundamental importance, don’t ever create a class scratch. instead, must inherit an existing class. find class close possible 1 you want, inherit it, , make few changes. obviously, a benefit because minimizes effort (and explains why you spend lot of time learning class library before becoming an effective smalltalk programmer). but means classes in smalltalk end being part of a single inheritance tree. must inherit branch of tree when creating new class. of tree there (it’s the smalltalk class library), , @ root of tree class called object – same class each smalltalk container holds. this neat tric

SWIFT Accelerator : ParseError

Image
  hi all,   i use swift dissasembler in microsoft.solutions.financialservices.swift.pipelinecomponents.swiftdasm assembly of biztalk swift accelerator 3.0. i'm on bts2006 r2 ent. , install messagepack 2007. but tricky parse error on swift messages :   < swift_error messagetype =""> < parseerror exceptiontype ="" linenumber =" 1 " lineposition =" 0 " multipleemptylines =" false " schemaname =" http://schemas.microsoft.com/biztalk/solutions/financialservices/swift/swiftheader#swiftheader "> < message > unable decipher body schema name swift header data. </< font> message > </< font> parseerror > < parseerror exceptiontype ="" linenumber =" 0 " lineposition =" 0 " multipleemptylines =" false " schemaname =""> < message > stray data found @ end of message. </< font> message > &l

Issues when configuring the exception Web services component

i getting following error when trying configure exception webservice in esbconfiguration tool during esb toolkit installation. exception retrieving member "create": "the system cannot find path specified. i installed biztalk server 2009 on windows xp , installed msis of esb toolkit successfully. when trying configure biztalk esb toolkit core services , components i getting above error. using domain account user account.  vs 2008, sql server 2008 , biztalk 2009 running on same machine (windows xp). i spent 2 days on one. can 1 me out? -sanjay sd hi sanjay, when using esb configuration tool during initial installation, must apply configuration changes each section before can continue configure next section. process validates each configuration section before continue. configuration of these sections must completed consecutively. check whether user member of "iis_wpg" group

How to fully configure a receiver location with FILE transport type with powershell

hello trying configure receive location object keep getting next error: could not validate transporttypedata, address or public address properties receive location 'test.receiveloc.biztalktounix'. invalid value property "receivefolder". +     $biztalkom.savechanges() +     ~~~~~~~~~~~~~~~~~~~~~~~~     + categoryinfo          : notspecified: (:) [], btsexception     + fullyqualifiederrorid : btsexception i dont know object has "receivefolder property, can help?  code have: function createreceivelocation( $receiveport, [string]$receivelocname, $biztalkom, [string]$suffix) { #check receive location doesn't exist if ($receiveport.receivelocations["$receivelocname.receiveloc.$suffix"] -eq $null) { write-host "attempting create <$receivelocname.receiveloc.$suffix>" #create new receive location $myreceiveloc = $receiveport.addnewreceivelocation() #check type of protocol use if ($

ErrorGroup=RFC_ERROR_SYSTEM_FAILURE. SapErrorMessage=TYPE for destination 'XYZ' not valid. AdapterErrorMessage=Error accepting incoming connection.

log name:      application source:        biztalk server date:          10-11-2016 13:10:22 event id:      5644 task category: biztalk server level:         error keywords:      classic user:          n/a computer:      ---------------------------- description: messaging engine failed add receive location "wcfreceivelocation_sapbinding_xyz_custom" url "sap://client=<client>;lang=en;@a/<host>/<gateway service>?listenerdest=xyz&listenergwserv=xyz&listenergwhost=xyz&listenerprogramid=xyz&rfcsdktrace=false&abapdebug=false" adapter "wcf-custom". reason: "microsoft.adapters.sap.rfcexception: details: errorcode=rfc_ok. errorgroup=rfc_error_system_failure. saperrormessage=type destination 'xyz' not valid.  adaptererrormessage=error accepting incoming connection. rfcaccept returned rfc_handle_null..    at microsoft.adapters.sap.rfcexception.helperthrow(int32 retcode, string additionalerro

Including Excel drivers/coms/dll with C# service

hi all the break down have c# program extracts data excel file. excel file being generated website (can't change this) leading fact though extension .xls technically web page. :( created work around saves excel file again .xls , works great. in production environment not have microsoft excel installed (can't install it). part of saving file again fails. tried not treating file excel html in ole db connection string couldn't process work either. primary interop assemblies assumed install needed drivers won't install unless excel installed? @ least message keep getting. there way of including needed excel stuff in c# service? pérez there ace oledb provider can install microsoft allows connect excel file similar sqlconnection. http://www.microsoft.com/en-us/download/details.aspx?id=13255 the whole saving, , "its not excel file until save again" thing makes me wonder, getting csv output? html source of page like? parse through? sure need excel, , n

Enterprise Library Caching

hi,   i getting error "could not find file"  in th following line cachemanager cache = cachefactory .getcachemanager(); but same code working in other system. please me on this. please find following error message.   system.io.filenotfoundexception unhandled   message="could not find file 'inboundlogistics\\-1208129235\\scpr'."   source="mscorlib"   filename="inboundlogistics\\-1208129235\\scpr"   stacktrace:        @ system.io.__error.winioerror(int32 errorcode, string maybefullpath)        @ system.io.filestream.init(string path, filemode mode, fileaccess access, int32 rights, boolean userights, fileshare share, int32 buffersize, fileoptions options, security_attributes secattrs, string msgpath, boolean bfromproxy)        @ system.io.filestream..ctor(string path, filemode mode, fileaccess access, fileshare share, int32 buffersize, fileoptions options, string msgpath, boolean bfromproxy)        @ system.io.isolatedstorag

c# express gui using a webservice

what want do.  c# express gui access webservice send , retrieve tables of data. the problem.  have not found example works.  examples have seen webpage webpage in no way work when adapting them c# gui.  methods require "string" argument no show available method in c# express.  guesssing has done in soap?  maybe need write rest?   need tutorial beginner level going on this.  help? cs on 10/13/2011 4:00 pm, countrystyle wrote: > going through tutorial on wcf now......if thinks may not > way go save me time , speak please.....thanks.   yes, wcf web service way go. now, can use ado.net entity framework instead of using datasets , datatables , traditional ado.net if using sql server in application, because ef entity implicit serialized data contract wcf, , you can send is.   or can make custom objects marked seralizable() attribute with each primitive property type marked datamember() attribute. or can still use datasets. however, have nev

Mobile Service with .Net Backend - API issue

Image
hi, i have created mobile service .net backend sql azure database having table called customers. on have created api return list of customers json. for testing purpose have inserted customers info into the local mdf file get along with the service project. when publish service project locally api returning list of customers (from local database file) with out problems. so, published service project mobile service. after publishing, tried call api list of customers but i getting error below. the customer table(in azure) having 100 thousands of records. after research found issue number of records. when table having less records api working fine if table having thousands of records failing. my requirement want call api having business logic having multiple tables performing joins on tables , returning records application. note: each table having thousands of records. api logic using is: if use below query less number of records working: var result = databas

DB2 Adapter Batch Insert Updategram

does db2 adapter allow batch insert such follows? <request>      <synch>            <after>filename id = '1' parameter = 'abc'</after>            <after>filename id = '2' parameter = 'def'</after>            <after>filename id = '3' parameter = 'ghi'</after>      </synch> </request> hi, i spiked , managed batch insert. BizTalk Server  >  BizTalk Server Adapters and Adapter Pack

Size Required for BizTalk Backup Job ?

hi, i trying understand , use biztalk backup job 2009 version.  note, storage costs expensive, don't have storage.  in current environment can see msgbox logfile hovering around 5gb , data file around 280mb. i configured backup job , created new sp ( http://support.microsoft.com/kb/982546 ) to remove backups, isn't critical system.  reading comment in sp appears need minimum of 2 times storage backups actualy data files, 15gb.  typical of other biztalk 2009 environments ? i don't want backup or archive data biztalk, since transactional , if fails re-run process.  i'm after method keep databases growing large.   thanks, ben comment sp here if @daystokeep null or @daystokeep <= 0   return /*   delete full sets   if set spans day such items fall deleted group , other doesn't, not delete set */ hi, if have high throughput, size of transaction logs biztalkmsgboxdb high, , biztalkdtadb high. others small, not changes (unles using b

Releation between parameter and result note proveable by static checker

hi, following code: imports system.diagnostics.contracts public class class1 public shared function removeempty(byval comp string()) string() contract.requires(comp isnot nothing) contract.ensures(contract.result(of string())() isnot nothing) contract.ensures(contract.result(of string()).length <= comp.length) dim ret string() dim max integer max = 0 redim ret(comp.length - 1) each str string in comp contract.assert(ret.length > max) ret(max) = str if not string.isnullorempty(str) then max += 1 end if next contract.assert(max <= comp.length) redim preserve ret(max - 1) contract.assert(ret.length <= comp.length) contract.assert(ret isnot nothing) contract.assert(ret.length <= comp.length) return ret end function end class gener

draw string in user control

hi dears . make user control code . button want draw string on under text of button . don't know how implement . please me . public partial class pbutton : system.windows.forms.button { /// <summary> /// summary description cutebutton. /// </summary> private string m_text = ""; private color m_color1 = color.lightgreen; // first color private color m_color2 = color.darkblue; // second color private int m_color1transparent = 64; // transparency degree // (applies 1st color) private int m_color2transparent = 64; // transparency degree // (applies 2nd color) public color cutecolor1 { { return m_color1; } set { m_color1 = value; invalidate(); } } public colo

Credit Card Pipeline not executing

orders , customer manager shows visa payment method pipeline componant name of creditcardprocessor.  web.config has creditcardprocessor set pipelines\creditcard.pcf.  creditcard.pcf has 1 step, processor.  rename file, error expected.  restarted iis.  breakpoints not firing in processor, , aithcode not being populated.  logging turned on pipelines, 0kb creditcard.pcf log file.  ideas happening? oh , orders going through..  seems skipping credit card processor stupid error on part.  missing paymentmethodrouter in checkout pipeline... Commerce Server  >  Commerce Server 2009

Initializing Arrays

if create string array should initialize whit string.empty or there not performance , memory issues if dont initialize it?   kenny   kymaita wrote: if create string array should initialize whit string.empty  only if  that's waht want values be, , you're not happy default value (null).   kymaita wrote: or there not performance , memory issues if dont initialize it? explicitly initializing elements slower not doing so.   .NET Framework  >  Common Language Runtime Internals and Architecture

CreativeError Universal Windows Platform Ads Issue

Image
hi ! few days i'm stuck on problem... when ad loaded, i've got message : script1015: unterminated string constant. "ok" - said myself , @ code dynamically produced... , find oddity : need help, tried , nothing... don't know why "<body>" , "<html>" inserted here. in advance ^^" ps : use "microsoft advertising sdk javascript" ok ! thing quite scary... work... don't know why... think it's because app wasn't registered on windows store but... issue appeared test ids... why test ids didn't worked ? , why work ? of mistery ^^" Windows and Windows phone apps  >  AdSDK Integration & Ad Mediation

An issue with a runbook output in Preview Portal

Image
when output string, or type can converted string (e.g. integer or date), works fine. however, when output complex object, details column empty , there no visual clues need click on open stream blade specific output stream. aleksandar nikolić http://powershellers.blogspot.com http://twitter.com/alexandair this design since there not enough space display complete text of object in grid view.  what expecting displayed there?  would having visual indicator there more output must click view help?  beth cooper Microsoft Azure  >  Azure Automation

get data from Keyboard

hi! i want data keyboard in c# when app minimum in taskbar or notification??? please me!!! read this: http://social.msdn.microsoft.com/forums/en-us/c1655c13-81ec-4200-8b2d-a0b41d703e54/please-read-before-posting?forum=smallbasic it written: "'as surely live,' says lord, 'every knee bow before me; every tongue acknowledge god.'" romans 14:11 Visual Studio Languages  ,  .NET Framework  >  Visual C#

Force Types to Be the Same

hello, i have following class: public treply send<treply>(query query) treply : reply, new() { type type = typeof(iqueryhandler<,>).makegenerictype(query.gettype(), typeof(treply)); iqueryhandler handler = (iqueryhandler)objectfactory.getinstance(type); try { return (treply)handler.handle(query); } catch (exception exception) { ilogger logger = objectfactory.getinstance<ilogger>(); logger.error(loggername.plug, exception); return new treply { exception = exception }; } } // send is possible throw exception if treply in send<treply> , (treply) in (treply)handler.handler(query) not of same type? i know both implement reply ... mistake can this: senduserverifysealreply reply = _dispatcher.send<senduserverifysealreply>(query); but in handler return like: return new senduserunlocksealreply(); both senduserverifysealreply , senduserunlocksealreply based on reply

Mshtml filling form and posting a message

Image
i have succed in making auto login twitter.com trying post tweet has pop window. here code please guide me how that?             htmlelementcollection statuscollection = webbrowser1.document.getelementsbytagname("textarea");             htmldocument htmldocumentobj;             htmldocumentobj = (htmldocument)webbrowser1.document;             foreach (htmlelement txtarea in statuscollection)             {                 htmlelement txt;                 if (txtarea.getattribute("type").equals("textarea"))                 {                     txt = txtarea;                 }                 htmlanchorelement s = null;                 if (txtarea.getattribute("type").equals("textarea"))                 {                     txtarea.invokemember("click");                     txtarea.setattribute("value", "new tweet");                 }             } asia

Maximum Primary Display Resolution

hello, some background information: i have mosaic display consisting of 3x5 1080p (9640x3260) monitors total of 31.7264 million pixels.  as mosaic, cumulative displays viewed single, primary display.  on display, unable initiate other chat session.  trying initiate voice call, video call, or content sharing result in users waiting request join, never receive request.  behavior reproducible on displays large using skype business 2015 or 2016. have tested on display total of 24.576m pixels while keeping same aspect ratio , unable reproduce error state.  i tried testing on display 29.4912m pixels, again same aspect ratio, , in instance able reproduce error.  this leading me believe there may max window or buffer size hitting. the questions looking answer are: correlation between primary display resolution/configuration , skype business content sharing/calling functionality? maximum supported resolution of primary display , there way of increasing maximum

Newbie question - why AS2 and what are the alternatives?

there example dealing , using as2.  why use as2 vs edi? as2 , edi different technologies.  edi is message standard while as2 transport standard. what find edi over as2.  as2 not limited sending , receiving edi. message, including xml based standards, can exchanged on as2. in practical terms, as2 simple combination of http(s) , (s)mime standardized way of acknowledging transmission. you can use biztalk tutorials learn features of as2: http://msdn.microsoft.com/en-us/library/bb226317.aspx common alternatives (i've encountered) https , sftp/ftps. BizTalk Server  >  BizTalk Server EDI and AS2

Let one assembly implement an internal interface of the caller

i've created 1 of these nifty proxy creators implments interface you. works fine on public interfaces, internal interfaces run trouble. proxy class resides in own assembly, , has following simple usage: type impl = proxy.create(type interfacetype); above method create it's own dynamic assembly , if caller supplies internal interface type, typebuilder.createtype throw exception. thought somehow remidy letting caller supply modulebuilder used host type: type impl = proxy.create(type interfacetype, modulebuilder mb); however havn't got work. idéas? how let 1 assembly implement internal interface of caller? document problem.  paste exception message, stack trace , snippet of code causes it. hans passant. .NET Framework  >  Common Language Runtime Internals and Architecture

Register SQL Compact V 4.0 to SQL Management Studio 2012

Image
i have installed sql management studio 2012 , want connect sql compact 4.0 server. it not shown in local server groups or central management servers. i have created database in sql c 4.0 can't use sql server 2008 not recoginise 4.0 databases, 3.5 databases. is there way connect database? related question have sql server management studio 2008 installed can see sql compact server, file have setup using compact 4.0 toolbox v 4.0, sql mangement studio 2008 requires v 3.5 version. is there way can 2008 read file? hi rocky48, sql ce not require run setup or install database server in order use it. can copy sql ce binaries \bin directory of asp.net application, , web application can use database engine. can use visual studio connect work sql ce database. more detail information, please refer following link: vs 2010 sp1 , sql ce http://weblogs.asp.net/scottgu/archive/2011/01/11/vs-2010-sp1-and-sql-ce.aspx allen li technet community support

Get latest from TFS - Need add in

hi   i working tfs scc , vs2003.  know when checkout in vs file, opens edit not doing getlatest did in sourcesafe. my question devided 2. is there way getlatest file vs2003 ? is there way add menu item rightclick menu in solution explorer of vs2003 ?   thanks avi for example started version control client api, see following blog post. http://blogs.msdn.com/buckh/archive/2006/03/15/552288.aspx buck Archived Forums V  >  Team Foundation Server - Source and Version Control

Is DBCC PAGE and DBCC IND commands deprecated in SQL 2014?

hi, is dbcc page , dbcc ind commands deprecated in sql 2014? not able view after running trace flag 3604 aa they should work, i f execute above dbcc command in-memory optimized table in sql server 2014 database, output return nothing. expected in-memory optimized tables. since data stored in memory , not in physical disk disk optimized tables, don't have data page structures such in-memory optimized tables. http://www.kodyaz.com/sql-server-tools/execute-dbcc-page-to-display-data-page-contents.aspx SQL Server  >  SQL Server Documentation

Cannot connect to Application Insights with your Visual Studio Team Services account.

i'm using load testing project vso account load test application in cloud.  everything works fine - reports great.  i installed application insights status monitor on vms running on azure , performance metrics being reported in application insights within azure portal - works great too.  however, when go "get performance data application insights" under run settings -> applications of load test project following in error message box. cannot connect application insights visual studio team services account. ... check if application insights service available. ... contact visual studio team services support if continue error. this got support: app insights integration broken. please see blog post. blogs.msdn.microsoft.com/visualstudioalm/2016/11/07/issue-with-using-application-insights-with-load-tests/ Visual Studio Development

Managing User Secrets while developing a .Net Core application

hi, i migrating .net core application service fabric , within initialization sequence have following code:         if (env.isdevelopment())             {                 this.configurationbuilder.addusersecrets();             } right now, code failing following: additional information: unable locate project.json @ 'c:\sfdevcluster\data\_app\_node_4\deploymenttype_app9\managementpkg.code.1.0.0\'. i did set secret locally on app , if run app in standalone mode, code fetch secrets. in sf, seems looking file in sfdevcluster folder. what need set secrets locally? there couple of answer this first service fabric provides mechanism securing secrets in application can used both development environment , in production described here https://azure.microsoft.com/en-us/documentation/articles/service-fabric-application-secret-management/. similar way asp.net v5 enables embedded secrets in configure. preferred way the .net core secrets tool using seems specific

How to capture error/warning/success from powershell in c#?

hi, i'm writing small tool collect detail office 365 using powershell in c#. challenge i'm facing is, after powershell command run, want know whether successful or not. if not , warning or error. "if  errors.count > 0" me understand failed , "if  errors.count == 0" tell me there issue. the concern is, need clear error, before running every command to use above logic find success or failure of recent command, there other better method do have? if , can please share it. secondly how find/capture warning? thank in advance. hi, how running these powershell commands c# code? can post example? marcus björklund in order others find relevant information, please mark/propose answers and/or vote posts helpful, appropriate. Visual Studio Languages  , 

Any one liner code ?

   public static void main()         {             //looking better code below problem             //the house numbers along jefferson street 1 through 120.             //how many digits there house numbers..             int digitcount = 0;             (int = 1; <= 120; i++) digitcount += i.tostring().length;             console.writeline(digitcount);         } you use: int digitcount = enumerable.range(1, 120).sum(i => i.tostring().length); reed copsey, jr. - http://reedcopsey.com if post answers question, please click " mark answer " on post , " mark helpful ". Visual Studio Languages  ,  .NET Framework  >  Visual

Can we subscribe biztalk database with same message type but different public key token which it expected

here explaing project scenario 2 projects 2 different strong name (snk) files i have 2 seperate applications in first application have 1 receive pipeline pick messaeges 1 queue , putting mesages biztalk database.it have 1 seperate snk file. in second application subscribing messages throuhg direct binding form biztalk database same message type required.and have different snk file.   so getting below mentioned error.   exception thrown from: segment 1, progress 3 inner exception: received unexpected message type 'mool.portin_rsp, stel_schema, version=1.0.0.0, culture=neutral, publickeytoken=e1a7e3de4e628631' not match expected type 'mool.portin_rsp, stel_schema, version=1.0.0.0, culture=neutral, publickeytoken=06d085236ce995d5'.          exception type: unexpectedmessagetypeexception source: microsoft.xlangs.engine target site: void _verifypublisherschema() following stack trace identifies location exception occured at microsoft.xlangs.core.xmessag

The type initializer for 'System.Windows.Application' threw an exception.

i have develop application .net framework in fourth version (4.0). empty base application created visual studio, error message written in caption when start debugging. did not change apart "target framework" property changed 4.5 4 (no client profile). application wpf project written in c#. this error quite annoying, more usual errors: absolutely can't figure out causes problem. glad if me. this issue better placed in wpf forums: http://social.msdn.microsoft.com/forums/en-us/home?forum=wpf exceptions carry lot more information, thier type, message, innerexception , stacktrace. need if give usefull sugestions. ideally give result exception.tostring() wich should contain of above. lowering framework version dozen times more give compiler error, rather runtime errors curious thing. have tried going 4.5 again? let's talk mvvm: http://social.msdn.microsoft.com/forums/en-us/wpf/thread/b1a8bf14-4acd-4d77-9df8-bdb95b02dbe2 please mark post helpfull , answers

GroupBy a combination of columns - changes .Select

Image
hi,  having bit of trouble lamda expression.  i wish groupby combination of couple of columns , select single column.  however whatever group seems going 'key'.   e.g. need group hour+timetype select hour   void main() { list<hours> hrs = gettimes(); hrs.dump(); list<string> hrlist = hrs .groupby (grp1 => string.format("{0}{1}" , grp1.timetype, grp1.hour)) .select (grp => grp.key.tostring()).tolist(); hrlist.dump(); } public class hours { public string hour { get; set; } public string timetype { get; set; } } public list<hours> gettimes() { list<hours> hrs = new list<hours>(); hrs.add(new hours() { timetype="am", hour="01"}); hrs.add(new hours() { timetype="am", hour="02"}); hrs.add(new hours() { timetype="am", hour="03"}); hrs.add(new hours() { timetype="am", hour="04"}); hrs.add(new hours() { timetype="am&qu

Connecting to database

Image
{"login failed user 'domainname\\mycomputername$'."}    system.data.common.dbexception {system.data.sqlclient.sqlexception} have modified connection properties use sql user name , password. recompiled 1000 times. why hell still uses computer name there when using integrated security? hi when create connection string application, not include user name , password. instead, set connection string's integrated security attribute sspi. the following example shows connection string includes appropriate attributes: data source=myserver;initial catalog=northwind;integrated security=sspi to configure sql server integrated security from windows start menu, choose microsoft sql server , , choose enterprise manager . open node server , expand node database want give users permissions for. right-click users node , choose new database user . in database user properties dialog box, enter domain \ username in login name box, , click ok .

how to utilize SQL adapter response from a multipart message?

hello everyone, i'd utilize response sql adapter two-way-port calling stored procedure parameters. depending on results of stored procedure contemplated select statement @ end of stored procedure commits 'success' or 'error' orchestration. unfortunately i'm missing basics behind... response message provides 1 result - suppose first messagebody part has been processed 'success'. whats other bodyparts, indeed return 'error' messagebody parts? please point me on right track, thanks! best regards mathias BizTalk Server  >  BizTalk Server General