Bala_SSRS's Q&A profile

• Visual Basic error with this connection....DB2 database

  Pice of my code, have error provider not found in ConnectionString .... Private Sub SetupADO() On Error GoTo SetupADO_Err Dim adoParm As ADODB.Parameter ' Create connection object and connect to database Set acnBooks = New ADODB.Connection With acnBooks .ConnectionString = "Provider=IBMDADB2.1;Data Source=SAMPLE;Persist Security Info=False" .Open .CursorLocation = adUseClient End With ................. Provider=IBMDADB2.1... must be installed on your machine in order to use it! Also for further help with VB6 issues please see any of the following resources...VB6 is considered off topic for these forums. Useful Links Visual Basic 6.0 on MSDN Library Visual Basic 6.0 Help and S ...Show All

• Visual Studio Accumulative Summation of a Column that Not Included in the Available DataSet Fields? (ReportViewer)

  Hi, I am wondering that how we could add a custom column to a 'table' control within a 'ReportViewer' file that contain the accumulative summation of another column that not included in the available DataSet fields. Example: I have the following DataSet fields: Product, Price, and Qty With the following columns ---> Expressions: Product ---> Fields!Product.Value Price ---> Fields!Price.Value Qty ---> Fields!Qty.Value Total ---> Fields!Qty.Value * Fields!Price.Value Balance ---> So the ouptut will be like this sample: Produce Price Qty Total Balance ------------ ------- ---- ------- ----------- AAA 10 2 20 20 BBB 5 3 ...Show All

• SQL Server Select Permission Denied on object

  Hello all, I have just begun to develop a simple web application to maintain phone book / contact details of people. I have been facing problems wrt the connection to the database, while trying to execute the reader it throws this error - Server Error in '/phonebook' Application. Hi, I fixed the error by assigning the default schema for teh database to DBO. eg: Login to SQL using SA > Security > User > select username > properties Make sure that 'Users = username' & 'Schema = DBO' Let me know if you have any queries. --Viraj ...Show All

• SQL Server auto-commit vs begin transaction overhead

  I've googled for the answer and searched sql server 2005 books online and I haven't been able to find the answer to my question. My main question is what is the difference in overhead between using auto-commit on every statement or explicitly calling begin transaction on every statement. I'm basically looking for documentation that points to the difference. Read on for the scenario... We have an application that has problems with deadlocks. Part of our strategy in handling these deadlocks is resubmitting the transaction. My solution to this part of the strategy is to wrap every storedprocedure in a transaction so this would include reads and writes. My architect has raised some concerns with regard to performance if it's implemented this w ...Show All

• Windows Live Developer Forums Coupling newMediaObject and newPost/editPost events

  I have a couple questions so here goes... 1. Why does WLW call metaWebLog.newMediaObject when you are editing a document with embedded images, even though the images on the document arent altered in any form. How is one to know if these images are to be persisited to the db table or these already exist in the db table (with newPost) & are just being re-submitted again by WLW. 2. Why does the newMediaObject get fired before newPost/editPost by WLW Doesnt it make sense for newMediaObject to be passed the postId - which can only happen if it is called after newPost/editPost. How else can one associate embedded images with the containing post. Being that the post can be stored as a binary document in a db 3. Can the html <a> ...Show All

• Visual Studio Team System VSTE Crash on Rename of WebTests and OrderedTests

  Back on April 19, 2006, the following problem was posted regarding VSTE crash problems whenrenaming webtests. I didn't find any further thread information/answer/resolution/suggestion. I'm experiencing the same problem... but with not just webtests... but with orderedtests, as well. Is there a suggested solution available Tx dgorena_MS (Expert): Q: If I go into Solution Explorer and attempt to rename either webtests or folders that they are in, there's a 50% chance that VS just shuts down. Re-opening the project and showing all files shows that both the original and renamed files are there. A: Is this something that you can repro for any project or a specific project We definitely want to know the cause of this and help you ...Show All

• Software Development for Windows Vista No Answer: Converting existing workflow from code based definition to xoml

  Hi, I have very exact problem that is explained here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=796006&SiteID=1 The API works, but I get just one element for a fairly complex workflow. How can get a full xoml form of an existing workflow Any help would be appreciated, Alan Actually, here is how it doesn't work: You have two options for creating sequential workflow in VS2005: Sequential Workflow (with code separation) Sequential Workflow (Code) Your code works fine if the workflow is created by using the 1st option. If you use other template - "Sequential Workflow (Code)" -, then all you get is an xoml file with just one tag defi ...Show All

• Visual Studio 2008 (Pre-release) RC1: Parsing issue?

  When I try to open a page in Cider, I get a parsing error from my main application XAML. Here's the error: Error 1 Value '/Library;component/Skin/Default/SkinStyle.xaml' cannot be assigned to property 'Source'. C:\...\App.xaml 8 29 Here's the XAML: < Application x:Class = " App " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " > < Application.Resources > < ResourceDictionary > < ResourceDictionary.MergedDictionaries > < ResourceDictionary Source = " /Library;component/Skin/Default/SkinStyle.xaml " /> </ ResourceDictionar ...Show All

