Bert Lefever's Q&A profile

• SQL Server NULL values returned when reading values from a text file using Data Reader.

  I have a DTSX package which reads values from a fixed-length text file using a data reader and writes some of the column values from the file to an Oracle table. We have used this DTSX several times without incident but recently the process started inserting NULL values for some of the columns when there was a valid value in the source file. If we extract some of the rows from the source file into a smaller file (i.e 10 rows which incorrectly returned NULLs) and run them through the same package they write the correct values to the table, but running the complete file again results in the NULL values error. As well, if we rerun the same file multiple times the incidence of NULL values varies slightly and does not always seem to impact the ...Show All

• SQL Server Totals and Calculated members bug in SSAS 2005 (CTP3, SP2)

  I have created two calculated members in the Adventure Works cube: ---------------------------------------------- CREATE MEMBER CURRENTCUBE .[MEASURES].[ParallelPeriodSalesAggregate] AS Aggregate ( ParallelPeriod ([Date].[Calendar].[Calendar Year],1,[Date].[Calendar]), [Measures].[Internet Sales Amount]), FORMAT_STRING = "### ### ### ###" , NON_EMPTY_BEHAVIOR = { [Internet Sales Amount] }, VISIBLE = 1 ; CREATE MEMBER CURRENTCUBE .[MEASURES].[ParallelPeriodSalesSum] AS SUM ( ParallelPeriod ([Date].[Calendar].[Calendar Year],1,[Date].[Calendar]), [Measures].[Internet Sales Amount]), FORMAT_STRING = "### ### ### ###" , NON_EMPTY_BEHAVIOR = { [Internet Sales Amount] }, VISIBLE = 1 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to use LockFlags.Discard and LockFlags.NoOverWrite?

  Hi, I'm trying to mix the usage of Discard and NoOverWrite to batch my vertexbuffer updates. I start out by locking chunks of the buffer with NoOverWrite and then release the lock and render with DrawIndexedPrimitives when the chunk is full. When I reach the end of the buffer it's locked once with Discard from the beginning and then back to NoOverWrite. The weird thing is that it only draws the first vertices up to chunksize . The exact same method works well for pointsprites though. Thanx for any help. Ok, now I'm feeling stupid. I got it to work after switching the parameters of the DrawIndexedPrimitives call. I thought you should give the offset to draw from as the baseVertex parameter and but it turned ...Show All

