Ehsan_AIUB's Q&A profile

• SQL Server FTP Taks Fail

  Hi, sorry again, l've a package which call the FTP tasks. In design-time, it works fine. While l put it into SQLAgent to run in schedule. It fails. The package log file said, OnError,MAXIS-SYSOPT,NT AUTHORITY\SYSTEM,FTP Raw File Motorola,{b3b941f5-ebc2-4b38-b314-87ff4827c2a8},{E93D51C5-539E-4CEE-B616-BBCFF9FA813E},4/18/2006 3:18:23 PM,4/18/2006 3:18:23 PM,-1073573489,0x,Unable to connect to FTP server using "Metrica FTP". Does anyone know what's happening So this is occurring all on the same machine Success in designer and failure through agent When something works elsewhere but not under agen ...Show All

• SQL Server Drillthrough Functionality via Excel Add-in

  Hi, I'm using the Analysis Services Excel Add-In to query a Cube built with partitions. When using the drilldown functionality for my current\default partition the function seems to work fine. However, when I try to drilldown on data in the other partitions, the following error message appears: "Unable to Drillthrough on this Cell" Would someone please be able to shed some light on this Many Thanks Jonathan Derbyshire           Jonathan_Derbyshire@Hotmail.com I want to ask you. Are you using sql 2000 or sql 2005 If you are using sql 2005, are you connecting from excel in the serv ...Show All

• .NET Development Storing Data in XML

  i am a newbie to XML please tell me how can be a xmldata protected if it is with the application on a local machine..........how can i store in a way that user cant view it directly.............. Hi, If you are using .NET Framework v2.0, then take a look at the following article: http://www.devx.com/dotnet/Article/21564 Otherwise, you can still treat the entire XML as an encrypted string. For string enrcyption take a look here: http://www.devarticles.com/c/a/VB.Net/String-Encryption-With-Visual-Basic-.NET/ Regards, Vikram ...Show All

• Visual Studio Problem printing report

  I have a crystal report on a ASP.NET web page. In the report file (.rpt) file, i have set the printer setting to 'No printer'. Without that, the report was rendering in a bizarre manner. After i changed the setting, the report on the page is rendered properly but the printing doesnt work. The margin is towards the right most end of the page. What should i do to print the report as i view on the web page I have very little knowledge about crystal report. Am i doing something wrong here Any help would be greatly appreciated. Thank you. Hello, Here are a couple of white papers than can help you: http://support.businessobjects.com/commun ...Show All

• Visual Basic Added Lines in RichTextBox with button

  How do I do this: everytime I press this button i need it to add a line in a RichTextBox (or something else) I tried history.Text = "Sarted Game" but that deleted the previous conrent and replaced it with Started Game. Should I even use RichTextBoxes I am going to eventually need to variables to the lines...how can i do this Or you can use the new c style operators...  Makes for cleaner shorter code. dim str as String = "Hippos are really big" RichTextBox1.Text &= vbNewLine & str Dustin ...Show All

• SQL Server SQL Browser service won't start

  I tried the instructions in sqlexpress's WebLog to connect to a remote database. Using SQL Server Configuration Manager I enabled TCP/IP and then tried to start the browser service. When I right clicked the icon, all the options (Start,Stop,etc) are grayed out. Can anyone help me with this, please Thank you Oops, sorry, I'm an idiot. Properties, Service, Start Mode to Automatic Thanks ...Show All

• .NET Development about collection and template variable

  Hi: I am using Visual Basic.Net 2005 and Framework 2.0. Now I design a class as following: public class para(of T) dim ab as integer dim content as T end class and also I have another class public class equipment dim id as integer dim name as string public paracol as New System.Collection.Generic.list(of Para) end class Here, I have a problem. Because my class para includes a template type T, when i create a collection, I can't do that Anybody knows how to do that Thank you very much! Well, either you know what type you are going to use as the type parameter in ...Show All

