Search results for query: *

Just done a full install of the full version (trial) of VS 2010 on another computer. It's done exactly the same so that's not it!

Hi I've been deploying an OEM program for a camera over the web but there's not many people actually downloading it. So I want to put it on the CD that goes with the camera. And I want it to install the relevant .NET framework from the CD rather than installing it off the web as it can be a...

Hi I am trying to get a form to rearrange itself when it maximises so that the working panel is in the middle. No big deal I thought. But it turns out I cannot stop it flickering like mad!! I have this for the initialisation: Public Sub New() MyBase.New()...

I knew the instance was called SQLEXPRESS on the target machines, both of them. That's not the problem. I'll need to test the new Access system to be sure, (I previously thought it was all sorted with SQL Express!), but I'm reasonably confident that it doesn't require extras to be installed...

On a different computer in a different office on a different job but if I recall correctly I have successfully connected with 'Localhost/SQLEXPRESS' and just 'Localhost' on the development computer and both failed on the installation test computer. Where the local instance is 'SQLExpress'...

Are you sure that the instance has started? Have you verified that the instance is named correctly? K2 Yes. This fails even when SQL Server Management studio is connected to the instance. Que? There is no instance named, just references 'localhost' which should be absolutely generic to the...

It's not actually SQL yet, A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider...

Hello All I have created a vb.net program that needs to connect the local instance of SQL Server in order to create a SQL Server database. I have created a test program where the code is simply: Public ConnectionString As String Public reader As SqlDataReader = Nothing Public conn As...

Oh, I started with Google, but couldn't find anything. The version of Word is not the problem as it works on the same machine on a different 'virtual' server. It doesn't even get to the SMTP program but the development server is the same as the live server, I'm using exactly the same...

Hi All I have an ASP.NET subroutine which converts an htm report into a word document for mailing out. I hit F5 in Visual Web Developer and it creates a test server on, say, port 1157, and works perfectly. Run it on the operational server, port 801, and it fails to create the Word program...

Convert the displayed value to proper case: company = "CHILKAT SOFTWARE" Print StrConv(company,vbProperCase)' prints "Chilkat Software" But that will change, for example, 'McFarlane' to 'Mcfarlane'. Otherwise you will need to retrieve the correct version and hold and display it as a session...

Hi This is probably a very simple answer somewhere but I can't find it. My applications created in MS VB 2008 EE are very slow to repaint when they are uncovered in Windows. (OK, 1/2 a second) It's the controls that seem to be the problem. This is after they have been installed as full programs...

Yes, I'm using it in SQL Server Management Studio. Haven't tried it from an asp.net script, I was testing it in the 'natural' environment first. Run it thru asp.net just now: Corrected a coupla C&P errors and it works! Thank you Markros! You've just taught me how to do a multi-joined update...

Hi Markros SQL Server 'verified it against the data source', then gave the message, 'Column or expression 'Total' cannot be updated.', then put a 'cross join' in again. And then stated that T was an invalid object when I verified again. I've bodged it by looping thru all the position rates...

The original query was using example info from tables I was testing on. In changing the query to match the actual tables, SQL Server 2005 altered it to add the TimeSheetData as TimeSheetData_1 and then added the cross join to TimeSheetData. Using RG's query as a basis I made several changes to...

OK, back to work after a long weekend golfing on the wettest weekend of the year!! And it's not working, I presume due to the cross join. It runs, but the result alternates between the first result and null for all 100 records I have in my test data. Tried: Changing it to inner, outer and just...

It's what SQL Server turned my attempt into. I have no idea what the CROSS JOIN does and, actually, I haven't attempted it yet, just parsed it. Bit dodgy on live data so I'm going to make a mock up and try it first. And looked up 'cross join'. I'm going to very careful with this.

Taking the lead that an update statement needs a FROM clause, something I would never have guessed, I managed, eventually, to validate the following against the data source: UPDATE TimeSheetData SET Total = TimeSheetData_1.[Time Sheet Hours] * StaffPositions.Rate FROM...

I have inherited a time sheet database which stores the hours that a person has worked against a project with a link to an employee table for his name which is linked to a positions table which gives the rate charged. And there is a totals value in the database which is supposed to be the hours...

I've tried different servers and different locations on the same server. Ah!! I decided to try an old version and looked at the installation folder URL from the new version to C&P cos I hate typing and... I'D PUT IN THE URL INCLUDING THE PUBLISH.HTM!!! It was the slash after it that gave me the...