|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 setting rowcount via odbc? Posted by Robert Paquette at 9/5/2003 12:27:30 PM Hi
I'm trying to limit my result set by using SET ROWCOUNT N where N is my
desired number of rows. The program runs against SQLServer 2000. SQLProfiler
shows the following trace but the row count limit is not applied.
declare @P1 int
set @P1=196
exec sp_prepexec @P1 output, NULL, N'SET ROWCO...more >>
slow connection Posted by Wayne Hui at 9/4/2003 2:18:50 PM I was testing my C app that uses ODBC to connect to SQL
Server and noticed if I kept the connection open until all
queries are finished, it is 2-3 times faster.
I thought SQL Server has connection pooling that
disconnecting and connecting should not be a problem. Does
connection pooling not ...more >>
Connection String Restrictions Posted by Kyong Kwak at 9/4/2003 12:45:40 PM Hi,
I want to connect to multiple servers (ms sql server, oracle, ASA, and ASE)
and I plan to use SQLDriverConnect().
Reading over the documentation on MSDN I see that the connection string for
SQLDriverConnect() allows braces (e.g. { } ) for attribute values.. such as
PWD={xxx} -- (though it...more >>
Deadlock of MS SQL 2000 Posted by Tommy Lam at 9/3/2003 6:57:51 PM Hi All
I am receiving the following error message when running the web page (ASP)
Your transaction (process ID #11) was deadlocked with another process and
has been chosen as the deadlock victim. Rerun your transaction.
What can I do to resolve this problem? Where is a good place to start
l...more >>
ODBC Program & Heterogeneous queries problem Posted by Melvine at 9/3/2003 10:06:13 AM
Best All,
What I am doing is following:
1. I created a stored procedure "testit" which select records from
another data source in another SQL Server, like:
-------------------------------------
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
go
create procedure testit
as begin
select * fro...more >>
Exchange Error Posted by harrynaik at 9/2/2003 11:32:38 PM
Everyday when the mainteance of the server starts in the night the
below error comes and all the exchange services are stopped. Any
Clue ??????
Event Type: Error
Event Source: MSExchangeIS Mailbox Store
Event Category: General
Event ID: 7200
Date: ...more >>
Login Prompt Posted by bert at 9/2/2003 5:00:26 PM We are accessing SQL Server 2000 with a MS Access 97
application using an ODBC connection.
I have set up the ODBC driver and connected to the
database using a SQL Server account. I have it set to use
SQL Authentication using an ID and password entered by
the user. I can connect and run qu...more >>
Where can i download ODBC Posted by LuckyEagle at 9/1/2003 10:57:19 AM Where can i download ODBC for ACCESS 2002
including OLE DB
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |