|
|
|
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 I get this error "Protocol error in TDS Stream". Posted by Subbu at 12/13/2003 8:40:13 PM
Hi
I have a table with following structure
Field1 VarChar(10)
Field2 VarChar(10)
Field3 Text
In this table there are 3000 records and for each record the Field3 contains
around 50000 to 60000 characters.
In SQL Query Analyzer, If I select all the records in the above table, I get
thi...more >>
UNICODE ? Posted by Lisa Pearlson at 12/12/2003 6:24:03 AM Hi,
I am using MS Visual C++/MFC/ODBC and I execute commands like this:
CRecordset rs;
rs.Open( ..., _T("SELECT .... FROM ..."), ...)
Now, I have been compiling and running this in NON-UNICODE mode..
But if I make this UNICODE, my query string will be in unicode. I'm assuming
this is t...more >>
Distributed transaction error Posted by deirdre at 12/11/2003 9:10:11 PM Hi,
I am getting the below error after a timeout when trying
to connect to an SQL Server database. This refers to the
connection setup to the database from my asp page. This
was working perfectly fine until 2 days ago and this same
connection is used throughout the system with out any
p...more >>
How do I get db ddl properties from sql 2000 like documenter does in MS Access? Posted by NOSPAM at 12/11/2003 8:53:40 PM Hi,
I am looking for an easy way to get all of the properties from a SQL 2000
database much like the documenter does in MS Access. Any ideas?
...more >>
Importing Posted by David at 12/10/2003 5:30:55 PM Is there an easy way to import an existing Access DB into
SQL. The current Access DB is 1GB in size. When I try
the upsizing wizard, I get the message that it skipped
and/or failed....more >>
How do I back-up > truncate > shrink > back-up SQL 2000 Posted by NOSPAM at 12/9/2003 8:34:29 PM Hello,
I am hoping you can help me with the following problem; I need to =
process the following steps every couple of hours in order to keep our =
Sql 2000 database a small as possible (the transaction log is 5x bigger =
than the db).
1.back-up the entire database
2.truncate the log
3.sh...more >>
What is Wrong ? Posted by Tanveer H. Malik at 12/9/2003 5:19:34 PM I'm using SQL Server 2K and VFP8.
When I save a record, the following ODBC Error Message is displayed.
'Column Name [RefNo] appears more than once in the result column list.'
Pls anybody come to my rescue....more >>
How can I restore a SQL 6.5 database backup to a SQL 7.0/2000 server? Posted by Pedro Cunha Rodrigues at 12/9/2003 4:38:40 PM Thanks,
Pedro Rodrigues
pedro@markdata.pt
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help - SQLExecDirect Posted by anonymous NO[at]SPAM discussions.microsoft.com at 12/8/2003 12:37:01 PM I could really use some help, I have a system dsn and am
using the Sql Server 2000 odbc driver. I am getting an
error S1000: [Microsoft][ODBC SQL Server Driver]
Connection is busy with results for another hstmt.
When I look at the dsn settings, there is a check box to
turn off SQLPrepare....more >>
ODBC Connection failed Posted by Andy at 12/8/2003 8:48:58 AM I am having an issue connecting to a SQL server under
windows Xp and office 2003. This is the error it gives.
****
Connection Failed
SQL State : 'HY000'
SQL Server error : 0
[Microsoft][ODBC SQL server driver]Cannot generate SSPI
content
****
Connecting to the same Database on the SQL ...more >>
Stored procedure behave different in Query Analyser and ODBC, is it timeout? Posted by iritgef-google NO[at]SPAM cs.huji.ac.il at 12/8/2003 3:04:09 AM Hello,
I have a stored procedure, that work fine from the Query Analyser.
I used it from C code by ODBC api - not all of the rows that supposed
to be changed, were changed.
so i added SET NOCOUNT ON in the stored procedure, then it worked.
After few days i tried it on another computer and i...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |