barkingdog's Q&A profile

• SQL Server Disable a task in the current package programmatically?

  Hi, I have a package comprising a number of Data Flow Task steps, to import various tables of data from some Access databases into SQL Server. The name of some of these Access databases will change depending on the date, e.g. last year's data is currently in a database called "2005data.mdb". At year end this will be superseded by "2006data.mdb". The Access databases are within a 3rd party system so I have no control over the file names. I have a Script Task that checks the current date, and changes the name of an Access database in the connection string to reflect last year's date. But to complicate matters, last year's file might not exist. So the Script Task checks whether the file name exists. If not, I woul ...Show All

• Visual C# Why did I only get part of what I intend to get?

  No error was complained! The following program is to write a whole year's month,day,weekday in a MSSQL table. But somehow, for many times I have tried, but each time I got only part of what I intend to get: the whole year with 12 monthes, instead, I only got 3 or 4 months' content in the table. Can anybody tell me why calendar.dll using System; using System.Configuration; using System.Data; using System.Data.SqlClient; using database; namespace calendar { public class calendar { private int _nian; //year private int _yue; //month private int _ri; //day private int _xingqi; //weekday private string _errorInfo; public int nian { get {return _nian;} set {_nian=value;} } public ...Show All

• SQL Server Can you install MSDE2000 after you have installed SQL Server Express?

  I am aware that instances of both can exist on the same machine. But I assume that is when a different instance of SQL Server Express is installed with an existing instance of MSDE2000 Many moons ago, when the various flavours and betas of SQL Express became available, I upgraded from MSDE2000 - didn't think I would need it again. I now have an application, Sony Vegas 6, which uses MSDE2000 for it's Media Manager. According to their support it won't install to SQL Server Express 2005. When I try to install MSDE2000, it always fails with "Setup failerd to configure server..." and rolls back. In the event log, there is an entry The description for Event ID ( 19011 ) in Source ( MSSQL$SONY_MEDIAMGR ) cannot be found. The local com ...Show All

• Visual Studio Express Editions How to debug DLL?

  Hi, I have a dll written in C++ (6.0 MFC). The functions of this dll is called by an application I just started in C# 2005 Express edition. I read about how to call a dll in C#, but my problem is the reverse situation. I need to debug the dll to find out if all parameters are passed correctly from C# to the dll functions. But if I set the exe file compiled from the C# to test the dll, it does not even start (it does when I start outside of the C++ debugger). What is wrong and what can I do I would be grateful for any help. Peter Hi Mike, Finally I succeeded with attaching the 2003 debugger to the C# 2005 exe. It is not a perfect solution, and I will try to recode the dll ...Show All

• SQL Server Replicate only schema...

  Hi, I am relatively new to replication. I have a rather dumb question. I have two SQL Server databases, If i make a change in the first database schema, i want it to replicate to the second database. i dont want the data to replicate though. Is this possible Thanks, Raj Hi, SQL server 2005 transactional replication supports replicating schema change. You might want to read through BOL "Making Schema Changes on Publication Databases" ( http://msdn2.microsoft.com/en-us/library/ms151870.aspx ) to review what kind of schema change is supported. To replicate only the schema, the simplest way is to add a horizontal filter that removes all rows. For instruction on how to define a filter, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. C# Lack of pointer confusion

  My lights are kept in the main Game class. I register my light sources with my render manager so all of the shaders know which light sources to use. I want to be able to update a light source in the Game class (like sunlight) and it be updated for my shaders. I'm passing the source in by ref, but when it gets added to the Dictionary (which holds the name of the light and the light vector itself) it seems to be adding a copy. When I update the light in Game, it is not being updated in that Dictionary. I am pretty much new to C# but have been programming in C++ for years. In C++, I'd just store a pointer. Thanks // This code is from the shader class m_LightSources = new Dictionary<String, Vector3>(); public void AddLightSource(S ...Show All

• Visual C# Overwriting code files

  Is there a way to allow Visual Studio to automatically overwrite code files without asking me (the user) each time if the file is read only There is no easy way to accomplish this. You could however write an extension for Visual Studio that does this but personally I would not recommend that as source code controlled files also depend in the Read Only attribute and you do not want to mess with this. ...Show All

• .NET Development How to download a text file after logging(authentication) into a web server

  Hi , I am trying to Download a text file after logging into a web server server . I can log into and after that is a huge mark. The page after logging in contains the URL of the text file. I have tried making a new HttpWebRequest object and used the url in the page but still it's not working it says access denied. Below given code just helps me to log into the page that has the url to the text file. I need to retrieve the text file. Can some help me please. using System; using System.Collections.Generic; using System.Text; using System.Net; using System.IO; namespace Logon { public class Autologger { public static void Main( string [] args) { HttpWebRequest httpRequest; H ...Show All

• Windows Forms How to use domain user instead of database user in vb.net windows form authonitication?

    Hi all, we make security on our developed .net application using created user that stored in the application DB in table users and also we create an equal sqlserver user with the same name and password. when the user log into the application using his user name and password the user checked if it is valid or not and based on his permissions we open the functionalities and forms that is permitted to him. Now i want to use the domain user instead of a special user to authenticate the application and passed on this domain user .... i am using now vb.net 2005 and sqlserver 2005 and we use windows authontication on the level of sql server 2005 on the domain users instead of sql users.. so what the changes that i ha ...Show All

• Windows Forms extend binding navigator service

  Hi I want to add two button controls to the binding navigator for query by example first button: filter , in that case , all controls of the form are cleared , and user can enter values in the controls. second button: apply filter, when user click it , the filter which is composed by reading every control value is applied to the base table and data is reterieved. i want to add these services to the binding navigator . can you help me thanks in advance Why not use the name of the textbox to get the textbox For example, you have fields in database table named field1,field2,field3... and you have textboxes related to these fields, which named txField1, txField2, txField3...then write code like: whereSqlEx ...Show All

• .NET Development Merging of two DOCX files in XPS file

  Hi, I have two DOCX files ( Microsoft Office 2007 ). I want to merge these two files into XPS file how can I do that Plz tell me as soon as possible You might want to ask in this XPS forum . ...Show All

• Visual Basic restart application with check new version

  in my application, there is a step needs to check last version, sometimes customer run the application in offline mode, so the application will not check the newer version. at that step user must connecto to the internet and I have check it manually. If there is new version application must to restart. I'm using application.restart but this way will not check newer version. so what is the solution, to make it check newer version really it is common way but in my application there is an step tell user there is a newer version and force him to download and the application will restart and update automatically, so even if I add it to the Help menu this step still required. ...Show All

• SQL Server HELP, error report, Setup Bootstrap\Log\SqlSetup0017.cab

  I've installed SQL express eight times at least. The first time it went throug without warnings. Now, I'm getting this by simply wanting to open Northwinds or Pubs database to practice with. Path=c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0017.cab Thanks for you support everyone! Karen Thanks, I tried this from the command prompt: "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe SKUUPGRADE=1" cannot find setup.exe or one of it's componets. I would like to get the free copy from Microsoft working before buying the entire SQL server package. Please advise, you've been helpful Karen ...Show All

• SharePoint Products and Technologies schema.xml with own fields -> Displaying them in NewItem.aspx

  Hi, I have custom list definitions in my feature. So I edited the default schema.xml (after creating a new list definition in my VS2005-project) and added some fields like: <Field Id="{213DCBD5-EF1B-4175-AA2D-5258FC550A99}" Name="Personalabteilung" BaseType="Text" DisplayName="Personalabteilung" UserSelectionMode="PeopleOnly" Type="User" Sealed="TRUE" ShowInDisplayForm="TRUE" ShowInEditForm="TRUE" ShowInNewForm="TRUE" ShowInListSettings="TRUE" List="UserInfo" SourceID="http://schemas.microsoft.com/sharepoint/v3" DisplaceOn ...Show All

• SQL Server Is this correct forum for SQL Server Compact Edition ( formerly Everywhere )

  Hi, I am looking for help ( at beginnners level ) in the use of the newly released / promoted SQL Server Compact Edition (what used to SSEv ). I have a single user desktop application - not PDA / mobile, which uses JET database today & I need to convert it to current databse as JET is no longer supported under Vista. I understand that it is SQL Server Compact edition. My application is native c++ with no .NET and I would like to keep it that way. Can someone point me to examples, documentation, or any help which will get me going Currently, I am connecting to the JET database using ADO and a connection string ( again ADO, not ADO.NET ). Is it just a matter of changing the connection string and making sure that the righ dlls are inclu ...Show All