• Visual Studio Express Editions Strange Problem - Unable to use buttons during Sound play

  My application is calling a subroutine which plays morse code: Private Sub Button2_Cli ck( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Button2.Enabled = False 'disable play button Button3.Enabled = True 'enable stop button For Each y In strLesson If Not running Then Exit For wavchr(y.ToString()) Next end sub Private Sub Button3_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Button2.Enabled = True 'enable play button Button3.Enabled = False 'disable stop button end sub Sub wavchr( ByVal y As String ) Select Case y.ToLower Case "a" ' ...Show All

• SQL Server Encryption related overflow?

  Recently restored a SQL 2000 database to a SQL 2005 Server. The database contains a series of user stored procs (one calls upto 5 other sps) which are all encrypted using 'WITH ENCRYPTION' clause. When run on SQL 2000 Server this runs without error. When run on SQL 2005 Server it reports an error: Msg 565, Level 18, State 1, Procedure SPDM_MP1_SOURCE59, Line 5143 A stack overflow occurred in the server while compiling the query. Please simplify the query. Investigating the error line reported does not reveal any problems with the sp and the error line number reported is not always consistent. However, altering the stored procs so they are not encrypted and it all runs without error. Is there a compatibility issue running SPs e ...Show All

• SQL Server Default values for datetime parameters

  Hi all, I have a report that needs a to-date and a from-date as input. I would like them to be set to today by default. I have set the data type for both parameters to DateTime and the default value as "Non-queried" = Today() This does fill in the dates with today, but I cannot change the value in the fields, until the report has been generated once. I just want the date to be equal to today since 90% of the time that is what my users wants to see - but I want to give the last 10% the chance to change the date without having to generate the report first. The date-fields are locked until some of the other parameters are filled in... It makes no sense really. Hope you can help me here :-D -- Heidi, Denmark ...Show All

• Visual Studio 2008 (Pre-release) Slow Render Performance (2000+ UIElements)

  I’m creating a Grid that is 35x35, each cell containing a ContentControl with a ContentTemplate defining a TextBlock inside a Border. It is necessary for the entire grid to be rendered at one time. Perhaps obviously, there is a noticeable delay after my code ends (building the grid dynamically) and when the grid displays on the screen. (based on Timers and a Debug.Write) The delay also seems to occur when I’m building the grid for printing and its not actually rendered. I would guess I’ve reached a limitation of WPF, but is there something I can do to minimize this delay Thanks for suggestions. ----- Code --- <Style x:Key="DefaultCellBox" TargetType="{x:Type ContentControl}"> <Se ...Show All

• Visual Studio Team System Collation conflicts in CTP6

  I am am taking a SQL 2000 DB as the source for my SQL 2005 project with a SQL 2005 Developer Edition 9.0 for a target database. After the schema is imported to project I am getting a collation conflict, I then try to change the collation in project settings to the collation that is mis matching. This gets rid of the error so I am able to deploy but then after the deploy and a compare back to the database the schema was pulled from the collations are different. These errors were not occuring when I was using CTP5, but I was using SQL 2000 for CTP5. Are there settings I have to change or select, it seems it wants to change my collation when going from SQL 2000 to a 2005 project. Can you tell me the collation ...Show All

• SQL Server Database access by machines running SQL Servers 2005 32-bit and 64-bit

  Hello We have 1 machine running SQL Server 2005 x64 (64 bit). The other machine is backing this SQL Server up. It is a 32-bit machine, so it requires ( ) a 32-bit version of SQL Server 2005. Would this back-up machine work correctly on a database previously managed by a 64-bit machine and vice versa. Thank you! If my DEV box is 32 bit and my PROD box is 64 bit: can I deploy (or migrate) from DEV to PROD. The DEV box would have the 32bit SQL Server and the PROD would have the 64 bit SQL server. But if I deploy what I wrote and created there on 32 bit will it run on the 64 bit CLR stored procedures Regular Assemblies Database triggers... and all other DATABASE funcitonality O ...Show All

• Visual Studio Express Editions upgrade from express to vs .net 2005

  hey guys. just wondering if my express projects will work in vb .net 2005 thanks Yep, just install VS on your machine and continue using your express projects with all the additional IDE features etc. provided by visual studio. Absolutely no difference for you express projects. ...Show All

• Visual Studio Express Editions Real Time Display

  Anyone knows how to implement a real time, time on a label in VB.Net 2005 (ASP.Net 2.0) My thought here is VB Express doesnt allow creation of web pages, thats visual web developer or other VB/VS products If would also recommend using the ASP.NET forums at forums.asp.net This is really there domain and they should be able to help assist you in getting a realtime label working. ...Show All

• .NET Development Quick way of determining a date from a string?

  Hi all, I have a .NET 1.1 application that needs to be able to very quickly determine if a string is a date. I can not use Exception handling here (i.e. as you would using DateTime.Parse) as it is expensive and there is only a 1% chance that the string will be a date with potentially tens of thousands of strings being checked. Do you guys have any suggestions Regards, Stephen. Unfortunately upgrading isn't an option. Also, we found that getting into regular expressions has been too complicated so we are taking a completely different approach now that doesn't involve checking dates. Thanks for the help though people. It has been much appreciated! Regards, Stephen. ...Show All

• Windows Forms Dataview filter on Double data type fails

  We have a DataTable with a column of type Double. We create a DataView based on the DataTable and specify a filter string like: "[ColumnName] = 15.03". The resulting DataView does not contain the row for which the column value is known to exist. We suspect type conversion is causing the problem, as the filter works correctly if the column is of type Single. We require double precision columns, so how do we work around this filter problem Thanks. ...Show All

• Visual Studio Tools for Office Unistalling VSTO "v3"

  Hi Everyone!!! I was using a Vsto "v3" ctp, with the release of .NET 3.0 I uninstall all and install the rtm, but i forgot the vsto, I tried to uninstall it now and it tells me the I need th February CTP of the WinFx Components to uninstall it, some can help me To fool VSTO 'v3' to install with another version of wfx you had to add a registry item to make it work. Maybe if you remove it your uninstall is fooled to make it work too This was the 'add' post. Add [HKEY_LOCAL_MACHINE\Software\Microsoft\WinFX RunTime\3.0\Setup\Indigo] "InstallSuccess"=dword:00000001 to your registry and VSTO 'v3' June CTP will install! In your case add would be remove Try at your own risk - disclaimer stuff i ...Show All

• SQL Server DTS to VB

  Can someone help me please. I am having issues with the following code. This is the first time I am doing this, so it is Brand new to me. Sorry if I look and sound like an idiot. I am having issues with 'DTS.OleDBProperties' cannot be indexed because it has no default property at the following line :oConnection.ConnectionProperties I used DTS wizard to create my vb code and I am following this page: http://msdn2.microsoft.com/en-us/library/aa176248(SQL.80).aspx Can someone please guide me in the right direction. Option Explicit Public goPackageOld As New DTS.Package Public goPackage As DTS.Package2 Private Sub Main() set goPackage = goPackageOld goPackage.Name = "Test" goPackage.Description = "Casier" ...Show All