Rune Gulbrandsen's Q&A profile

• SQL Server Need VB/VB.NET Help

  Hai Folks I Want a coding for Read the SQl Server Log Files Now I am Using SQL Server 2000 For Example: Test is a database Name... Test_Data.MDF is a Data File Name Test_Log.LDF is a Log File Name Now I Create a Table Name Check with Single Field Now I want to check this Details like I run this VB Coding then Its tell me The Last Transaction of the Test database is Create a Table Name is Check I hope You can Understand My Request... In exact Wors I want JobHistory of Some Table... If its Possible VB.NET than Please give me a Sample Code Please This is very Very Urgent................ The SQL Server log file will not give you specific actions taken in the database. The transaction log is different, and it does have a record of every ...Show All

• Microsoft ISV Community Center Forums WebPart Problem (?) / BSM2005

  Hy. We have a Win2k3-Server (SP1) with SQL2k5, IIS6, Sharepoint Services 2. To tryout the features i've installed the BSM2005-Demo. Fortunately there where no problems during the installation, but after deploying a scorecard i get the following error: hi, can you tell me please how did you solved it ... i'm having the same problem. thanks Tatiana. ...Show All

• SQL Server Connection error ( from MS Analysis to Applix TM1)

  Hi All, I am trying to connect from MS Analysis Services 2000 to Applix TM1. Applix has got Applix OLE DB MD Prodiver.It is installed on my machine. I create a datasource in MSAS. In Data Link I can see the this Applix OLE DD driver and I choose it. Then I can see Applix login and password screen. Then I logged in. When I test my connection, the connection is succeed. But when I create a cube from data source,it gets an error message as below; Connection teamnb-cem data source failed. Object or provider is not capable of performing requested operation Do you want to retry_ How can I fix it BEst Regards Cem DAGLI Cem Unfortunately, you don't make yourself clear - you just repeated the infor ...Show All

• SQL Server Stored Procedures and how to call them from C#

  Hello Everyone, I have created a stored procedure something like this : CREATE PROCEDURE [dbo].[Get_Lots] AS BEGIN SELECT _id, description FROM LOT RETURN 0 END GO I want to know what would be the return parameter in above procedure. Secondly, If I need to get the value in DataSet using C# how can I do that....If someone can provide with an example..... Thanks, Harsimrat Use the data application block from the enterprise library as your data access layer. Download it and you'll find lots of examples. http://www.microsoft.com/downloads/details.aspx FamilyId=5A14E870-406B-4F2A-B723-97BA84AE80B5&displaylang=en ...Show All

• Software Development for Windows Vista WaitForSingleObject doesn't work for Internet Explorer

  Hi, I start Internet Explorer by CreateProcess: CreateProcess(....., &procinfo) myhandle = procinfo.hProcess; After that I wait for Internet Explorer to be closed: DWORD dwait = WaitForSingleObject(myhandle, INFINITE); This code works fine on XP, but for Vista it doesn't. The WaitForSingleObject returns immediately. So, while Internet Explorer is still running. Does anybody now how to do this properly on Vista Thanks in advance. Klaas When IE 7 launches it starts up with normal permission mode (often called LUA mode) it then checks the URL and if it is not a trusted site, a new Iexplore.exe process is launched in protected mode, with restr ...Show All

• .NET Development Connecting to a Sybase db

  When running my program I get this error, I installed the Sybase client in my local machine and I can access the tables using the SQL Advantage utility in Sybase. Do I have to do anything else Message "The 'Sybase.ASEOLEDBProvider.2' provider is not registered on the local machine." String Thank you JM Hi, That would be my best guess. Since the error that you are experiencing suggests that the .Net provider for sybase is not present in the computer... cheers, Paul June A. Domag ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. texture2d problem...?

  Hi All, i'm new to XNA programming (and directx programming altogether). having a lot of fun with XNA and most things are pretty straight forward for a simpleton like me. here's a problem i'm having that i'm hoping someone can shed some light on. I'm using a lot of photos in my application (a slideshow!). I'm testing with 1 Texture2D and every few seconds loading another image into it using Texture2D.fromFile, etc... Here's what i'm experiencing - if I don't call dispose() on the texture before each new fromfile, it's a memory leak... this makes sense. the problem is that the texture seems to get confused on it's size. I'm using a mix of different sized non-square images. it's like the texture only reads the first texture size called and t ...Show All

• Visual C++ Visual Studio 2005 Service Pack 1 Beta - error C2244

  Hello, I installed SP1 Beta asap, because I am encountering the "Updating Intellisense ... 100% CPU load" problem. Intellisense problem seems to be resolved, but now I can't compile QT 4.1.4 here is compiler message: -----------------------------------------start c:\qt\4.1.4\include\qtcore\../../src/corelib/tools/qhash.h(805) : error C2244: 'QMultiHash<Key,T>::replace' : unable to match function definition to an existing declaration c:\qt\4.1.4\include\qtcore\../../src/corelib/tools/qhash.h(790) : see declaration of 'QMultiHash<Key,T>::replace' definition 'QHash<Key,T>::iterator QMultiHash<Key,T>::replace(const Key &,const T &)' existing declarations ...Show All

