Posts

Showing posts from March, 2013

Open RTF file in TextBox

i creating silverlight 3 application . want load data in textbox  from rtf file.can please tell me how load rtf text in textbox. thanks in advance. ashish sharma you can try dxrichedit devexpress, supports load , save rtf http://www.dotnetspider.com/resources/25112-silverlight-rich-text-edit-rtf-control-by.aspx http://demos.devexpress.com/dxricheditsilverlightdemos/   this response contains reference third party world wide web site. microsoft providing information convenience you. microsoft not control these sites , has not tested software or information found on these sites; therefore, microsoft cannot make representations regarding quality, safety, or suitability of software or information found there. there inherent dangers in use of software found on internet, , microsoft cautions make sure understand risk before retrieving software internet. Silverlight

Style generalization

hi all, this style datagrid. there way make work types of controls have these properties? <style x:key="stretchgridstyle" targettype=" sdk:datagrid " > <setter property="width" value="auto" /> <setter property="height" value="auto" /> <setter property="horizontalalignment" value="stretch" /> <setter property="verticalalignment" value="stretch" /> <setter property="margin" value="0" /> <setter property="padding" value="0" /> </style> hi, like know, there no way achieve that, because have set 'targettype' on 'style' tag minimum (known implicit styles). Silverlight  > 

SSIS Connection Issue

Image
hello: i have sql server instance name & host name same. host name xyz & sql server name xyz. we have network alias name "pqr", not sql server alias name. when try connect ssis using alias "" getting error attached question. any appreciated, thanking in advance. thanks do have access server try connect. while connection integration services donot give instance name. my blog     |      ask me      SQL Server  >  SQL Server Integration Services

Two-way sync between TFS Servers

hi, lets assume have setup 2 tfs servers respective sql servers, 1 in india , other in us. server exact replica of indian server. initially, have same data of indian server.  now if server goes offline, developers connect indian server, latest code , continue development. once server online, how can ensure gets synchronized indian server , gets latest check-ins/any data , remains synced until either 1 of them again goes offline (probably due isp issues). i dont wish use tfs proxy because if main tfs server goes offline, there no point in using tfs proxy since loses authentication tfs server. thanks in advance! hoysala hi hoysala,        thanks post. currently, there’s no default feature support automatically synchronization between 2 tfs servers. integration platform solution sync between 2 tfs servers, please refer user voice: https://visualstudio.uservoice.com/forums/121579-visual-studio/suggestions/2068973-automatic-synchronization-of-tfs-servers . we trying bet

Rollback SP4 or uninstall SQL server 2005 SP4

i installed sp4 , after found 1 of applications not work, because connections db fail app (after upgrade) either with sa auth or windows auth. so need revert or rollback sp3. is there can me step step reinstall sql server 2005 sp3 without losing of existent dbs? not have pre-sp4 backup! hello, there no way uninstall sp4. have reinstall sql server scratch, apply sp3, , re-attach user databases. maybe not upgraded: setup did not reach step. hope helps. regards, alberto morillo sqlcoffee.com   SQL Server  >  SQL Server Setup & Upgrade

TFS server access remotly with out VPN

hi , we have setup tpf server 2008 at our organization here in india , exposed tfs server on public ip. when our client tries access server below error. "tf31004:team foundation encountered unexpected error while connecting team foundaton server<server name>.wait few minutes , try again. if problem persists, contact team foundation server administrator" client accessing server using public ip , using vs 2008 team explorer. have created domain user (windows) client given access them. client not using vpn connection access tfs. is neccesary connect our domain through vpn access tfs server 2008 remotly? -deepak no don't need vpn. via public ip possible. i have installed myself. is a smal company: in nat of router of company, reroute port 8080 correct internal ip adres (open firewall ports when applicable) , ready run. it possible install ssl, there articles how achieven on net. never done myself though. ewald - please remember mark replies answers if help.

Association Properties Not Populated before 'OnLoaded' called

i have entity association property. i'm trying hook 'loaded' or 'created' moment in lifecycle attach event handlers associated property. i've been trying: onloaded oncreated (partial method)  the problem association property not populated.  corresponding fk property value set, can't seem @ actual associated object during creation. how can this?  missing something.  have thought 'onloaded' meant complete load of entity.  not so? thanks! entity.onloaded called after entity loaded entityset. however, might case related entities (the target of association) haven't been loaded entitysets yet, why you're getting null association. you'll have wait until entire load operation complete before associations can satisfied. Silverlight  > 

How to connect to DB2 data source from BIDS to make Cubes?

hi i trying make cubes on db2 database.   i have been used 2 different providers so: 1-       microsoft ole db provider db2 2-       imb ole db provider db2 with both providers made data source. creating data source view based on microsoft ole db provider db2 faced error “catastrophic failure”. data source based on ibm ole db provider db2 created data source view.   but there still problem db2 when tried make cubes , faced following error after pressing run button: errors in back-end database access module. provider 'ibmdadb2.db2copy1' not registered.   the following system error occurred:   class not registered   errors in high-level relational engine. connection not made data source datasourceid of 'dsn2loc', name of 'dsn2loc'.   now possible explain me reason?     thanks   hi farhad, based on kb http://support.microsoft.com/kb/973639  , might bug. what's version of sql server? have applied latest service pack

Is there a way to reskin VS11?

is there way change hideous appearance of vs11?  if possible, reskin resemble elegant, eye-pleasing appearance of vs2010 (menu titles don't yell @ me in all uppercase, colored toolbar icons, etc.) i've looked appearance options, far i've found switch between light , dark themes. thanks. dpittman1 wrote: is there way change hideous appearance of vs11?  if possible, reskin resemble elegant, eye-pleasing appearance of vs2010 (menu titles don't yell @ me in all uppercase, colored toolbar icons, etc.) i've looked appearance options, far i've found switch between light , dark themes. thanks. not @ moment in upcoming rc in color. take @ screenshots: http://blogs.msdn.com/b/visualstudio/archive/2012/05/08/visual-studio-11-user-interface-updates-coming-in-rc.aspx personally new revised not caps menu. raffaele rialdi  http://www.iamraf.net weblog: http://blogs.ugidotnet.org/raffaele microsoft mvp profile https://mvp.support.micr

How do you make a new directory (folder) in which to save a new SSRS report?

when go save report doesn't allow me create new directory (folder). here directory (folder) needs created: \\gdgdb01p\reportserver\production\. can create directory (folder)? thanks, charles hi , you can refer msdn article here https://technet.microsoft.com/en-in/library/cc678409.aspx?f=255&mspperror=-2147217396 or can use stack on flow link http://stackoverflow.com/questions/3205798/sql-reporting-services-copy-reports-to-another-folder thanks abhishek SQL Server  >  SQL Server Reporting Services, Power View

ssrs number format to percentage issue

hi all, i have column avgcost in dataset in ssrs. column have values 77.00,74.00,59.00 , on... now requirement display 77%,74%,59%... in ssrs chart. went textbox properties,number, percentage --remove decimal places 0 showing 7700%, 7400% , 5900% on chart, wrong. can 1 me on this.  thanks, kalyan or can use  below in expression. =format(fields!num.value/100,"0%") please mark answer or vote helpful post if helps solve question/problem. http://techequation.com SQL Server  >  SQL Server Reporting Services, Power View

SQL 2005 Import and Export Wizard

hi, getting below error while exporting .csv file. please - copying e:\members.txt (error) messages · error 0xc02020a1: data flow task: data conversion failed. data conversion column "hintanswer" returned status value 4 , status text "text truncated or 1 or more characters had no match in target code page.".   (sql server import , export wizard)   · error 0xc02020a0: data flow task: cannot copy or convert flat file data column "hintanswer".   (sql server import , export wizard)   · error 0xc0047022: data flow task: ssis error code dts_e_processinputfailed.   the processinput method on component "destination - members_txt" (160) failed error code 0xc02020a0. identified component returned error processinput method. error specific component, error fatal , cause data flow task stop running.   there may error messages posted before more information failure.   (sql server import , export wizard)   · erro

2012 SSIS: Referencing child packages in other projects

hi,  i have ported ssis framework app 2012 i've hit problem.   i have organised packages projects within solution, , have a control package executes these in right order, manages dependencies, etc.  simple enough. or thought, turns out in new deployment model can use "execute package task" on packages within project , not across solution. the options can think of: put packages in 1 project.  as packages must sit under default "ssis packages" folder (afaik) , have hundreds of packages loading many source systems going messy.  i don't want work big list have scroll through. switch file system.  seems option right now.  big shame liking new way of doing things, want use catalogs. call child packages through sql.  this seems problematic, ive read issues passing params, managing async runs, bubbling errors, etc.  this seems whole load of hassle. something else? has else faced problem , if so, have done? cheers. perhaps via .net code in script ta

Instance connection problem

hi, tried install sql server 2008 through local account , got installed. after faced issue while connecting instance. giving error. error ############################## title: connect server ------------------------------   cannot connect mssqlserver.   ------------------------------ additional information:   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: named pipes provider, error: 40 - not open connection sql server) (microsoft sql server, error: 53)   help, click: http://go.microsoft.com/fwlink?prodname=microsoft+sql+server&evtsrc=mssqlserver&evtid=53&linkid=20476   ------------------------------ buttons:   ok ------------------------------ ####################################### can please me on this... 1

Server Error in '/public' Application. (When trying to register invitation id)

hi, i'd try out ssds , have invitation id. app, should insert invitation id gives runtime error. according notifications service should , running. where should contact page ( https://beta.mssds.com/public/default.aspx ) , running again? thanks! jukka we , running, try provisioning now.  if have trouble pls email me @ anilred (at) microsoft.com thank patience , understanding anil Microsoft Azure  >  Azure SQL Database

Trend Line for stacked barchart ssrs

hi all need add trend line in ssrs ,i have created data set actuals , targets , 2 other columns used  category groups , series groups .i need show single trend line of targets  agaisnt stacked bar chart  for actuals,i followed article @ http://support.microsoft.com/kb/842422 ,its giving me multiple lines ,does ssrs support ,i have been following few previous msdn forums , seems ssrs doesnt support this. many thanks hi, think possible. add 2 series bar chart corresponding actual , target data. add moving average trendline target data , hide target bar chart in series properties. set period 1 in trendline properties. associate same series group , category group both series. SQL Server  >  SQL Server Reporting Services, Power View

Upgrade from TFS 2013 update 4 to TFS 2015 update 1 - Scheduled backup alerts fail

hi, i performed in-place upgrade tfs 2013 update 4 tfs 2015 update 1. scheduled backup job hasn't been sending notifications team foundation administrators since upgrade. an error appears in application event log after backup job scheduled run. here portion of error: detailed message: tf400703: unable initialize specified service microsoft.teamfoundation.server.core.tswaserverhyperlinkservice. exception message: tf400367: request not performed due host type mismatch. please check connection information , verify information correct. request executed against deployment, application. (type unexpectedhosttypeexception) exception stack trace:   @ microsoft.teamfoundation.server.core.tswaserverhyperlinkservice.microsoft.teamfoundation.framework.server.ivssframeworkservice.servicestart(ivssrequestcontext systemrequestcontext)   @ microsoft.teamfoundation.framework.server.serviceprovider.getserviceimpl[t](ivssrequestcontext requestcontext) here portion of job history conf

how to get cell template control values

halo experts,     below code bined cell template in datagrid. consider datagrid itemsource binded collection of 5 objects. according below code, 5 text box , 5 date picker controls generated inside datagrid. how can each controls?(5 text box values)  <my:datagrid x:name="targetdatagrid" autogeneratecolumns="false" > <my:datagrid.columns> <my:datagridtemplatecolumn header="birthday"> <my:datagridtemplatecolumn.celltemplate> <datatemplate> <textblock text="{binding birthday, converter={staticresource dateconverter}}" fontfamily="trebuchet ms" fontsize="11" margin="5,4,5,4"/> </datatemplate> </my:datagridtemplatecolumn.celltemplate> <my:datagridtemplatec

