Talha Ahmad's Q&A profile

• SQL Server Subscriptions

  We are running Reporting Services on an Application server, side by side with a web application. The server exists outside our corporate domain due to the fact that our external vendors need access to the application (not the reports). Our web app uses a third party mail system to funnel the application email thru our corporate exchange server. Since Reporting Services is not connected to our domain, it can not authenticate to send reports via e ...Show All

• SQL Server Analysis Services 2005 OLE DB Provider Error

  I try to open a SSAS Cube but I get a OLE DB error message below. The same cube I can browse with the SQL Server Business Intelligence Development Studio. Error message: Microsoft OLE DB Provider for Analysis Services 2005 Microsoft OLE DB Provider for Analysis Services 2005 reported: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the '<MY Server Name& ...Show All

• SQL Server SQL Server Management Studio Express - Import Data...?

  Hi, I have Microsoft SQL Server Management Studio Express and do not see how I can enable the Import Data... feature which I have seen on the regular Microsoft SQL Server Management Studio version. Basically, if I right-click on a database, I'd like to use the Import Data... function which should be found in this menu under the Tasks... item. The Import Data... menu choice is visible just below the Generate Scripts... choice in Microsoft SQL ...Show All

• SQL Server Question about the way that some element are displayed in the viewer

  Hi! I've notice in some reports that some lines doesn't appear in the viewer but if i print the report or if i export it to PDF i can see the line. I can't figure out what is the cause of this. Anyone know what is the cause of this Thanks ! I've noticed that lines with a slant will sometimes behave this way. Is this the case in your reports Thanks, Donovan. ...Show All

• Visual Studio Express Editions invalid object

  I am trying to write to a database table using native configuration. I have already checked my connection string, I believe I am connecting. However, I get the "table3 is invalid object " error. I checked the spelling and case of my objects. These objects exist. Why do I get this error ok, here's the relevant code: SqlConnection conn = new SqlConnection("Data Source=norby11\\SQLEXPRESS;Integrated Security=SSPI;Connect Timeou ...Show All

• SQL Server Failed to decrypt protected XML node

  Failed to decrypt protected XML node ... blah blah. Looks familiar, right Package Protection mode is : EncryptSensitiveWithPassword Package runs fine from within BIDS. Close package. Open package - asks for password. So far so good. When running from command prompt with: dtexec /File "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\MyPackage.dtsx" /De mypassword Get that cryptography error. Doesn't happen for other packages... what can I ...Show All

• .NET Development Thread safety over string

  I'm making an application that will have a rotating text moving on the screen. I decided to create a thread to manipulate the string shown on the screen. The thread simply moves the last character to the first position. The problem is that the message will be changed over time. As a result, thread safety becomes an issue. I used to use the SyncLock <string> to solve my problem and it seems to work fine. However, when I run the code analysi ...Show All

• SQL Server IF statement Errors in huge SQL Query

  I've not gotten the If statement to work. Before: http://www.webfound.net/sqlbefore.txt After (with IF statement): http://www.webfound.net/sqlafter.txt I don't want to include the deletedpdcs if the month is today in my SUM for PDCs_IL basically is what I'm trying to accomplish here are you referencing the correcdt files I don't see a single IF statement anywhere. And if you're ever getting any errors, you need to post the error here ...Show All

• SQL Server Best and worst scenarios for Notification Services

  Hi, I am just looking for the best and worst scenarios to implement Notification services...This is more to come up with a design guildelines I Would be more interested in the worst sceanrios :) Please share your inputs based on your experiences... Regards, Anjana SQLNS is very good at matching lots of event data with lots of subscriber/subscription data and generating lots of events. It is designed to be "internet sca ...Show All

• Windows Forms GDI+ libs

  I'd like to create a small little app to use for myself that will automatically create a drop shadow on a .jpg file.  For an example of what I'd like to do with .NET check out the thumbnails at the following link: http://www.level3photogra ...Show All

• Visual Basic Change textbox height in Vb.net 2005

  It's impossible change textbox height in vb.net 2005 In vb.net 2003 it was possible and the worst is that each control with the same font has diferent heights like combobox and text box. ...Show All

• Visual C++ Reading Excel files using ODBC

  When i use CDatabase , CRecordset to connect and read Excel file have some problem: 1. If i create a file with Microsoft Office Excel (do not have "Database" struct), have a worksheet, then save and close it. When i run my program, connect to this file, i do not see any table in this file(because Sheet is not a Table) so please help me, how to create a Table(excel) for a Sheet in Microsoft Office Excel . 2. When i create excel file fr ...Show All

• Smart Device Development sql connection error

  I am getting following error: Error 1 The type 'System.Data.Common.DbConnection' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. C:\Documents and Settings\Adnan\My Documents\Visual Studio 2005\Projects\Mobile5\Mobile5\Form1.cs 20 4 Mobile5 the line which caused problem is System.Data.SqlServerCe ...Show All

• SQL Server How to return varchar(MAX) from a CLR function?

  Hi, I am trying to return [ string/SqlString ] from a CLR function, but it was truncated at 8000 characters. How can I solve this problem and return varchar(MAX) Thanks The Visual Studio deployment tool maps SqlString to VARCHAR(8000).  Use SqlChars instead -- it gets mapped to VARCHAR(MAX).     -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDi ...Show All

• Visual Studio Tools for Office Globals.ThisWorkbook disappear?

  I'm still facing the problem as stated at this thread , and now I can't use the basic VSTO object and the partial class of "Globals.ThisWorkbook...." Error 2 The type or namespace name 'ThisWorkbook' does not exist in the namespace 'xxx' (are you missing an assembly reference ) Help. Hey Peter Peter, From the other thread it appears that your solutuion is in a bad state, you should not be able ...Show All