• Smart Device Development deploying

  Hello, how can i install sql ce and cf 2.0 when my application is installed with the same file, without the user to run diffrent cab files. thnx in advance. and how can this be done by using msi installer files is there any free software for this or is there a program implemented in vs 2005 thnx in advance. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is Function Overriding The Only Way?

  When going throught the XNA tutorials, I noticed that functions for drawing and updating are overriden. Is there an event alternative to that Create an event function rather than override XNA's There are some events on Game related to activation but Update and Draw are overrides. We chose this route due to confusion in the early (internal) versions of the framework when both overrides and events existed. People had trouble figuring out when to use an event or override. In the end, because of the confusion of "two ways" to do things, the slight performance advantage of the virtuals, and the fact that you will usually need to override both anyway, we chose virtuals. Feel free to file a bug ...Show All

• Visual Studio 2008 (Pre-release) HierarchicalDataTemplate and multiple ItemSources

  Hi I have a class structure conceptually similar to the following that I'd like to be able to display in a treeView using an ObjectDataProvider and HierarchicalDataTemplates public class MyContainer { private ObservableCollectionWithPropertyChanged<Person> m_Contributors = new ObservableCollectionWithPropertyChanged<Person>(); public ObservableCollectionWithPropertyChanged<Person> Contributors { get { return m_Contributors; } set { m_Contributors = value; } } private ObservableCollectionWithPropertyChanged<KeyQuestion> m_KeyQuestions = new ObservableCollectionWithPropertyChanged<KeyQuestion>(); public ObservableCollectionWithPropertyChanged<KeyQuestion> KeyQuestio ...Show All

• SQL Server How can I hide mssql server system database?

  Dear All, I m using mssql server 2005, when i create a user account for mssql and then use this account to login via management studio. It will show all the system databases and other client databases. How can i hide those databases and allow the client to see their own databases. Regards, Ricky Hello, In order to see who all have access to 'View Any Database' Permission, you can use the following query SELECT l . name as grantee_name , p . state_desc , p . permission_name FROM sys.server_permissions AS p JOIN sys.server_principals AS l ON p . grantee_principal_id = l . principal_id WHERE permission_name = 'VIEW ANY DATABASE' ; and to DENY access to public you can use th ...Show All

• SQL Server Create/Alter view with declare variable

  Hi all, I not sure whether is there a way to create/alter a view with variable declare in the same statement. I encounter some error when I run the below statement. Error: Server: Msg 156, Level 15, State 1, Procedure Employee_Details , Line 2 Incorrect syntax near the keyword 'DECLARE'. Server: Msg 170, Level 15, State 1, Procedure Employee_Details , Line 16 Line 16: Incorrect syntax near ')'. My SQL Statement ALTER VIEW Employee_Details as ( DECLARE @usr nvarchar(250) SET @usr = user SELECT E.ID ,E.NAME ,E.DEPARTMENT ,E.JOB_TITLE ,E.JOIN_DATE ,E.RESIGN_DATE FROM EMPLOYEE AS E WHERE E.DEPARTMENT = (SELECT * FROM GETCURRENTUSER(@usr)) ) The GetCurrentUser is a function I have create to get the department that t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GetObjectByValue in XNA?

  So, basicly I'm trying to port MDX 1.1 code to XNA . I have made quite good progress so far, but there are these lines of code, that I can't figure out how to do the same thing in XNA: MDX 1.1 int DxMagicNumber = -759872593; IntPtr unmanagedDevice = device .GetObjectByValue(DxMagicNumber); IntPtr unmanagedSurface = videoSurface.GetObjectByValue(DxMagicNumber); I tried to do some diggin and found this site: http://msdn.microsoft.com/directx/xna/migration/  - which was quite helpfull when porting the code, but I can't find anything related to this problem from that site. Is it even possible to somehow replace these lines of code with the current version of XNA I don't t ...Show All

• Visual Studio Team System Create Bug from Web Test result, assign to developer, but can see the Test Result only in XML format ???

  Hi, as a Tester role, I had create a Web Test running a Web page. the I had found a bug, create directly from Test Result. The TFS server did ask me to publish the test result to the target build. and I did ! the Team Explorer say the publish is complete !!! but when the bug owner open the bug in his Team Explorer, he try to open an text result xx.trx from the WorkItem Link Tab. the system shows, the test report is not published therefore I can only see the .trx report in XML format from attachment Tab. could anyone guild me, what am I missing I have the same issue. I checked the test results section in the build and found them; however, the developer edition of studio seems to be giving the problem. ...Show All