Issue in tf checkin - "TF10139: The following check-in policies have not been satisfied"

hello, i set build agent on new box.  i configured existing tfs server use , set software redists, .net framework, etc. identical 1 of existing build agents churns automatic builds successfully.  but, build failing on new agent when trying check-in file after making version modifications through vb script.  the file msi install project.  the failure this:  "tf10139: following check-in policies have not been satisfied:     internal error in changeset comments policy      no files checked in." i have gone through forums , of them suggest install power tools.  but none of existing build agents have them , go past above step successfully.   any sincerely appreciated. thanks, ananth.  hello ananth, check out ewald hofman's solution checkin of version related files during builds:  http://www.ewaldhofman.nl/post/2010/05/13/customize-team-build-2010-e28093-part-5-increase-assemblyversion.aspx this page shows how check-in file , how 'override'

Display Image in work item form for TFS

Image
i have modified bug.xml work item. have added a field call status . if status rush add rush.jpg (red circle) next status field in bug.xml. is possible? thank you you can create own work item control shows image: http://msdn.microsoft.com/en-us/library/bb286959.aspx ewald - please remember mark replies answers if help. blog: www.ewaldhofman.nl Archived Forums V  >  Team Foundation Server - Project Management & Work Item

SSRS 2008 Can't Add A GROUP Footer To Existing Tablix With No Footers

Image
i don't know if else has done same thing or if i'm 1 noticed this, can't add group footer existing group.  here why responses in every forum i've seen question not work me.  "solution" right click on last row in tablix , choose insert row -> either inside or outside group (below). 1. adding row inside group (below) keeps in group, not add footer.  adds detail row.  don't want "footer" print every detail row.  report pdf went 52kb 800kb when tried option. 2. adding row outside group (below) adds footer, if read beginning of sentence, you'll note outside group.  therefore, not group footer.  that's more of tablix footer.  i using option #2 , problem footer might extend 2 or 3 pages beyond last detail row - , headers not show on pages.  if there no detail row on page (inside group), no headers show up.  before says set repeatheaderrows true, it's set true.  i've set keeptogether to true , keepwithgroup before or after

sp_attach_single_file_db failed due to a corrupted log file

hello have problem if can help exec  sp_attach_single_file_db  @dbname = 'world',     @physname = 'c:\program files\microsoft sql server\mssql.1\mssql\data\world.mdf' msg 1813, level 16, state 2, line 1 could not open new database 'world'. create database aborted. msg 3456, level 21, state 1, line 1 could not redo log record (9767813:109:10), transaction id (1:1182802845), on page (1:27846), database 'world' (database id 5). page: lsn = (9767810:70:66), type = 2. log: opcode = 3, context 19, prevpagelsn: (9767812:47:11). restore backup of database, or repair database. msg 3313, level 21, state 2, line 1 during redoing of logged operation in database 'world', error occurred @ log record id (9767813:109:10). typically, specific failure logged error in windows event log service. restore database full backup, or repair database. thanks i made it, simple tho'   here it is did     1) make new db name 2) stop sql server 3) rename/del

Is there a way of having a default value for a binding that has no value defined yet?

hi, i have binding setted in xaml side. however, makes sense when datacontext defined. the result hided or shown element, however, shown while bind not completly defined thru data context. is there way of setting standard value binding? thx, nuno i can think of solution, overkill given scenario: add conveter binding. in converter check if source value null, case when no datacontext set. in case, return default value. if not null, return source value is. ensure whenever datacontext not set default value set. hope helps, jim http://jimmangaly.blogspot.com/ please mark replies answer if answer question Silverlight  >  Programming Silverlight with .NET – General

Is there a way to see who imported a new work item template in a team project?

hello, we have had issue unknown user importing scrum work item templates team project created msf agile template. has caused issues bug template overwritten scrum work flow among other things.  so i'm wondering if there way can tell imported work item templates , when did it. i've looked through content database , didn't see anything. perhaps there command can run or third party tool? can see pretty every other action user takes in tfs, i'd surprised if there no way see makes template change, considering level of impact template change can have on project. thanks, patrick hi patrick, thanks post. and sorry inconvenience, tfs not record information(who edit/import work item type team project) in database. as team project administrator group users can import work item type team project, can contact admin users confirm did that. for scenario, please submit user voice site at: http://visualstudio.uservoice.com/forums/121579-visual-studio . microsoft

