Maybe you could use this trick[^]. But the idea of an SSIS package executed every 10 seconds keeps bugging me. What kind of package is it? What does it do? Does it take less to 10 seconds to execute it?

What do you mean? Do you want this package to execute every 10 seconds?

karthi84 wrote:

please note that i am connecting to sql server 2008 on a server

Are you positive about this? I am asking because it seems weird to me that the error message mentions SQL Server 2005 (When connecting to SQL Server 2005 ...) when you are connecting to SQL Server 2008.

Check this article[^] and this comment[^]. I cannot make it work, but maybe it will point you in the right direction.

Getting the hardware is pretty easy - all one needs a mobile and a way to connect it to the computer (cable, IrDA, Bluetooth). Then it's only a matter of working out how to connect to the phone and make it send an SMS.

Check this link[^]. Is there any other error number (apart from 40)?

Camilo Sánchez Herrera wrote:

this is the N property of my class, and the method isMagicSquare returns false if there is a single row or column wich sum is different from N

Sorry, I didn't notice that. I cannot understand how you generate the squares to check, but, if you're not already doing it, maybe you could check every generated row and only generate a next one if the sum of the previous one equals N. BTW, is it a school/university assignment?

You can consider something like this (change DEV_COMPUTER and TEST_COMPUTER to match the names of your computers):

<appSettings>
<add key="ConnectionString_DEV_COMPUTER" value="..." />
<add key="ConnectionString_TEST_COMPUTER" value="..." />
</appSettings>

ConfigurationManager.AppSettings("ConnectionString_" + Environment.MachineName).ToString

Maybe this has something to do with this:

[ObsoleteAttribute("This method is obsolete, it has been replaced by System.Configuration!System.Configuration.ConfigurationManager.AppSettings")]

I know that obsolete doesn't mean it doesn't work but try to use the other method.

You calculate the sums of all rows, columns and diagonals to check if a given array is a magic square, right? You don't have to do it - you can: (1) stop the calculations right after you get two different sums (two sums at minimum are needed to determine that a given array is not a magic square), (2) or even better, use the formula SUM = n*(n^2+1)/2 and calculate the sums only to the point when you get one that does not equal SUM (even one sum may prove that a given array is not a magic square). This should speed up things, although I don't know if this will be enough. Please use the code block tags when pasting code into your message. And consider pasting only the important pieces.

Try: rs.Fields("CategoryName")**.Value** = txtcat.Text.

Why exactly do you need something like this? It looks weird. You want do mix pieces of different information in the same column.

You will have to build a SELECT statement dynamically and then execute it using sp_executesql[^]. But as far as I know it's not very good performancewise. Google for "dynamic SQL" and read about it. How many different values of @Tbl_col_name will you be using? Wouldn't it be easier to create a separate SP for each case?

Maybe I am the only one who doesn't know it, but what is 'Magic'?

And what does it have to do with 'SQL / ADO / ADO.NET'?

This article[^] looks weird[^] on my computer (Windows XP + Firefox 3 beta; I also tried to use IE7).

If you are using SQL Server 2005, you should avoid subselects, because their performance is poor. I'd rather use:

SELECT
NAME
, MIN(REG)
FROM dbo.MYTABLE
GROUP BY
NAME

ptr2void wrote:

Didnt quite get this line.. What might break??

Imagine that you installed two different applications that use the same control (e.g. Excellent.Grid.dll). Your app will find the Excellent.Grid.dll file in two different directories (e.g. C:\Program Files\Excellent Calendar and C:\Program Files\Excellent Cookbook), will delete one copy since they are exactly the same and... one application will stop working.

Is it SQL Server 2005? If it is, you can try this[^].

What have you done so far? What exactly is the problem? Can't you read an XML file or connect to a database or execute a stored procedure?