D French's Q&A profile

• SQL Server login failed for 'user' (Application Role)

  I've created a database in SQL Express and I have a Windows form attempting to connect to it through SQL Authentication. Connection string: private string connString = @"Data Source=.\sqlexpress;Initial Catalog=SQLTestDatabase;User ID=SearchAppRole; Password=password;" ; The role I have added to the database is an Application Role. It has been added to the Database permissions with Grant checked for "Select" and "Authenticate". If I test this with query analyzer, it returns expected results (if I remove Grant from 'Select', it fails) sp_setapprole 'SearchAppRole', 'password' select * from recipe If I edit my connection string (for testing purposes) to use the sa account, the applicati ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Shader to Mimic BasicEffect Textures

  Just in case I am overlooking the obvious, is there an easy way of getting the textures that are linked to a mesh   BasicEffect somehow knows which textures are for which part of the mesh, is this behaviour easy to mimic in a user definded shader   I have per pixel lighting with specular/diffuse working great, I just need this last peice of the jigsaw. Any help is much appreciated. You have several options here: - If you import your mesh from a .X file that directly references your custom effect, that effect and all its textures will be automatically pulled through into the runtime, just like we do for BasicEffect. - If you write a custom pipeline processor, you can derive from the ...Show All

• Windows Forms FormClosingEvent has no CloseReason

  In a Form I created, I've subscribed to the FormClosingEvent. In this event I want to distinguish between a user that closes the form, or an outside OS event that closes the application. Therefor I read the CloseReason member of the FormClosingEventArgs. However it seems that when the user clicks on the OK button which is the Forms AcceptButton, the CloseReason seems to be set to "None". The same goes for the form's CancelButton. Is this intended behaviour, and if not, should this not be documented When you handle the user clicking a close button that you have created on your form, you probably handle the application close with your own user code with a "this.Close();&quo ...Show All

• Software Development for Windows Vista R

  Hi there. Yesterday I have installed Vista rc2 (b. 5744) and I tried to install Alcohol 120 Software (virtual cd-rom emulation and creation). Installation seemed fine but after I restarted my system and logged on I had a serious problem - after a few second the screen started somehow "flashing" in blue and black (NOT the classic blue screen). The system did not react and after a few seconds of this flashing it restarted. This repeated a few times. Then I tried to run the system in Safe Mode but in this it did not even started, the error blue screen apperared for a second and the system restarted again. Finally I somehow found some memory repairing tool and after running this the system works OK. I hope this helps you to mak ...Show All

• SQL Server Parent ID in a Slowly Changing Dimension

  Hi There, Just wondering if any of you implemented a (Kimball type 2) dimension structure, in which a ParentID column exists which points to a record from the same dimension table, using a SCD objects in SSIS. The ParentID column would have to be "Historical". The challange here is that you would need to go through the table twice somehow, because if I would do a lookup of the parent record in the first run, I wouldn't be sure if I got the right parent record. Thnx, Jeroen. Jeroen Alblas wrote: Hi There, Just wondering if any of you implemented a (Kimball type 2) dimension structure, in which a ParentID column exists which points to a record from the same dimension table, u ...Show All

• Software Development for Windows Vista Image distortion using my native screen capture tool.

  I ever wrote a simple screen capture tool in WinXP. It worked well, but as I used it in Vista beta2, the captured images were not correct at all. I also tried PRINT SCREEN key and Magnifier tool, and the result was the same. Forgot the link of the image I get by using PRINT SCREEN key. My display card is GeForce 6200. Can anyone shed a light on it Thanks. http://us.f2.yahoofs.com/bc/4008e591_15418/bc/My+Documents/desktop.jpg bf5UtmEBg.AzJtiC I have updated the driver from NVidia website (Vista specific X86) and applied the UART updates for NVidia from the Windows Updates, via Windows Ultimate Extras. This has not made any difference. I have noticed that if I turn glass off, all is sweet. ...Show All

• Visual C++ Return value incorrect

  Hi, I've got a very weird thing in my program, const bool getRunning() const { Lock(); bool t = m_bRunning; Unlock(); return t;} Where m_bRunning == true; it returns false. ( lock and unlock handles the thread safety ) after the Unlock(), t contains true. but the return value is always false. even weirder, with code optimalisation on, the function isnt even reachable. it just skips it. //DEBUG 0041B5FE call Gameye::CApplicationInfo::getRunning (411677h) 0041B603 movzx ecx,al 0041B606 cmp ecx,1 ECX contains 205 after this. Please can anyone tell me whats going on 205 value looks like an uninitialized value to me. Are you really sure that m_bRunning is initial ...Show All

• .NET Development Is there a way to load the assembly ahead of time?

  I am aware of the many Load/LoadFile/LoadFrom/etc calls the Assembly class offers to load assemblies for the purpose of reflection (accessing types, etc). My question is if it's possible to load the assembly explicitly from code so that when the first reference to the assembly is found, the CLR won't need to load it as it is already in memory. For example, if one needed assembly (dll) sits in a different location (not where the .exe is)... Thanks. You can sign your assemblies and make in your exe.config file a probing path which probes in ..\foo also. This way an Assembly.Load will succeed regardless in what directory the other assembly is located. Keep in mind that you can create probing paths w ...Show All

• Visual Studio Team System Nice tool but small annoyances

  Almost beats Subversion but merging tool needs one small detail - when you have two upper windows with original and new source code and you scroll one of the windows left or down - Subversion automatically scrolls the another. That's very useful. If TFS team will fix this small thing - Team System will tie again vs Subversion... Thanks for the feedback. You might try a 3rd-party merge tool: http://blogs.msdn.com/jmanning/articles/535573.aspx ...Show All

• Visual Studio Express Editions Form.TomMost Property didn't work correctly on visual Basic 2005

  Hi every body in visual basic 2005 ,the form.TopMost Property didn't work correctly in visula basic 2005. I set TopMost property to ture,but my form lost focus when user clicks on another form. I Need this information to complete my job. I have a few items which are always on top (ObjectDock, for example), which sometimes disappear to the background. Usually I have to 'reset' it to be back on top. It doesn't use the .NET framework, so I guess the issue is that always on top is unreliable. I believe that there are probably some applications which use the always on top mechanism to bring a form to the foreground, which messes up forms which truly need to be always on top. I guess you can simply ...Show All

• SQL Server Simple summation

  Dear all, I am attempting to do a simple summation statistics calculation with T-SQL to count rows based on an int column FK relationship to another table. I have two tables: (1) document, and (2) filespec. Both tables have an int primary key column and some miscellaneous columns. Filespec has an int field which is keyed to the primary key of document (FK constraint), thus, each document can have zero-to-many file specifications. Example: Document Table: DocID Name 1 Approved Plan 2 Photo Gallery Filespec Table: FileID DocumentID Name 1 2 First Photo 2 2 Second Photo Expected Result: DocID FileCount 1 0 2 2 How to generate this result Thanks in advance for advice. ...Show All

• SQL Server From MySQL to MSSQL 2005

  Hello! I'm installing the MSSQL 2005. And i want to transfrom the DB from my old MySQL DataBase to new MSSQL Database. How can I do this With Import|Export Utils I can't do this task =( Pleasure Help me. Thanks That is a good idea, but it still leaves a big problem.  After you have the structure built, you still have to create a separate data reader with a sql statement for every table in the database.  When you have hundreds of tables, it presents a time challenge.  And on top of that, DTS can handle implicit data conversions (like boolean to bit), and SSIS requires explicit conversions for each of these data type changes. That's why the SQL 2000 DTS Import is still superior, where you c ...Show All

• Visual C# getting rid of autogenerated datasources

  I used the Add Data Sources wizard and added some controls to my form. This resulted in datasets & bindingsources being added. I would now like to remove that data source. How can I achieve this I have deleted the autogenerated datasets, bindingsource & tableadaptor. But the datasource still remains in my Data Sources Tab as well as the .xsd file, etc. I don't see any Remove Data Source option... Thanks for any help. Hi, when you add new data source, it gets added to your project. Open Solution Explorer and expand your project's Properties node. There's a DataSources folder; you'll find your data source references there. If you don't need them any more, it's safe to delete them. Andrej ...Show All

• Visual Studio MissingMethodException in LocalReport.Render()

  Without warning I started getting an exception while rendering LocalReports in a production environment: System.MissingMethodException: Method not found: 'Void Microsoft.Reporting.PreviewItemContext.SetPath(System.String, System.String, Microsoft.Reporting.DefinitionSource, System.Reflection.Assembly)'. at Microsoft.Reporting.WebForms.LocalReport.CreateItemContext() at Microsoft.Reporting.WebForms.LocalReport.CompileReport() at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) at Microsoft.Reporting.WebForms.LocalReport.Render(String format, String deviceInfo, CreateStreamCallback createS ...Show All

• Visual Studio Export to PDF-WITH SaveAs Dialog box

  Hi all, I've posted this before, but I am having a really rough time with this. In VB 6 I was able to bypass the crViewer and export the report to PDF WITH the dialog box prompting the user for the name of the file as well as where to save it. Just like when exporting from the report viewer-you give the report a name and then select the directory you want to save it to. I have a C# program and for the life of me, I can't figure out to to get that dialog box to appear. I can export the report programatically by providing the file name and location, but I need to be able to have the user enter the file name and then be able to select where to save it. Here is my code and any ideas would be greatly appreciated.. Thank you!! string ex ...Show All