|
I will take a shot at this:
Start Quote: DbConnection.Close Method Documentation
The Close method rolls back any pending transactions. It then releases the connection to the connection pool, or closes the connection if connection pooling is disabled.
An application can call Close more than one time. No exception is generated.
If the DbConnection goes out of scope, it is not closed. Therefore, you must explicitly close the connection by calling Close or Dispose, which are functionally equivalent. If the connection pooling value Pooling is set to true or yes, this also releases the physical connection.
End Quote
Close() and Dispose() are functionally equivalent. This means that you are lucky that your application functions at all. Most likely you have lots of memory and it takes time for the garbage collector to catch up and completely deallocate your connection object. The driver is eventually getting a pointer to a jumble of crap. To fix this, you need to reallocate (conn = new OdbcConnection(); ) just before you assign the connection string in the second try block.
|
|
|
|
|
i'll try it now and get back to you... thanks!
hope it works for the destination computer...
in a different computer (stronger one as i said with the win 2003 server) the app is working almost 24hours
with no problem.. :\
|
|
|
|
|
as expected... not working
thanks for the help anyway.. if you have any other ideas
i'd appreciate them
|
|
|
|
|
|
declare @TableName varchar(128)<br />
select @TableName = 'tablename'<br />
<br />
select c.COLUMN_NAME <br />
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS pk ,<br />
INFORMATION_SCHEMA.KEY_COLUMN_USAGE c<br />
where pk.TABLE_NAME = @TableName<br />
and CONSTRAINT_TYPE = 'PRIMARY KEY'<br />
and c.TABLE_NAME = pk.TABLE_NAME<br />
and c.CONSTRAINT_NAME = pk.CONSTRAINT_NAME
I Love SQL
|
|
|
|
|
Hi,
I know that you cannot connect remotely from SQL server 2005 Express to any other sql server.
But is it maybe possible to connect remotely from SQL Server 2005 (full edition) to SQL server 2005 express?
Thanks
|
|
|
|
|
hi
how can i fatch specified no of rows starting from some row no. for eg. if i want to fatch records from 5th row to 10th row how can i do it.
With Thanks
MHF
|
|
|
|
|
include an autoincrement column. using which this can be done.
Regards
KP
|
|
|
|
|
i want to know this is only way ?
is there any sql syntax ( like TOP ) that return specified no of rows ?
MHF
|
|
|
|
|
SQL Server 2005 having ROW_NUMBER() function.
|
|
|
|
|
in SQL Server 2000 is not possible.,
you may try as navaneeth suggesting.
Regards
KP
|
|
|
|
|
Gents,
I have a string "abcd1;abcd2;abcd3;abcd4"
in my database on an MS SQL there are stored "abcd3" in a column. In the reverse situation I would be able to do a select statement like this
Select * from MyTable where MyColumn LIKE '%abcd3%'
Is there any easy solution to it in the reverse way so i fx could do something like
Select * from MyTable where 'abcd1;abcd2;abcd3;abcd4' LIKE MyColumn
Tried this by the way, didnt return any result or error so guess there are some solution to it.
Cheers,
-- modified at 6:28 Tuesday 14th August, 2007
|
|
|
|
|
this not correct because '%adbcd3%' not equal to '%abcd3%'
Select * from MyTable where MyColumn LIKE '%adbcd3%'
if you need show resault you must write select statment
Select * from MyTable where MyColumn LIKE '%abcd3%'
|
|
|
|
|
Hi Rami,
This was an typo in this topic on the example for the normal way to use like statement.
Thanks for the notification of the spelling error.
/Ronni
|
|
|
|
|
hi ronii
you solve the problem
if you not solving problem i need more explane about your problem
with regards
Rami Abd alhalim
|
|
|
|
|
nope didnt solve the problem. please read the whole text.
I have string "abcd1;abcd2;abcd3;abcd4" for example posted from a website or an application
In my database i have a string "abcd1".
I now need to find out if any part of the string ("abcd1;abcd2;abcd3;abcd4") is present in the column who hold fx "abcd1". This have to be done in a single select statement.
If done reverse "Find abcd1 in database with abcd1;abcd2;abcd3;abcd4 then a standard Select * from TableName where ColumnName LIKE '%abcd1%'" but is there an fast and easy to do that in a simliar way? just reverse in finding part of a string in the database?
/Ronni
|
|
|
|
|
add this function after that you can split string to compare between your string
=======================
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
ALTER FUNCTION [dbo].[fn_Split]
(@text varchar(8000), @delimiter varchar(20) = ' ')
RETURNS @Strings TABLE
(
position int IDENTITY PRIMARY KEY,
value varchar(8000)
--Name2 Varchar(8000)
)
AS
BEGIN
/*Declare @Strings TABLE
(
position int IDENTITY PRIMARY KEY,
value varchar(8000)
)
*/
DECLARE @index int
SET @index = -1
Declare @Text2 varchar(8000)
SET @Text2=@text
Declare @index2 int
WHILE (LEN(@text) > 0)
BEGIN
SET @index = CHARINDEX(@delimiter , @text)
IF (@index = 0) AND (LEN(@text) > 0)
BEGIN
INSERT INTO @Strings VALUES (@text)
BREAK
END
IF (@index >1)
BEGIN
SET @index2=len(Right(@text, @index - 1))
SET @text2=SUBSTRING(@text,LEN(LEFT(@text, @index+1 )),CHARINDEX(@delimiter , @text)-1 )
INSERT INTO @Strings VALUES (LEFT(@text, @index - 1))
SET @text = RIGHT(@text , (LEN(@text) - @index))
END
ELSE
SET @text = RIGHT(@text, (LEN(@text) - @index))
END
RETURN
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
=======================
after add this function
select * from tablename where 'abcd1'in select value from fn_Split('abcd1;abcd2;abcd3;abcd4',';')
Rami Abd alhalim
|
|
|
|
|
How about:
select * from MyTable
where ';abcd1;abcd2;abcd3;abcd4;' like '%;' + MyColumn + ';%' Regards
Andy
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".
|
|
|
|
|
Great thanks Andy. Worked like a charm.
Cheers,
Ronni
|
|
|
|
|
I am inserting a row into database from asp.net. Below is the command i had given:
insert_cmd = string.Format("Insert into CreateTask(AssignedTo,AssignedDate,EstimatedEfforts,Priority) values ('ABCD',14/08/2007,30,'Medium')");
The date i had given in the command is 14/08/2007, but when I check the table data in SQL server the date is displayed as ---- 1/1/1900 12:00:00 AM
Please help me out...
Sailaja
|
|
|
|
|
this problem maybe cause format date
if you need sure that set in command this date
solve:
insert_cmd = string.Format("Insert into CreateTask(AssignedTo,AssignedDate,EstimatedEfforts,Priority) values ('ABCD',08/14/2007,30,'Medium')");
|
|
|
|
|
Said could you plz tell me how to do that as i dnt know.
i'm new to sql
Sailaja
|
|
|
|
|
Insert into CreateTask(AssignedTo,AssignedDate,EstimatedEfforts,Priority) values ('ABCD','2007-8-11',30,'Medium'
In VB u have format function. U can use this function to format the date.
i.e. YYYY-MM-DD format.
|
|
|
|
|
thx pande... the code worked correctly if I give the date in single quotes but am not getting the current system time in it..
its displayed as:
8/14/2007 12:00:00 AM
Sailaja
|
|
|
|
|
If you want to insert the current date and time, use the Getdate() function. It's a Sql Server function that returns the current date and time. For instance:
insert into myTable(CurrentDate) values (GetDate());
Deja View - the feeling that you've seen this post before.
|
|
|
|