Santosh Tupe's Q&A profile

• SQL Server Problem attaching a database

      Hello, I have made a database in SQL Server 2005 Developer edition. I tried to attach it to a SQL Server 2005 Express Edition but I coundn't. I can attach and dettach it to the developer edition but I cannot do it to the express edition. When I am running the store procedure: exec sys.sp_attach_single_file_db @dbname = 'LinGS',   @physname = 'c:\LinGS.mdf'   I receive the following error: File activation failure. The physical file name "C:\Documents and Settings\Kekakos Elias\My Documents\Visual Studio 2005\Projects\LinGS\LinGS_log.ldf" may be incorrect. .Net SqlClient Data Provider: Msg 5123, Level 16, Stat ...Show All

• Visual Studio Team System Rule provided an empty or malformed Url

  Hi, in FxCop 1.35 beta i got a FxCop message on FxCop start for every user defined rule like this: Rule provided an empty or malformed Url: file:\\xxxx\yyyy\FxCop\HtmlHelp\RuleDescription\zzzzz.html The Url works and i couldn't see any problem there. Is this a bug in FxCop 1.35 beta or what i'm doing wrong Thanks for support Hubertus Hi Hubertus, I just tried the url above on FxCop 1.35 and didn't see the error you're describing. Can you send the full rule xml that was causing the problems Regards, Jeffrey ...Show All

• Visual Studio 2008 (Pre-release) When willbe available the next CTP ?

  When will be available the next CTP... It's already necesary...! I hope that it could have more controls unless the DateTimePicker, the idea of a nullable datetimepicker could be very interesting. And, Do you know if when WPF be released will change the name of the properties ...maybe like 'Content' because this will be a very big problems if it change, current code could not work...! Grettings...! -- Miguel Ortiz Falcon michaelof@hotmail.com Wow -- quick demand for a new CTP :-) We don't have a date to announce for the next CTP -- but you'll notice a pattern of one every few months :-) However, I'd like to set expec ...Show All

• Smart Device Development Howto create an Index for DataTable

  Hi, I'm searching for a method to create an index on selected fields in a System.Data.DataTable that is a member in a System.Data.DataSet. I have created the primary key but lookin' for a possibility to create secondary indices. In SQL thats not a problem ("CREATE INDEX...") but I have to work without SQL... Anyone out there, who can help Thanks in advance Reiner DataTable would create indexes automatically as you filter or sort, you have no direct control over it. Note: NETCF V1 (and as far as I remember desktop V1.1 as well) has issue which would cause index ...Show All

• Visual Studio Generate many files from one template?

  I have a DSL now taking shape, including generating code that executes properly, and I must say I am pleased with how quickly it has come together. Now I have a secondary goal to fill: producing static documentation from the diagram. I'd like to produce a set of HTML files (one for each instance of the primary classes in the DSL). I don't see how I can do that with the current structure, which allows me to generate exactly one file from each template. Do I need to create a new DirectiveProcessor or TextTransformation class Can you offer any pointers on how to create many files from one template Thanks, Brian. ...Show All

• Visual Studio Can't edit macros in Visual Studio 2005 standard edition

  I just installed visual studio standard edition and was trying to edit a macro from the samples. However when I select edit, I get the following error: "Interface not registered". What gives Is this feature not available in standard edition I got the same error from the beta version. Did you completely uninstall Beta 2 from your machine following the Beta 2 uninstallation steps http://msdn.microsoft.com/vstudio/express/support/uninstall/ Neil ...Show All

• Visual Basic Newbie Database Question

  This is a very basic question, but I've wasted a few hours trying to figure it out already, so I'm groveling for help. I'm looking for basic code to help me open a database, read some of the contents into variables, and that's it for now (close the database). The database in question is a flat table in mdb format; 8 columns, 15 rows - each row is a record with a name (p01, p02, etc) and seven associated strings - pretty primitive. The 1st column is the record name. I've gotten as far as associating the file with my project, but can't find the trick on how to open it and read what's in it. The code should: 1) Open the file ("CCUG PreOp.mdb") ...Show All

