ryxyr's Q&A profile

• Visual FoxPro sharing connections between applications

  Pehaps I better wrote: sharing databases between applications . This is the thing. I have a VFP application which is 99% complete. Occasionally I add some embelishments or premium features. I am also in the process of developing a C# app of Winsock style. It is a console app in Visual Studio 2005. It is supposed to use some of the same ODBC VFP9 databases. I've read that VFP databases are much superiod to SQLServer databases in terms of speed. I spent a day trying to figure out why I could not open a connection while my VFP app was open all the time and those databases were linked to it. Finally, even superstupid get their break and I realized that there was nothing wrong with my connection string. I shut the VFP app down. This brings m ...Show All

• Windows Live Developer Forums Polylines opacity with Firefox

  Hi all, We are experimenting problems with alpha setting for thick polylines. With Firefox alpha parameter is ignored and the line is solid. We've already seen a report on this on the forum. Is this a known issue Is there a plan for a fix Thanks! Paolo yep. I've applied the fix. Without the fix the polyline doesn't appear at all. And yes... the problem affects both FF 1.5 and FF 2.0 Thanks again Paolo ...Show All

• SQL Server Error: Method, property or field is not static

  I've got a CLR stored proc I'm trying to deploy to SQL2005, when I try to debug it I get the error message: Method, property or field 'usp_Evaluate_eTranscript' of class 'ACS_eTranscripts.StoredProcedures' in assembly 'ACS_eTranscripts' is not static. The class & procedure are declared: Partial Public Class StoredProcedures Private Structure CalcGPA Friend intGrdTot As Integer Friend intCrsKnt As Integer End Structure <Microsoft.SqlServer.Server.SqlProcedure()> _ Public Sub usp_Evaluate_eTranscript(ByVal SSN As String) When I change the sub's declaration to: Static Sub usp_Evaluate_eTranscript(ByVal SSN As String) I get an error message that: Methods cannot be static. So, is this a Catch 22 or what ...Show All

• Visual C# C# Excel programming Question 2

  I figured I may need to create a new thread for this question... Is there any way to add fonts info to header and footer info. This is the code for Header and Footer. (Thanks to mEt) Microsoft.Office.Interop.Excel.Application excelAPP = new Microsoft.Office.Interop.Excel.ApplicationClass(); Microsoft.Office.Interop.Excel.Workbook wbk = excelAPP.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); Microsoft.Office.Interop.Excel.Worksheet myWS; myWS = (Worksheet)wbk.Worksheets[1]; myWS.PageSetup.CenterHeader = "Test Header"; myWS.PageSetup.CenterFooter = "Test Footer"; excelAPP.Visible = true ; If I am not mistaken, you should use the formatting of Excel like if it was VBA. Try t ...Show All

• Visual Studio ReportViewer language bug ...

  The dataset I created is just fine and when I preview my data everything seems ok in the sqlprofiler. But when bind tha dataset with the report viewer control and "run" it in the local processing mode in an asp.net application it does something to my dataset at runtime and change my corrupt my turkish parameters in the dataset as I look at that from the sql profiler. Does any body know a way to avoid this .....The client side reportviewer control is used with a typed dataset in vs 2005. ****the turkish characters in the dataset are changed in the runtime enviroment when used with the reportviever control. such as. exec sp_executesql N'SELECT CASES._ID, CASES._OWNERID, CASES._LASTMODIFYDATE, CASES._DEL ...Show All

• Windows Forms Hard Disk Drives Count

  Dim Fxd = IO.DriveType.Fixed For Each Fixed In My.Computer.FileSystem.Drives.Count.ToString Next is this right no that is incorrect.   What exactly do you want to do if you want to list the drive types of your system, try:   For Each curDrive as DriveInfo In My.Computer.FileSystem.Drives    If curDrive.DriveType = DriveType.Fixed Then       MessageBox.Show(curDrive.Name)    End If Next     is this what you are after ...Show All

• Visual Studio Tools for Office Adding a macro to excel using C# in asp.net

  I am creating a customized excel report for my company using a webpage. Part of the excel file is a macro to handle printing though, and I can't seem to get it to work correctly. The code works... The page building the report impersonates a user that has access to Excel. Excel files can be created but, when I attempt to add the print macro I recieve this error: Programmatic access to Visual Basic Project is not trusted The user being impersonated has the security setting in excel set to: Trust access to Visual Basic Project I discovered on accident that if the impersonated user is actually logged in on the server that the code executes as expected, every time. If you have any idea how to correct this problem please let me ...Show All