Aggregate Function is not allowed in Standard Server Edition

i'm trying use none aggregate function on measure error saying "aggregate function none not allowed in standard server edition".   the funny thing is i'm running developer edition.  is developer edition same standard edition?   has else run this? this recent olap newsgroup thread may help: http://groups.google.com/group/microsoft.public.sqlserver.olap/browse_frm/thread/36855351fd3096b2/c7107957b1da7a13?#c7107957b1da7a13 >> aggregation function none not allowed in standard edition from: chris webb  - view profile date: fri, oct 20 2006 12:24 pm email: chris webb <onlyforpostingtonewsgro ... @crossjoin.co.uk> groups: microsoft.public.sqlserver.olap not yet rated rating:   show options reply | reply author | forward | print | individual message | show original | report abuse | find messages author hi roger, have set deployment server edition property appropriately o

Multiple relationship for the same field

hello ! i have situation : table : article id name category ......................... table : services id name nr value ------------------------- table : sell_item id item_id quantity price value ---------------- now problem : field item_id on sell_item table can id  an article or service. need create double relationship field 1 article table 1 service table. is possible ? if not , or if i'm wrong how can solve situation ? thank you. hello, please try following resource: http://stackoverflow.com/questions/10253986/sql-foreign-key-issue-with-2-parent-tables resource offers 3 options. hope helps. regards, alberto morillo sqlcoffee.com SQL Server  >  Getting started with SQL Server

How to guarantee closing SqlConnection on app exit

i have desktop winforms app keeps sqlconnection open while it's running.  sqlconnection member of global singleton object.  rest of app accesses global connection through object.  tried close() connection in destructor of global object, fails.  tried adding idisposable class, , added close dispose method, dispose not called automatically.  keep app modular , have global object take care of closing connection when it's released, don't know of way. even if violate modularity , have app explicitly call dispose on object, isn't clear how accomplish this.  added handler applicationexit in main() startup code, event raised upon calling application.run open main form.  dispose method of main form won't work either, main form won't opened if there startup problems. can suggest strategy guaranteeing connection closed, while still preserving code modularity?  maybe winforms question, not ado -- if please advise. hello, if want have persistent connection, may

Why can I not see stored procedures in the "programmabilty" folder in the object explorer? (from a Newbie)

the title say's really, anyway. so have table in "helloworlddb" database sqlserver 3.5 compact edition created using : microsoft sql server management studio      10.50.1600.1 and have been kind of following along how video series where it say's create stored procudure right click on folder says programmabilty, when there no link creat new or indeed stored procedure? bit confused here, bit of patient appreaciated paul sql server compact edition doesn't support stored procedures. are using compact edition or sql server express edition (which support them)? cheers, bob beauchemin, sqlskills SQL Server  >  SQL Server Compact

View with parameter

hi, i create view in sql server enterprise manager - view design, this:     select customer, name scheme.custm customer=? there's sql syntax error message - "parameters cannot used in query type."   when run sql query in sql query analyzer as:     create view view_customer select customer,name scheme.custm customer=? there's error as:     "count field incorrect or syntax error."   what's problem?   thank. yabing parameters not supported in views. instead can use udf more or less parameterised view   read user defined functions in sql server   eg create function fncustomer ( -- add parameters function here @customerid varchar ( 20 ) ) returns table as return ( select * from customers where customerid = @customerid ) go -- function call select * from fncustomer ( 'alfki' )     or   create view mentioned without parameter , in select statement give condition   s

Checking if a session exists

hi,  i new silverlight , used create basic sites in asp.net.  in asp.net remember used check on page load whether there open session.  if available, allow user access particular page, otherwise redirect him login page.  the code similar this:   1 protected sub page_load( byval sender as object , byval e as system.eventargs) handles me .load 2 try 3 if not ispostback then 4 if session( "userid" ) = nothing then 5 response.redirect= "test.aspx" 6 end if 7 catch ex as exception 8 end try 9 end sub  can tell me how possible in silverlight?  using vb.net code behind silverlight.  thanks also, if not using ria services, can perform authentication using wcf , asp.net application services.  here link, in c#, illustrates must authenticate user: http://silverlight.net/learn/applications/adventureops/ thanks, ron kanagy  

An OLE DB error has occurred. Error code: 0x80004005

i have query in data flow taking data 1 database , inserting another. ssis running on sql server 2005 service pack 3, connection types both source , destination , sql server native client, in between source , destination have row count transformation followed derrived column transformation. dataflow bombing out following error message: ssis error code dts_e_oledberror. ole db error has occurred. error code: 0x80004005. an ole db record availabl. source "microsoft native client" hresult: 0x80004005 description: "unspecified error" has come across before, if can point in right direction of resolution might be. have noticed been raised on forum before, answers being refer discussion thread, when click on link, url cannot found :-( thanks in anticipation of whoever may pick , offer me help. chris  is error message posted? task reporting error inside data flow? SQL S

Extract Data from SAP CRM 6.0 to SQL Server 2008 using SSIS

hi guys,   do have idea how extract data sap crm 6.0 sql server 2008 using ssis. or can extract data using , apis sap? what need is: migrate data saved in sap crm 6.0 database using sql server database server. don't know if information saved normalized table, don't know if there apis can use migrate data.   please advice. regards, ahmad elayyan maybe here http://blogs.msdn.com/b/adapters/archive/2007/12/31/using-ssis-to-read-data-from-any-table-returned-by-an-rfc-bapi-with-sap-ado.aspx   víctor m. sánchez garcía (es) (bi) hope help. please vote if find posting helpful. if answer question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky SQL Server  >  SQL Server Integration Services

Query on XML datatype in SQL Server 2008

hi all, in table have column xml datatype. can able read below xml tag. set   @title = cast ( @xmlcontent . query ( 'data(root/chemicalname)' ) as varchar ( 50 )) <root><chemicalname>sulphuric acid</chemicalname></root> but how can read (in sql server 2008) with multiple rows in it, , how know list of child nodes , data of dynamically? <root> < row > < currencycode > gbp </ currencycode > < currencyname > pound (sterling) </ currencyname > </ row > < row > < currencycode >inr </ currencycode > < currencyname >rupee </ currencyname > </ row > </ try demo: create table #tmp ( id int identity primary key , yourxml xml ) go insert into #tmp values ( '<root> <row> <currencycode>gbp</currencycode> <currencyname>pound (sterling)</curre

I can't able to connect the instance B from instance A through SSMS

hi all, i trying connect instance b instance through ssms sql authentication, can't able connect , error is... a connection established server, error occurred during pre-login handshake. (provider: tcp provider, error: 0 - existing connection forcibly closed remote host.) (microsoft sql server, error: 10054) can 1 me on this...what areas have check. thanks in advance, rup dear rupc please click on solution  hope you. please mark answer if issue resolved. regards chetanv SQL Server  >  SQL Server Data Access

Microsoft: Please read and give clear guidance. I don't want to be developing for a dead platform!

http://www.theregister.co.uk/2010/09/09/microsoft_html_5/ the rumors everywhere silverlight toast or on it's way out. wpf dead duck no real reason for existence. we're deciding right if should going html 5 or silverlight. i'm leaning silverlight's way because of scalabilty , richness of ui real pita in html 5, if ms going abandon , go down route of forking html 5 don't want waste finite resources building silverlight. we need clear , explicit guidance and positioning you're plans are, otherwise you're making decision me leaving in air have choose industry standard , safe way of doing things html 5 , live deep hatred of javascript. rumors , opinions great stirring pot, , there lot stirring out there in regards html 5 , silverlight.  so take the approach of looking @ going on.  microsoft pumping lot of resources silverlight.  it is now web, phone, , soon-to-be embedded enabled.  not going anywhere time soon.  past several years, micr