Jan Ferneman's Q&A profile

• Visual Studio Express Editions BCP -SQL Server Express

  Anyone able to BCP into their SQL Server Express database   Im having some probs trying to get some data into a local server. tbh im a bit confused by the security model, especially given that its running on XP Home. I understand that by default all XP Home users are machine Admins So all users should be able to connect to the local SQL Server via Windows Authentication If I can fire up SSMS-EE and connect via windows authentication I assume that if I BCP I can use the -T to connect via a trusted connection Also, how do you reference the server, can you use 'local' or the named instance COMPUTERNAME\SQLEXPRESS or just C ...Show All

• SQL Server Decimal formatting

  Hi, we have a decimal data field and we want to format it in the correct langauge specific formatting (decimal point is a "comma" in Germany...). We tried different format strings but we always get a decimal point (really a point). Is there any way to format a decimal the way it's defined in the Windows language settings Always with 2 digits after the point (so exactly like the currency without the currency symbol) Thanks, Thomas The "Report" element has a Language property. Make sure the Language property is set to "DE-de" or e.g. to =User!Language (to run the report with the language set ...Show All

• .NET Development How can I add a please wait page while doing heavy db transactions

  I have a page that the client hits the run test button and there is an intense amount of stored procedures that run - I want to be able to redirect or display an ani gif that say's please wait with a moving hour glass so they don't keep hitting the run test button and they know something is happening - I looked around the web but couldn't find any working code... Anyone that can help would be a blessing... thanks rich I know there has to be someone out there that has sample code on this - Everything I find is so complex - I want to keep it simple... Someone please help out if you have something... thanks rich ...Show All

• SQL Server Proactive caching - Polling interval

  Hi, If a cube partition is set to custom settings in Proactive caching, and setting only rebuild interval of 1 day in General tab and in the Notifications tab if scheduled polling with incremental updates and 1 day interval is given, what does that mean Does the polling setting bring only data into molap or does it do cube processing also If there is a polling interval of 15 mins with incremental updates and rebuild interval of 1 day, does it fetch incremental data every 15 mins into molap, but will rebuild/process the cube only once a day Rgds mat It would be helpful if you explain in a bit more detils the ...Show All

• Visual Basic Blocking Pop ups when auto-delegating tasks in Outlook

  I've noticed at work that when a manager tries to delegate a task, a msg box pops up saying something like "someone is attempting to access your account...how long do you want to allow, etc." Well, I have a macro that managers will run that will automatically delegate a lot of tasks to a lot of individuals and I want to get it done with no extraneous user input. Meaning, if John is delegating a task to Mary, then Mary should not have to do anything except click the Accept button.  How can I block those pop-ups in my macro i.e. I don't want to have to go to each person's computer and change their settings. ...Show All

• Visual C++ How Can I Change The window color

  Good Day. I Want to ask you for an easy way to change the window color on C++ ..IN MFC And Thank You(Donnot give me a Link to MSDN ) What library do you use ATL, MFC, plain Win32 Here are the links to the MSDN In the MFC you can use message refelection: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vclib/html/_mfcnotes_tn062.asp In the case of Win32 API you have to react on WM_CTLCOLOR... messages. i.e. http://msdn.microsoft.com/library/default.asp url=/library/en-us/shellcc/platform/commctls/staticcontrols/staticcontrolreference/staticcontrolmessages/wm_ctlcolorstatic.asp frame=true If you have a common control ...Show All

• Windows Forms .NET 1.1 Project With File-Based Reference To A .NET 2.0 DLL Not Working

  All-- Please help I have a design that requires that a given .NET 1.1 WindowsForms client application must include a file-based reference to a DLL that was built with .NET 2.0. Unfortunately, I cannot get it to work. The VS.NET 2003 IDE will simply not let me add the reference. Ug. I have tried several tests, detailed below, but I have yet to find an answer. Can it be done If yes, then how can it be done If no, then what is the work-around What do you think Please advise. ------------------------------------------------------------------------------- Overview: In in a .NET 1 project, try adding a file-based referen ...Show All

• Windows Forms Can I change how Publish.html looks like?

  Hay! I'm new in Click Once publish and I don't know where to find any information regarding changing how publish.html looks like. I'd like to include in it my company logo and so on. Is there any tamplate on wich is based on Where can I change background color, fonts... And I don't want to change publish.html everytime I publish my app. Is there a way to make this changes only first time Thank you for your help! I think it would be great if click once generated an xml document in the deploy directory so we could build custom publish pages with the deployment details. ...Show All

• .NET Development Application won't start without Visual Studio

  In our project we made a small application which uses dll-files. The problem is that the application won't work in a computer that has not Windows Visual Studio .NET environment installed. The latest version of .NET Framework has been installed on our environments and on the target computer we are testing with. When starting up the application nothing happens, not one error message. Also, applications made in the same environment without any dll-files work fine in the target computer. Dll-files are located in the same directory that the executable file but the application doesn't seem to find them anyway. Any idea how to make our applica ...Show All

• SQL Server Help on replication from SQL 2005 to DB2/AS400

  I was trying to set up a replication process to move data from SQL 2005 to DB2/AS400. To get it started, I have create a simplest table (say, PERSON) on SQL 2005 server, and the same table (PERSON) on DB2/AS400. I have only one column SSN (of type int). I have journaled the table on DB2 end. I was able to have successfully configured publisher (on SQL 2005) and subscriber (i.e. a pushed subscription). I used transactional replication. And I also installed HIS 2004 to have DB2OLEDB ready. I was able to use query/insert/delete against table on DB2 based the linked server (that I created for testing purpose). I did a lot of reading on t ...Show All

• SQL Server Clearing Single User Mode/lock

  What is the best way to clear Single User mode from SQL Server 2000 I have tried going to all tasks and selecting detach and clear Connections using this database. I then click cancel and go into the properties and options and clear the Restrict access check box. This seems to work some times but not all the times. I think it is because something else connects to it to it while I am going through the above steps. As a last resort I have detached the database and re-attach it. What is causing the single user mode to happen in the first place I'm having the same problem... and tried to kill any co ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to create a new Texture from an existent Texture?

  How to create a new Texture from an existent Texture I have a bitmap file, first I created a Texture from a bitmap file by using function D3DXCreateTextureFromFile(). Now I want to create an another Texture from the existent Texture, and the new Texture's content is the existent one's bitmap but be rotated 15 degrees. For Example: the existent Textures have a horizontal line "-" on it's center , from the old Textures I can create another three Textures by rotating different degrees, and the another Textures looks like "\" , "|" or "/" . How to do this I only want to create a series of sequential Textures from one Texture, not to rotate ...Show All

• Windows Forms ¿Why TaskVision does NOT use DataBinding?

  ¿Why TaskVision does NOT use DataBinding I see a lot of code doing things like oneDataRow["someField"]=someTextBox.Text; I am building a big (i am in 5° Month, of about 6 months of development, and maybe more, if the client likes it and wants more) project in .NET, in Windows Forms,  and I use DataBindigs for every window, but some times i do ...Show All

• Software Development for Windows Vista Workflow Hosting

  Hi Is it possible to host workflows created from different workflow definitions in one host Just to be clear, I do not mean multiple instances created from the same definition but multiple instances created from multiple definitions I cannot find anything to suggest this is possible in the docs/book. Thanks for any help you can give on this... Clare ...Show All

• Visual Studio Team System Web Test and Username / Password

  Hello I have created a web site with Windows Authentication, allowing one specific user to have access to it, and all the other one are denied. So in web.config:         <authentication mode="Windows" />         <authorization>             <allow users="domain\username"/>             <deny users="*"/>             <deny users=" "/>         </authorization> I wanted to do some testing ...Show All