• Software Development for Windows Vista IPC on Vista

  I have an MFC application working fine on ME/2000/XP. An application has 2 parts: IE plugin and an exe file. An interprocess communication is done using WM_COPYDATA message. Starting to check it on Vista I discovered that this way of IPC doesn't work anymore: my exe doesn't get messages from my plugin. Only when my exe was elevated to a broker, it started (well, kind of) to work. The questions: 1. is SendMessage/PostMessage (specifically, WM_COPYDATA) doesn't work between different processes at all, or only between processes with a different security level 2. What is the best way to replace WM_COPYDATA 3. If it is a named pipe, can a pipe, created by application with a higher security level be accessed by application wit ...Show All

• SQL Server Can i host a SQL2005 EE DB on SQL2000 engine ?

  Hi, I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support. My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives. Thanks. hi, SQL Server 2005 databases can not be attached/managed/used by SQL Server 2000 edtions.. the internal structures and metadata are different.. you can obvioulsy upgrade a SQL Server 2000 database to SQL Server 2005, but not the contrary.. you can "handle" that scripting out the database objects (obviously only the SQL Server 2000 supported ones) cleaning out eventual 2005 features and recreate the database on the SQL Server 2000 instance running those script ...Show All

• Visual Studio Customization task deployment/reference error

  Hello, I have written a custom task on my development machine and it runs fine activated by MSBuild o my development machine. I need to have TFS activate it so I deployed it to my TFS server. I got: ... error MSB4018: The "BuildTypeInputDialog" task failed unexpectedly. ... error MSB4018: System.Security.SecurityException: That assembly does not allow partially trusted callers. I was using <UsingTasks AssemblyFile> referencing. I surmized that I needed to use strong names and the GAC, so I made that change and changed to <UsingTasks AssemblyName> referencing. Now I am getting ...error MSB4062: The "Extensions.Tasks.BuildTypeInputDialog" task could not be loaded from the assembly Extensions.Tasks. Could not l ...Show All

• Microsoft ISV Community Center Forums Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional

  This problem has been mentioned by many other users (in a different thread subject), so I wanted to start a new thread. I have tried many suggestions, but none have worked for me. My MODI has been a print option for me until just recently. It disappeared from my printers folder. I have repaired, removed, and re-installed Microsoft Office. The MODI will still not appear in the printers folder. Please Help! Mine disappeared without any software updates except for the automatic ones. I was on XPSP2 and Office 2007 and it has been there since the original installation. What make it go away ...Show All

• SQL Server SET IDENTITY_INSERT Question

  I want to use the SET IDENTITY_INSERT ON command so that I can insert a bunch of records and establish the links myself based on the ids i used. I have a table with an identity column which is a FK in another table. I need to insert into table one, then carry that id to table 2 as a fk. There is no unique value for me to tie to so I wanted to ReSeed the identity column to the number above what I am going to insert and then turn off identity insert so I can insert between the present spot and where I reseeded to. This will allow me to know the id's and assign them myslef. My question is two fold. 1. When I set Identity_Insert On does it only affect my batch, or the connection, or the whole server Essentially, when ON can other peopl ...Show All

• Windows Forms Printing a database

  I would like to print all the tables in my database in my program which holds the databases and works with them, Any suggestions Thanks Anthony I've looked at some sample code from microsoft in the msdn library, buut its for framework 1.1 and im using VS2005...not to mention they describe how to print from a stream, i dont want to open a file and print the file, i just want to print directly from my application. Liike, printing a listbox or a richtextbox for example...Although in this case it would be a DataGridView or something that is able to hold DB Information. ...Show All

• Windows Forms How to display multiple fonts within single line in custom paint event

  Hi, I have four data items (due date, title, author isbn) that I wish to display in a ownerdraw listbox and I which to display just the title in bold. I know how to do this if I put title on a line by itself, but I'm trying to mimic a book citation format: ---------------------------------------------------- Due: 1/1/2007 History of the Decline and Fall of the Roman Empire , Edward Gibbon ISBN: 12-23456-89 ----------------------------------------------------- Can someone describe how to do this Do I have to chop up the text myself I've looked at DrawString and TextRenderer. If there a function that tells me where wordwrap would occur in pixels Hi Scott Yes, you have to cho ...Show All

• Visual Studio Change property value on decorator double click

  Hi, I would like to implement the following feature: I have a text decorator on a relation, mapped on a property, which value is an enum. I want able the user to click on the text decorator, so the value is incremented. I have surcharged the OnDoucleClick() method of the TextField Class: internal class ClickableTextField : TextField { public override void OnDoubleClick( DiagramPointEventArgs e) { base .OnDoubleClick(e); // Do some code to change value of property associated with decorator } public ClickableTextField( string fieldName) : base (fieldName) { } } I have also overrided the initialisation of decorator so my class ClickableTextField is created in place ...Show All