• SQL Server Can't open SQL database

  connection string  = "Database=Database1;server=(local)" the program stops at the .open command to open the database. The error states can't connect to remote database. But the database is local (on my laptop).  It is visible in the IDE and the connection test was successful.  File path reference is fine too. Thanks. ...Show All

• Visual C++ Latest compiler creating XP-only compatible .exe files

  [had no luck on the Visual Studio Express forum...] Has the compiler for this new release version of VC++express changed since the beta On a different forum, the following posts have been made: " I always use UPX to compress my binaries, and it seems that compressing the output of the new compiler produces something that doesn't run." "Is there any managed code in it UPX butchers that as I recall as it is not actual valid machine code." "Yes, that must be it.. though I can't find any options to get rid of the damn stuff. I've got CLR support turned off in the settings, and it's exactly the same project that used to work ...Show All

• SQL Server programmatically set the paper size and and paper layout

  how can i set the paper size and paper layout programmatically in RS. im using c#.net as prog. lang. for this. Pls help thanks! I cannot get beyond this line: rs.Credentials = System.Net.CredentialCache.DefaultCredentials I get a soap exception everytime stating that the user does not have the permissions to perform the task. Any thoughts on where and what I need to edit to get this working Thank you. ...Show All

• Visual C# MSBuild PVCS Tasks

  Does anyone know if there is a MSBuild Tasks created for PVCS Also where can find non-Microsoft MSBuild Tasks. Hi, Please post this question in the newsgroup below. Visual Studio MSBuild Discuss the Microsoft build engine aka MSBuild. Topics including: usage of MSBuild, build customization, and MSBuild extensibility via tasks, loggers and hosting. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=27&SiteID=1 We recommend posting appropriately so you will get the most qualified pool of respondents, and so other partners who regularly read the newsgroups can either share their knowl ...Show All

• SQL Server EMail Task Problem

  I have a pretty simple process that copies some files from an AS400 to a directory on the same server where my sql 2005 instance lives. I then use an email task to send these files to a client. However, the email task does not work. I get the following message: [Send Mail Task] Error: Either the file "BYNSOSR1;BYNSOSR2;BYNSOSR3;BYNSOSR4;BYNSOSR5;BYNSOSR6;BYNSOSR7" does not exist or you do not have permissions to access the file. Well, the files definitely exist where they are supposed to be so I guess it's a permissions error. However, I have no clue which user would need permissions on that directory. As a test, I gave ev ...Show All

• .NET Development FtpWebRequest GetResponse throw The server committed a protocol violation :(

  Hello. I have some trouble with FtpWebRequest class. I use it for connection to two ftp servers The first server is working perfectly, but when i use the same programm to connect to another one the "The underlying connection was closed: The server committed a protocol violation." exception is thrown when I call GetResponse method. I found only one difference between servers. The first server returns: 220 Hello k-net ftp server The second FTP return the same banner but ON RUSSIAN Lang!!! 220 ! ! Is any UseUnsafeHeaderParsing property exists for FTPWebRequest, like for HTTP P.S> I'am not usi ...Show All

• SQL Server pipeline

  Hi, I want to incorporate this code but I dont know how to import Microsoft.SqlServer.Dts.Pipeline in an Integration Services Project template. I was thinking of putting this code in the script task but still, I cant import Pipeline. Add reference list does not have it as well. Please let me know how to incorporate this code. Thanks! Code: if (ComponentMetaData.RuntimeConnectionCollection["SourceFileConnection"].ConnectionManager != null) { cm = DtsConvert.ToConnectionManager(ComponentMetaData.RuntimeConnectionCollection["SourceFileConnection"].ConnectionManager); if (cm.CreationName == ...Show All

• Visual Basic Database Questions

  I'm fairly new to creating programs that utilize databases. I have just purchased a book about ADO.NET, but I wondering if anyone could offer some opinions on where to start. In particular, what database program should I begin learning Most of the applications that I want to develop will really only need a local unshared database to systematically store and recall information. I would really like to avoid spending a large amount of money on purchasing a database program, so would MSAccess or MySQL be a good place to start Also, where can I find a good tutorial on the basics of building database applications If anyone else has any point ...Show All