Groups | Blog | Home


Archived Months
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


all groups > sql server odbc > october 2003 > threads for october 29 - 31, 2003

Filter by week: 1 2 3 4 5

[ODBC SQL Server Driver]TDS buffer length too large
Posted by Lukipela at 10/31/2003 12:50:18 PM
Hi, When I query a table selecting for one column [Varchar (1000) ] and for all the rows in the table, I get an ODBC error. However, the error is not very consistent and it breaks off with this message at different output levels. (i.e. sometimes it breaks off after 10000 + or 25000 + rows...more >>

memory leakage SQL2000 sp3
Posted by michael at 10/31/2003 11:43:20 AM
I have a problem with memory leakage sql 2000 sp3. Does any body have the answer. ...more >>

Either BOF or EOF is true
Posted by richard at 10/31/2003 11:40:56 AM
Is there a way to set the ODBC driver for SQL server or SQL server to return this error message when trying to navigate on an empty database table. I have one site running Sybase 11 that allways returns this message, whereas I develop on SQL Server that doesn't. I have tried to find all the p...more >>

How to acces ODBC Table from within SQL2000
Posted by Wanadoo at 10/31/2003 10:41:41 AM
Hi every body, I'm new in SQL 2000, I wish to acces an ODBC table from within my SQL2k database. How can i do that. Thanks for your help. Q.S. PHU ...more >>

ODBC error
Posted by Erick at 10/30/2003 1:40:35 PM
ODBC Error Microsoft][ODBC SQL Server Driver][SQL Server] Could not find stored procedure ...more >>

Seeing Multiple tables from a linked server
Posted by Bill Nguyen at 10/30/2003 10:50:43 AM
I'm using Dharma ODBC to create a linked server to a databalse residing on an SCO Unix box. The linked server looks good. However, when I tried to run select statments (or creating views), the following error messages always came up: Server: Msg 7315, Level 16, State 1, Line 1 OLE DB provider...more >>

SQL_MAX_ROWS
Posted by shree at 10/30/2003 10:11:01 AM
Hello Does using SQLSetStmtOption with 'SQL_MAX_ROWS' option really help in improving performance and reducing network traffic? Have you noticed and drastic difference in performance by using this? Shree ...more >>

Watch that update
Posted by areatonlus at 10/30/2003 1:59:00 AM
Microsoft Consumer this is the latest version of security update, the "December 1996, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to pr...more >>



SubQuerying Vs Joining
Posted by Awah Teh at 10/29/2003 3:49:19 PM
Which is most effective (consider the query below for an example)? Please give me some explanation (FMI:) as to why one is faster over the other. --Both Queries are designed to get the users information of users that received passes in the Year of 2003 --** *************** --** Q...more >>

Linked SQL Server View Not updating.
Posted by calvinX at 10/29/2003 2:48:32 PM
Hi All, I asked this question over in m.p.access.tablesdbdesign but thought I may also get a response here. Here goes: I have a view in a SQL Server 2000 DB that will not update the design in my msaccess database (.mdb). I recently increased the size of one of the fields from 5 characte...more >>

ODBC Connection Failure
Posted by James Monroe at 10/29/2003 12:16:30 AM
Greetings All: I have a number of machines that remotely connect to an SQL server via a VPN. Tables are linked via ODBC. (The front end is in Access). All went great for awhile, then all of a sudden we're getting the error that says "Can't find SQL Server or Access was denied". Mach...more >>


DevelopmentNow Blog