• Visual Studio Tools for Office Avoiding security alert in Outlook while accessing Contacts in VSTO 2005

  I am trying to access Items programmatically within a VSTO 2005. When I try to access the 'magic' properties such as email1address, I get the security warning within Outlook. I do not want to go back to redemption - that's why I am using VSTO. How do I avoid the security warnings when doing something like the following: private void Form1_Load(object sender, EventArgs e) { LoadContacts(); } private void LoadContacts() { Outlook.NameSpace outlookNameSpace = Globals.ThisApplication.GetNamespace("MAPI"); Outlook.MAPIFolder contactsFolder = outlookNameSpace.GetDefaultFolder(Outlook.OlDefaultF ...Show All

• Visual Basic My.Application.Log.WriteEntry writes double entries!

  Has anyone had the experience in VB 2005 Beta 2 that when using the FileLog listener, each time My.Application.Log.WriteEntry is called to write a message, the message actually gets written to the <appname>.log file twice The log file is stored in directory "C:\Documents and Settings\<userid>\Application Data\<company name>\<appname>\1.0.0.0" with a file name of <xxx>.log and contains entries as follows: DefaultSource Information 1001 20050718 15:25:53-SPSSearch Starting. DefaultSource Information 1001 20050718 15:25:53-SPSSearch Starting. DefaultSource Information  ...Show All

• SQL Server Client-side programming patterns/idioms for SQL Mobile 2005?

  Hello, Where can I get sample code, or a pointer to sample code demonstrating common programming pattern(s) for a client of SQL Mobile 2005 (where the client is also running on the device) For eg, with ADO.NET, I'd do something like: SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = conn.CreateCommand(); conn.CommandText = “--...my query…”; SqlDataReader reader = conn.ExecuteReader(); // loop and process the data   What are the corresponding APIs and calls that I’d use for a SQL Mobile 2005 application using the latest CF.Net 2.0 ADO.Net APIs (or whatever they’re called) I could only find a couple of arti ...Show All

• Visual Studio Team System Why is 'Drop' outside of source control?

  I'm sure a familiar site for a lot of people working with Team Foundation at the moment is a build machine file system littered with a folder after folder of previous builds in the drop location and it seems a bit odd that there is no provision for having the output of the build also placed in source control rather than clogging up the build machine, is there any particular reason for this So, OK, I could extend my team builds 'AfterBuildDrop' target to checkout the previous drop from source control and checkin the new one overtop and giving it a sensible label. I then want to be able at a later date to get against that label and publish to ...Show All

• Visual C# Printing 'this' form...

  OK, I surrender... What I want to do is simply print the form (actually, the tabPage) that's currently active, just the way it looks on the screen. I've gotten into a lot of circular logic with DrawToBitmap and ...Bounds( ) and I'm sure there must be an easier way. If anyone can show me how to do this with a few lines of code, I'd be eteranlly grateful... Thanks in advance for any and all help! John F. I've not actually tried this myself, but when browsing the other day I was reading an article that may or may not cover what you are trying to do: at http://www.codeproject.com/csharp/PrintForm.asp Dunno if th ...Show All

• SQL Server How can I find out whether SSIS is installed in the server?

  Thanks a lot. Have a look at the service SQL Server Integration Services, if it is present you have SSIS installed. YOu can check that by open the SCM or type in the "net start" on the commandline on the server. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Microsoft ISV Community Center Forums EOF or BOF error

  Help! Why am I getting a EOF or BOF error after looping through only a couple of times Do While rst.EOF = False testNo_Rows = rst.RecordCount iPhoneNumber = CStr(Replace(rst("SUBSCRIBER #"), "-", "")) iAmountLoaded = rst("SUBSCRIBER TOTAL") iAmountBilled = iAmountLoaded + acct_Amt_allocate iStampDateTime = Now() rstMobileDevices.Open ("select Phone_Number, User_Id, first(Mobile_Type) as Mobile_Type, max(STAMP_DATETIME) FROM tbl_Mobile_Devices WHERE Phone_Number = '" & iPhoneNumber & "' GROUP BY Phone_Number, User_Id") If rstMobileDevices("Mobil ...Show All

• SQL Server HTTP ERROR 401.1 - Unauthorized

  Hi I have access to my Report Manager, but i don't can browse to my reports. I use a domain account with permissions of Administrator in my local machine. My Report Server it's running on W2K3, and now have this error: "You are not authorized to view this page" HTTP Error 401.1 - Unauthorized : Acces it'd denied due to invalid credentials. IIS My windows service it's running under a domain account granted with permissions of Administrator in the local machine. I assigned permission for this account in all folders of Reporting Services and some files. Invalid credentials no, with that account i do logon to the server W2K3, t ...Show All