Filreis's Q&A profile

• SQL Server Connection between 2 databases in local sql server

  Hi, I have two different applications based on SQL server database. In one of the applications I need to use the information stored in the second database, only for read purpose. As I understand I need how some to make a link between the databases in order to share tables. Can anybody advise me how to do that, if it is possible at all Thanks Something like: Create Proc MyProcedure AS sel ...Show All

• Visual Basic Trouble with IFonts

  I'm trying to change the default font that DirectDraw7 sets to my Back Buffer Surface (ddsB) to 18pt Tempus Sans, but the following code produces the error "Object reference not set to an instance of an object.". Can anyone help Dim myFont As IFont myFont.put_Name( "Tempus Sans MS" ) myFont.put_Size(18) ddsB.SetFont(myFont) PLEASE PLEASE PLEASE!!! Someone reply!!! I'll give you a free copy of the ...Show All

• Visual Studio Team System Working folder already in use by another workspace on this computer

  I am getting this message on a computer on which there are no other workspaces for that computer. In addition, all of the working folders have been deleted for the workspace that I am working in. We do occasionally log into that box with another user name, but there were no workspaces defined under that login either. (Besides, can't we see all the known workspaces if you log into TFS as admin anyway -- BTW: I don't particularly like that "f ...Show All

• Visual Basic Sending e-mail from Vis Basic

  I know how to send an e-mail from VB based on results of an excel spreadsheet operation.  Is there a way to delay sending the e-mail.  I want to use it as a follow-up tool for sales leads. Another way you can do it is to calculate the date now minus the date on the excel sheet. Assume that sDate , which i set to 07/21/2005, is the date from the cell in your excel sheet. Dim sDate As Date = "07/21/2005" Dim Diff As Int ...Show All

• Windows Forms Improperly Formatted

  I am using Visual Studio 2005 Beta 2 and I am having trouble deploying my application. I receive a 'Application Failed: Unable to continue.  The application is improperly formatted. Please contact the application publisher."  I used to not have a problem with this. Does anyone have any solutions   Thanks in advance. nate. The error you see usually means there is something wrong with your manif ...Show All

• SQL Server Is pts9.msi on the September CTP?

  I don't have a redist\Analysis Services directory on the Sept CTP.  Any suggestions It wasn't included on the Sept CTP:     http://support.microsoft.com/kb/905786 You'll find a link in there to download the file. ...Show All

• SQL Server Ad hoc reporting with SSRS 2000?

  Does anyone know if SQL Server Reporting Services is capable of any ad hoc reporting Thanks!! ...Show All

• Visual Studio Express Editions Windows Control Component reference?

  Howdy Folks, I'm trying to learn C++ and how to use Visual C++ Express. I've been digging around looking for a reference for the control components located in the Toolbox, but I can't find it. I'm sure it has to be around somewhere. Could someone point me in the right direction Mark I usually use google to find information about specific classes in .NET Try searching for " maskedtextbox class ...Show All

• SQL Server 2005 Query help

  Please help. On sql 2000 i have a query like this where the columns are primary keys. Select count(*) from db.dbo.table1 where convert(varchar(3), col1) + convert(varchar(10), col2) not in (select convert(varchar(3), col1) + convert(varchar(10), col2) from db.dbo.table2) It completes in 1 second with sql 2000. I have restored the db to sql 2005 and run the same query. The processors peg and it goes to la la land. I have updat ...Show All

• SQL Server MSDE distribution - old version

  Now that slq2005 is out can we still distribute MSDE 8.0 or do we have to move up to 9.0 sql express Please include links on subject if you happen to have them. Thanks, Dave Probably get more answers over in the setup & upgrade forum: MSDN Forums SQL Server SQL Server Setup & Upgrade Joe ...Show All

• Visual Studio Team Build and NDoc?

  I have plugged in Microsoft.Sdc.Tasks.dll to my TeamBuildType to try and make use of the NDoc task. I am also refererring to the sdc tutorial documentation which shows you how to do it, however I am having trouble defining in my tssbuild.proj a folder where I can copy all my freshly built assemblies to (NDoc can only target a single folder). I'm not exactly sure how I can define my own <ItemGroup> sections in tfsbuild.proj s ...Show All

• Windows Forms Multi-threading problem with Windows Forms (possibly SerialPort too)

  I've been having a problem when updating a windows form from a different thread. Data is received on using a SerialPort class which fires the DataReceived event (on a different thread). This thread then calls a method on a form which updates a text box. The code used in the method is just like the sample from the MSDN below, which reroutes the call so that the textbox update is done from the same thread. private void SetText(string text ...Show All

• .NET Development Troubles Updating my DataBase, using dataadapter

  Can anyone please help me. I trying to update my database. I'm using Access 2003, and Visual Basic.NET 2003. This is the code i'm using. //////////////////////////////////// passval = txtconfirm.Text         idval = txtid.Text         MsgBox(passval & " " & idval)         Try          &nbs ...Show All

• Visual Studio Team System Error Publishing Test Result

  Hello, I have Team Build installed and the builds are working fine.  However, when ever we try to publish a test result to the build we always get the following error: Status: Failed Error Message: Publish operation failed. What does that mean   How can I fix it   I can't seem to locate any logs or items in the event log. Thanks, Cindy The root cause of the failure you were seeing is the fact ...Show All

• Windows Forms How To Bind Data To : DataGridViewCheckBoxColumn

  Hi All, This is the code sample , but it's doesn't work ! I have 3 smallint columns in the database that include values of ( 0 OR 1). 1. populate data to the dataset  ! string strQuery = "SELECT col1,col2,col3 FROM tbl1; orclDa = new OracleDataAdapter (strQuery, strOrclConn); OracleCommandBuilder orclCmdB = new OracleCommandBuilder (orclDa); orclDa.Fill(orclDs, "tbl1"); dgv.DataSource = orclDs.Tables["tbl1"]; 2 ...Show All