• Visual Studio Express Editions vb excel align

  Hi. I was looking for an answer to that question for quite awhile. How can I center text in excel using vb. I was trying Dim xlws As Microsoft.Office.Interop.Excel.Worksheet = oWorkbook.Worksheets.Item(1) xlws.cells.HorizontalAlignment = xlcenter but it doesn't work Pseudo Code.... Dim xl As New Excel . Application Dim xlWkbk As Excel . Workbook Dim xlSheet As Excel . Worksheet xlWkbk = xl . ThisWorkbook xlSheet = CType ( xlWkbk . Sheets (1), Excel . Worksheet ) xlSheet . Range ( "A1" ).Select() xlSheet . Range ( "A1" ). HorizontalAlignment = Excel . XlHAlign . xlHAlignCenter ...Show All

• Visual Studio Team System Build reports not reflected in project portal

  hi.. I am in the process of doing build automation for .Net1.1 projects... I was given a solution in my previous thread.... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=874329&SiteID=1 I followed the solution given in http://blogs.msdn.com/nagarajp/archive/2005/10/26/485368.aspx This works well. But after building the project, it is not reflected in the portal. I checked with the database in the TFS Server. The data is getting inserted in the build related tables. But this information is not available in the portal. Please help me on this. Thanks Bob. hi... i checked with the status of the warehouse...it says 'idle'... but i have builds that happened yesterday ...Show All

• Visual Studio Express Editions How do you get the contents of sertain folders to show in a ListBox?

  Hello. Can any one tell me how to get the contents of the History folder to show in a LiskBox when ya click a button, and the same with the Temoprary Internet Files folder Aslo, how do you get the ListBox to clear and only show the contents of the folder selected when ya click the Button, and the contents of all the folders showing in the LiskBox. Am an absolute beginner, only started learning 2 weeks agao, any help will be very much apreciated. Thank you. im pretty sure I answered this question before http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=984031&SiteID=1 ...Show All

• Visual Studio 2008 (Pre-release) Service return another Service

  Hello, i have written a Service (IService and Service) in which i can authenticate to the service now another method should return another Service-Instance in which i can access to database. How can i do this Example: [ServiceContract] public interface IService { [OperationContract] string Authenticate(string user, string password); [OperationContract] IDatabase GetDatalayer(string ticket) } public class Service : IService { public string Authenticate(string user, string password) { return ticket; } public IDatabase GetDatalayer(string ticket) { if (ticket == "xxx") { return new Datalayer(_connection); } } } [ServiceContract) public interface IDatalayer { [OperationContract] DataTable GetUsers(); } ...Show All

• .NET Development Sending Email using System.net.mail

  hi everyone, I have trouble to send email using system.net.mail in ASP.NET 2.0 with VB here is my code.... any body tell me what is going wrong with the code. Code for SendEmail.vb Imports Microsoft.VisualBasic Imports System.Net.Mail Public Class SendEmail Public Sub SendEmailMessage( ByVal fromMail As String , ByVal toMail _ As String , ByVal subjectMail As String , ByVal messageMail As String ) 'This procedure takes four string parameters for sending the mail Try 'address create a mail message Dim MailMsg As New MailMessage( New MailAddress(fromMail.Trim()), New MailAddress(toMail)) MailMsg.BodyEncoding = Encoding.Default MailMsg.Subject = subjectMai ...Show All

• Windows Live Developer Forums Pre-Processing Tiles for Image Manipulation

  Hi Everyone, I have seen some examples on the web where people superimpose various effects on top of the maps. IE. They would show temperature by shading different areas of the map to show different temperature. This goes beyond just drawing polygons on the map, they seem to have used a better way of displaying graphics on top of the map. I was wondering if grabbing the tile first, then adding any graphic data to it before serving it would be the best way of doing this kind of thing. I know you can do various mashups of data etc. but I was looking for a dynamic way of maniulating the image based on data changind day to day Any suggestions would be appreciated. Thanks, sos The best method i ...Show All

• Visual C# Attributes at DesignTime

  If I set an attribute on a class, I can get at that attribute when the class in question is actually executing. But I can't seem to be able to get at it in the design context. I don't mind admitting having difficulty explaining this problem The example below shows a class decorated with a Custom Attribute "DesignServiceConsumer" the constructor of which needs a Type parameter - it is intended to be, invariably, the Type requesting the service. Additionally the class has a standard Attribute "Designer" it requires the Type that performs design services (pre & post filtering of properties etc) on behalf of catActionCombo. In this case when catActionCombo executes, other classes can locate and interrogate the ...Show All