Marcus J's Q&A profile

• SQL Server ?'s about Access .mdb's <-> 64-bit SQL 2005

  Here's what I need to make happen: Our web app users need to be able to import/export data from our 64-bit SQL 2005 box to an Access .mdb exclusive to them. Legacy apps dictate we stick with .mdb files. When the [export] package is complete, the site should present the finished exported .mdb for download. This process must be able to run in parallel, since multiple users can execute at the same time. Finally, since we can't afford to buy SQL licenses just to run SSIS packages on the web servers, we have to find a way to accomodate that limitation. I have an SSIS package that handles all the file and data movement, and a web site on a separate server that calls the package. I've gotten as far as checking if the file exists through web ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Displaying Videoframes with DirectX

  I use a open source codec/video library (libavcodec). This lib exposes the video frames as 24_bit RGB bitmaps in memory. All I want to do now, is displaying those frames in a window as fast as possible. I tried a very naive approach: for ( unsigned int i = 0 ; i < Framenumber; i++ ) { Load->get_nth_frame( ID, i , RGBFrame ); DXDev->BeginScene(); Backbuffer->LockRect( &LR, NULL, 0); // [ memblit Copies RGBFrame pixelwise to Backbuffer , same function as //D3DXLoadSurfaceFromMemory ( Backbuffer, NULL, &SrcRect, RGBFrame, //D3DFMT_R8G8B8, Pitch, NULL, &SrcRect, D3DX_FILTER_NONE, 0);] memblit ( RGBFrame, (char*)LR.pBits, w, h, LR.Pitch ); Backbuffer->UnlockRect( ); DXDev->EndScene(); DXDev ...Show All

• Visual Basic find a character in string

  Hi I have a variable server = "sqlmodl2\sql_modl2" I want server2 =modl2 i.e I want to return all the characters after the _. Can anyone help me. Here are two ways to do it:         Dim server As String = "sqlmodl2\sql_modl2"         Dim server2 As String = Split(server, "_")(1)         Debug.Print(server2)         server2 = server.Substring(server.LastIndexOf("_") + 1)         Debug.Print(server2) There are probably several more ways to do it as well. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. fixed function pipeline

  i first render a mesh from x.flie,use effect systems,it's all work right now i fetch some vertices data form the mesh,use the breakpoint the data of this vertices correctly gained. CUSTOMVERTEX vertices[] = { { Apple.Trianglevector0.x, Apple.Trianglevector0.y, Apple.Trianglevector0.z, 1.0f, 0xffff0000, }, { Apple.Trianglevector1.x, Apple.Trianglevector1.y, Apple.Trianglevector1.z, 1.0f, 0xffff0000, }, { Apple.Trianglevector2.x, Apple.Trianglevector2.y, Apple.Trianglevector2.z, 1.0f, 0xffff0000, }, }; Apple.Trianglevector0 is one of point just like others Apple is a instance of mesh class, i use the follow code after render the mesh, but it doesn't display! (g_pd3dDevice->CreateVertexBuffer( 3*sizeof ...Show All

• Visual Basic how to write a loop to access all labels on a form

  I have more than 200 lables on a form. When a button on this form is clicked, I need to update the display of all these lables. How can I write a simple loop to do that Hi, the following code will loop through all controls, put directly on your form and assign a new text to all controls that are labels: Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click     For Each control As Control In Me . Controls         If TypeOf control Is Label Then             Dim myLabel As Label = DirectCast (control, Label ...Show All

• Commerce Server campaign items

  hi 4 all, if we have multilanguages commerce website. how can we specify which of the campaign items (Ads, or discounts) will display for anonymous user suppose that we have 4 languages, should we create 4 campaign items for each thanks for all. Ok, i will try to clearing up my question You know, we can target the registered user cause we have all information stored in the UserObject. but i'm not sure how we can deal with anonymous users to target them. ...Show All

• Visual Studio Express Editions Visual Studio C# Installation Problem

  Setup seems to hang every time it is started. No error messeges are returned. Under the Windows Task Manager the CPU is 96-98. I have tried installing from the internet, I have tried the manual installation, as well as, burning a cd and trying to install the product. Every time setup is ran, it hangs. I downloaded and installed .NET Framework 2.0 before running setup as well. I have looked trying to find a solution but no luck. Can you help I am running Windows XP service pack 2 and 256 RAM. No previous beta versions ever installed and I uninstalled Visual Studio 6 hoping to help with the installation. Also, I have tried installing it on 2 computers and both are having the same problem. Thanks for your help! ...Show All

• Windows Forms OnHandleCreated, IsHandleCreated: some threading issue makes me crazy :(

  I'm getting smth strange. I am overriding OnHandleCreated method on my Form, and as usual Window Handle is already created i can happily access it from the OnHandleCreated method body. but if start a new thread right away, i can not access the Window  Handle from there - at least "IsHandleCreated" returns false and Form.Invoke methods throws an exception if called from this new thread "private IntPtr handle;" is not declares as volatile, so maybe what i am getting is a threading memory synchronization issue how do flush thread caches i've tried executing some "locked" section - in Java this would reload all the data from the main memory copy, but this did not help :( what i hate about my problem - it is 50% repro ...Show All

• .NET Development How to validate an XML file

  Hi there, I'm trying to validate an ".xml" file using the following standard technique: 1) MyDataSet myDataSet = new MyDataSet(); 2) XmlReaderSettings settings = new XmlReaderSettings(); 3) settings.Schemas.Add(null, "MyDataSet.xsd"); 4) settings.ValidationType = ValidationType.Schema; 5) settings.ValidationEventHandler += new ValidationEventHandler(MyHandler); 6) XmlReader reader = XmlReader.Create("MyFile.xml", settings); 7) myDataSet.ReadXml(reader); When line 7 is executed, the handler on line 5 is not called even when I pass an ".xml" file on line 6 which doesn't conform with the schema on line 3. I've tried many variations and nothing works. Any help would be greatly appreciated. Thanks. I suggested to turn on ReportVa ...Show All

• Visual C# How to get a page source code of URL programmatically?

  From a C# routine I need to go to a URL page and download the HTML source code of that page bypassing the browser. I then intent to analyze the code and extract another URL -- but I already know how to handle it. I prever to have this page in memory, as a string variable, not as a disk file--it is intended for a very temporary usage. The challenge for me is to figure out how to have the program download the HTML code without alerting the Internet Explorer Browser. I am sure it is a simple problem for a longtimer. Hope for help. Thanks You can fetch the html page using HttpWebRequest class: HttpWebRequest request = ( HttpWebRequest ) HttpWebRequest .Create(url); using ( Stream stream = request.GetResponse().GetRespo ...Show All

• SQL Server The script threw an exception: Exception of type 'System.OutOfMemoryException' was thrown.

  Hi, I got an strange problem with one of my packages. When running the package in VisualStudio it runs properly, but if I let this package run as part of an SQL-Server Agent job, I got the message "The script threw an exception: Exception of type 'System.OutOfMemoryException' was thrown." on my log and the package ends up with an error. Both times it is exactly the same package on the same server, so I don't know how the debug or even if there is anything I need to debug Regards, Jan Hi Darren, I think I've found the cause: My package trims big csv-files and after that imports them. It seems like the buffers of the dataflow task are not deallocated while the package is runn ...Show All

• SQL Server .Net CF 2.0 Error , "Can't find PInvoke DLL 'dbnetlib.dll'."

  Hi All, I'm developing Pocket Pc application, In that i have set of statement, which establishes connection with sql Server 2000 Database. When ever I try to open SqlConnection, I’m getting error "Can't find PInvoke DLL 'dbnetlib.dll'.". Right now i am working in .Net Compact Framework 2.0 , But previously i worked in .Net CF 1.1 i didn’t face problem while doing that. Can any one help me to solve this issue   My code exactly look like :   Private SqlCmd As New SqlCommand Private SqlTrans As SqlTransaction Private SqlConn As SqlClient.SqlConnection Private SqlCmdBuilder As SqlCommandBuilder Private SqlDataAdapter As SqlDataAdapter Public Function Select_DocumentTempl ...Show All

• .NET Development Please help me! Anybody can tech me how to write a [WebMethod] that can search Database(ServerSide) and return infomation!

  Hi all, thanks for come in!! My problem is: I write a web sercive which have two method, GetFreinds and GetFriend. GetFreinds Method can return all friends infromation from database when invoke this method, I use DataSet to do this and it works!     [WebMethod]     public DataSet GetAllFriends()     {         // Step 1. Create the connection string and command string                string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + this.Server.MapPath("Friends.mdb");         string comStr = "Select * from Friends";  &nb ...Show All

• Visual C# about 'flag'

  Does anybody know what compiler flag generates XML documentation I'll appreciate for help. I think it's /checked. Check the following document for an overview of all the C# compiler options: http://msdn2.microsoft.com/en-us/library/6ds95cz0.aspx Regards, ...Show All

• Visual C# Getting an interface implementation from a type

  Hi There, I have an assembly which contains a type which I know to implement a specific interface. I can retrieve the interface from the type but whenever I try to cast the type directly to the interface (to get its implemented properties) the cast fails. Here's the code: Type plugInInterface = type.GetInterface( "IPlugIn" ); // This succeeds and I get plugInInterface back. if (plugInInterface != null ) { // Found the a type that implements the IPlugIn interface. // Load it up! IPlugIn plugInType = null ; if (type is IPlugIn ) // This fails. { plugInType = type as IPlugIn ; } } Does anyone know what I'm doing wrong here It seems that if I can successfully retrieve the ...Show All