Urs Eichmann's Q&A profile

• SQL Server remote connection to sql server express

  I have installed SQL server 2005 express on my main server. It has been installed with windows authentication. I can use sqlcmd -S machinename\instancename to connect to the server, but when I try to connect from another machine on my lan, I get the error about user not part of trusted sql connection msg 18452 level 14 state 1 I have tried using a windows username and password from my server to access it but that fails also. Any help would be appreciated Hi, I don’t know if you specified the Windows username and password , because you can’t specify this within SQLCMD; if you use Username and ...Show All

• Visual Basic Where can I find real looking playing cards

  I asked this question once before and was directed to the Blackjack starter kit. The problem with those cards is they don't look real. Is there anywhere else I can obtain images of playing cards (hopefully free) to use in making my own card game Deborah, That worked well. The only thing I had to tweak was adding the "New" to the first line: Dim myCards as New Cards Me.Picturebox1.Image = myCards.Card (23) Thank you! ...Show All

• Visual Studio Sample Apps. Is Crystal Reports the way to go?

  My company is writing a large crm application. Within this application there are 100's of standard prints that need to be produced e.g. Sales Order, Delivery Note etc. We will also be developing our own report writer something like the design time interface for crystal reports with limitations on which fields can be added to reports. Can anybody lead me to some good sample apps that use crystal reports to achieve this Is crystal reports the way to go with this If anyone has any other apps they think are easier to develop with please reply. Hi. If you have not received a response to thi ...Show All

• .NET Development Mutex and ManualResetEvent

  Hi all, What are the differences between ManualResetEvent class and Mutex class Thanks, Suresh. Ah, right. Sorry. :) I'm not sure why you can't create a named event in .NET since even Win95 supports named events, but you could either extend WaitHandle with your own class to P/Invoke CreateEvent or use different named Mutex instances. It's a stretch of the Mutex class but should still yield the results you're looking for. ...Show All

• Visual Basic hyperlinking in windows form?

  hi i have upgraded from visual basic 6.0 to 2005 and although i didnt really know all the ins and outs of the old one i wanted the new one because it has more features and you can generally make things easier (for me it is anyways) one problem i cant find out is how to make a hyperlink on a LinkLabel.. can anyone please help me figure this one out thanks Just add a LinkLabel to your form and double-click it to create a LinkClicked event handler. You then enter the code that you want executed when the user clicks the link. ...Show All

• Visual Studio Express Editions Why am i not been asked to activate the Express Editions?

  I downlaoded the offline versions (the CD images and full installs). I registered, which i assume is optional (to get the books, icons etc), but there seems to be nothing asking me to activate. Is this because i downloaded the full CD images Cheers. Hi! Same here, I also installed from the images. I registered, but there was no Key inside the e-mail and I also didn't find any place where a Key should be entered. Greetings, Uwe ...Show All

• Visual Basic Can't create new Tables, Views or Stored Procs from Server Explorer

  When I right-click on the Table node under Data Connections in Visual Studio 2003's Server Explorer I don't get the New Table node in the pop-up menu (XP SP2 and MSDE). This doesn't appear to be a database permissions issue as I can access the same database and create tables from the same security context using alternative tools (osql, SqlClient.SqlCommand, Enterprise Manager). Nor does it appear to be related to the version of Visual Studio as an installation of the same version of VS.NET on W2k/SQLServer works fine. Is the "New Table" Server Explorer pop-up blocked by XP SP2 or something wierd ...Show All

• SQL Server Error creating view from DB2 Linked Server if table has large number of rows.

  I have successfully created a linked server entry for a DB2 server via Microsofts Microsoft OLE DB Provider for DB2. I am also able to create a view based on a table that has 100's of rows. I am UNAble to create a view based on a db2 table that has 1000's of rows. I get the following timeout type of error. First a " Timeout Expired " error, then this: TITLE: Microsoft SQL Server Management Studio ------------------------------ User canceled out of save dialog (MS Visual Database Tools) ------------------------------ BUTTONS: OK ------------------------------ I am able to do a select and retrieve the entire ...Show All

• Visual Studio 2008 (Pre-release) Host a WCF Service in WAS

  Is it possible to host services in WAS in XP SP2 I've installed Win FX for XP on my m/c. Pls let me know the details of any specific component that need to be installed for this. and a sample WCF code that is hosted in WAS. Thanks in advance WAS is only available on Vista. http://hyperthink.net/blog/PermaLink,guid,e74cfea2-cc84-49dc-b047-b11d3402a94c.aspx Thanks! Scott ...Show All

• Visual Basic How do I solve this error ?

     Dim WithEvents oXL As Excel.Application     Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click         oXL = New Excel.Application()         oXL.Visible = True         oXL.UserControl = True     End Sub          Press F5 to build and to run the program.   After Form1 loads, click Button1. Notice that you receive the error message on the following line:  oXL = New Excel.Application()//error ...Show All

• Software Development for Windows Vista Whats the differente with biztalk 2006?

  Thanks Biztalk is designed to move messages from one place to another. It does this realibly etc... In a standard biztalk process (unless you have an orchastraion - which is basiclly the same thing as wwf)  there are no  execution phases -  A message enters the system from an Import port and imdeiatlly flows thru to the appropriate output ports. WWF on the other hand is a execution engine. For example - once the message arrives at the output port what happens to it. For example what does the person deailing with it have to do before it can be sent for fullfilment etc.. You used to be able sort of to do thesew things wit ...Show All

• .NET Development Folder Compression

  Is there a way to set the attribute's of a folder to enable compression for a given folder and its sub folders and files within VB .net. Thank you, Ken ...Show All

• SQL Server RS2005 Crashed After Editing and Restoring Config Files

  Dear Anyone, Here's what happened. We backed up the web.config and the rsreportserver.config. We messed around with it trying to make an assumption worked. When we finally gave up, we deleted these files and renamed back the web.config and the rsreportserver.config files. To our surprise when we tried to open our report manager, the error below showed up. We tried to reconfigure the report server using the reporting services configuration tool to no avail. Any insights to what had happened and how to resolve it Thanks, Joseph Error message: The report server is not responding. Verify that the report server is running and can b ...Show All

• SQL Server Only functions and extended stored procedures can be executed from within a function.

  Hi, l've created an function [GSM].[KPIAging], and test it in studio by substitule declare value, i.e. DECLARE @sCellName VARCHAR(8) DECLARE @dDate DATETIME SET @sCellName = "CELL1M_1" SET @dDate = CAST('06/Jun/2006' AS DATETIME) EXEC GSM.KPIAging @sCellName, 'CSSR', @dDate It work fine and return the desired result, but when l used this function in SQL, SELECT DATEKEY, CELLREGIONKEY, CELL_NAME, CELL_ID, CSSR, GSM.KPIAging(Cell_Name, 'CSSR', @dDate) FROM GSM.GSMCellDaily_vw WHERE CSSR BETWEEN 0 AND 85 AND FULLDATE = @dDate AND CM_SERV > 30 AND (TCH_TRAFFIC > 2 AND TCH_SEIZURES_ATTS > 30) I got the following error, i.e. M ...Show All

• SQL Server Performance Question

  This is a very vague question but I was hoping someone might have a general answer for me as to why a table w/ 71.5 million rows in it might take 26 seconds to come back from: set tran isolation level read uncommitted select count(*) from communications Communications is the table containing 71.5 million rows. Could this be because the statistics are out of whack on the primary key of the table If so, what's an effective solution for updating the stat's on the primary key colleciton. I can't necessarily do a: update statististics communications communication_id with fullscan Or can I I mean, when I try that, it's takes ages to come bac ...Show All