jaomello's Q&A profile
SQL Server DataSet .xsd use / Re-use concepts?
Hi all, I've asked this question on another forum on the 2nd October 2006 and has gone unanswered to date. I'd like to discuss SQL Express DataSet controls use / re-use concepts. As I have been so busy sorting out the ins-n-outs and the dos-n-dont's of database connections n usage I haven't had a chance to focus on this issue. Let me exagerate to make my point. Lets say I have 10 forms. Each has the standard DataSet, BindingSource, TableAdapter, and BindingNavigator. Each form has the exact same general (broad scope: select * from myTable, myTable2 etc) query. My solutions explorer has 1 Dataset .xsd for each forms query: myDataset01.xsd myDataset02.xsd myDataset03.xsd .... myDataset10.xsd Is this how I should handle the ...Show All
SQL Server XML task - Validation fails
Now is this a limitation in SSIS or am I missing something. I have an XML file that needs validation. I am using the 'XML Task' control for that. The validation runs fine so long as the file is below a certain size. I am not sure what the cutoff size is but the validation runs fine if the XML file size is 60Mb. I include a few more records in my XML file to make the file size 65Mb and run ETL again and validation fails! There is not much detail in the error message other than 'Task XML Validation failed'. I dont think there should be any kind of timeout issue. The whole process takes less than a minute before failing. The issue is definately not with the new records that get added. I have verified the new file with xmlspy and it vali ...Show All
SQL Server Problem with connection
Hi! I'm having a problem with my SQL Express 2k5 server. They people who have to connect, can't connect. But I am able to connect! I can connect using with auth. and also SQL auth. I see the databases with the proper permissions and I can access them. I use MS Access 2003 to connect to the server. They other people are also trying to use Access, PHP scripts and SQL Query Ananalyzer but they all fail to connecte. Can somebody help me to troubleshoot this problem I'm not sure but I can access, so I guess remote con. is enabled. Windows 2003, but with firewall enabled or disabled it doesn't make any difference. What do you mean with 'correct instance' I give them the same data as I use, IP/name, and UN+PW. ...Show All
.NET Development Regular expression hang
Hi there, if I execute this sample code Console .WriteLine( "Start" ); Regex regularExpression = new Regex ( @"<%!( <declaration>(.|[\s])*)%>" ); regularExpression.Match( @"<%! %>Check that all declared methods can be called next to relevant statement so sure it is executed" ); Console .WriteLine( "Before hang" ); regularExpression.Match( @"<%! %>Check that all declared methods can be called next to relevant statement so sure it is executedCheck that all declared methods can be called next to relevant statement so sure it is executed" ); Console .WriteLine( "After&q ...Show All
Visual Basic New to databases in VB
I have created a database in MS Access that works quite well, but I am trying to move the application part into VB. Here is the problem that I am running into: In access: - I have a two storage tables that hold information. - I have on table that links the storage tables together using the look up wizard - I have a form that has the information from the first table in a combobox - I have a query that filters the information in the second table, it does this by looking at the information in the combobox, then finds the infomation in second table that is related to the first tabel by the table that joins them together. I have a listbox that is filled by the above query I want to do some thing similar in VB, but can't figure out how to get th ...Show All
SQL Server Standard Install gives: "Value does not fall within the expected range" after SP1 install
Win XP Pro SP2 IIS 5.1 SQL 2005 SP1 (Developer edition) VS 2005 SP1 .Net 2.0 IE7 (didn't work on IE 6 either) Latest updates from Windows update I have set up SSRS successfully on several machines. But on a new machine with standard install I have the out of the box SSRS report manager running with issues and would like to resolve them. Report Manager will serve image files from my project. But it won't render deployed reports, not even one which has no data sources. From within VS 2005 the same reports render, no problems. The same reports published to another SSRS machine render fine. The browser erorr message is "Value does no fall within the expected range". Any ideas Thanks in advance. After 6+ hours ...Show All
.NET Development Interview question on aspnet_wp
Hi generally when a DLL is being used by any process we are not allowed to delete it , we get an error "The file is currently in use" when aspnet_wp loads my web apps assembly then will I be able to delete that assembly if yes then how does this becomes possible It uses shadow copying, so essentially it copies the DLLs from somewhere else and loads them from there. See http://blogs.msdn.com/junfeng/archive/2004/02/09/69919.aspx for more detail. ...Show All
SQL Server Can MSDE 2000 upgrade to SQL Server 2005 Standard Edition directly?
According to this http://msdn2.microsoft.com/en-us/library/ms143393(d=robot).aspx , it seems that it cannot. But is this a complete chart Thanks for any help, Peter Hi Glenn, I have just tried it and it is blocked by upgrade rules. I'm speculating that the sql server 2005 in sbs is not really standard edition but workgroup edition. Peter ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Framerate jumps once per second
I recently noticed a strange behaviour of my application: about once a second I got a jump of my framerate. I investigated the problem and ended up with an empty WindowsGame application. I used the PIX Tool to look at the framerates and durations of every frame. And no matter what I tried the behaviour was always clearly noticeable. About once a second the framerate first dropped for one frame and was significantly higher (above average) in the next frame, like it made up for the lost time in the first frame. The problem is less noticable in full screen and when MultiSampling is set to false. It is also less noticable if the RefreshRate is set to 60 Hz. But it is always there. Is there an explanation for this behaviour I noticed it in one ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Forms and Directx9 is possible?
Hi, How do I create a window with windows forms to show it pictures with directx, and instance this window in groupbox, what i go show using directx are vectors, if someone know how i do it, help me! If have a example too, give me. Thanks... When you create your DirectX device you can pass in a HWnd (Form.Handle) which will mean that DirectX can draw to that control. To draw Vectors you can use the D3DX line class or create a vertex buffer and use a primitive type of line. You can search for all of these in the SDK help file. ...Show All
SQL Server How can i find the default values for a Stored Procedure parameter
I have a stored procedure, CREATE PROCEDURE [dbo] . [SReport] ( @ListByBatch BIT , @UnPrintedOnly BIT = 1 ) AS ............................ ........ I can find the information regarding parameters of this Stored Procedure from " syscolumns" or " Information_Schema.Parameters" system tables. These tables provides information about parametername, datatype ...etc. But dont provide information about default values for these parameters. Here i have assigned a value, Does SQL Server stores this value Does SQL Server maintains information about Default Values for Parameter (For tables it maintains the default value for a column). Is there any way , i can find All pa ...Show All
Visual Studio Express Editions sorry about this!
ok, i'm going to appoligise profusly...because this question isn't about VBE at all...its about php, but no other forums replied to my posts..and i know how awesome you guys are (i'm looking at you tall man and you too armdiliyas(sp )) so please forgive me and take pity on me! my website is frameset based, and once i made a login script i figured out that i can't actualy make it go to the right target (i.e. main ect.) heres a peice of code that needs it done: echo "[<a href=\"admin/admin.php\">Admin Center[/url]] "; and i want it to load that into the frameset named "feature". thanks in advance, and any help is appreciated! yeh - these forums are for the Microsoft platform us ...Show All
.NET Development Find DataRow in DataRowCollection
Hi all! I have a problem that the IndexOf of DataTable.Rows does not find the row. It seems the link is broken one time, here is the summary of important lines of code: DataTable preparedSource = new DataView (dataSource, FilterExpression, SortExpression, DataViewRowState .CurrentRows).ToTable(); ... DataRow [] selectedRows = preparedSource.Select(SelectExpression); ... DataTable group = new DataView (preparedSource, ... ).ToTable(grpName); Now, if I take one of the selectedRows and try the group.Rows.IndexOf(DataRow), it returns false even if that row is in the table. Does any of the methods above duplicate the items instead of working with references How to solve this with minimal changes to code Th ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Parameters for content processor
Is there currently any way of providing parameters to the content pipeline For instance, if I had a huge terrain that I want to convert into blocks within the pipeline, it would be nice to set a parameter for the block size within the IDE's properties panel for the asset, alongside the ContentImporter/ContentProcessor settings. If not I guess I'm going to have to create an XML file to describe the terrain, and import that instead. Not half as nice. No, there is no way to pass parameters currently. That's why the default pipeline ships with three different texture converters, who each only differ very slightly in implementation. I've filed this as a feature request in Connect; I suggest you do the same. ...Show All
SQL Server Unicode characters stored incorrectly in SQL 2005
I have SQL 2005 installed as back-end for MCMS 2002 , when storing a unicode content like Arabic , and query it direclty from SQL it appears like كيف الحال The english text stored correctly and can be read. Note that same senario with SQL 2000 the unicode data cane be viewed correctly. Regards Does this affect operation of MCMS or not " actually the content appears correctly on the web page. the types in 2000 and 2005 are the same as following: (< NodeId , int ,> ,< PlaceholderId , int ,> ,< Id , int ,> ,< PropName , nvarchar ( 100 ),> ,< IsResource , tinyint ,& ...Show All