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
November 2007
all groups > sql server connect > october 2005 > threads for october 15 - 21, 2005

Filter by week: 1 2 3 4 5

Receive Error: 17805 Invalid buffer received from client
Posted by Brett Davis at 10/21/2005 1:50:53 PM
Hello I am running SQL Server 2000 with SP 4 on Windows Server 2003. Every hour I receive several notifications with the following: Reply: Message not found. Insertion strings:Error: 17805, Severity: 20, State: 3 Invalid buffer received from client. I want to create a SQL Profiler ...more >>


Oracle linked Server Performance
Posted by Markus Donath at 10/21/2005 10:32:46 AM
Hello, we have an Oracle Linked Server (8i) running linked from SQL Server 2000 SP4. The performance is ok when selecting data from the sql server, but poor when trying to insert data into the oracle database via linked server. Even simple inserts ( insert into lserver..xxx.tablename ...more >>

.....SQL Server does not exist or access denied .. Help !!
Posted by Jessica McMillan at 10/21/2005 4:59:39 AM
3 workstations previously installed and able to access server. 4th workstation am able to map to server access files but when attempting to log in receive the following error. EXTERNAL DATABASE OPEN FAILURE Error: -2147467259[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server doe...more >>

when 127.0.0.1 sql server does not exist or acess denied
Posted by hon123456 at 10/21/2005 3:17:12 AM
Dear all, I am writing ASP to connect to SQL server. In the connection string,when I write the database server as "(Local)" or ".", it will connected sucessfully. But When I used "127.0.0.1" or "localhost", it complains with the message "SQL server does not exist or access denied", or someti...more >>

best provider for connection to SQL ??
Posted by paolol at 10/21/2005 12:00:00 AM
Hi , any one can suggest me wich is the best provider connection I can use for my program to connect to an MSSQL 2000, currently I use the "Microsoft ADO OLEDB for SQL" . Thanks, Paolol...more >>

SQL server does not exist or access denied
Posted by Jan Timmer at 10/20/2005 1:33:54 PM
Hello, We have two applications that connect to three SQL databases on another machine. Both applications access and update the databases. One application is a web application (ASP.NET) the other one is a Windows service. The web application runs fine. It accesses and updates all three databa...more >>

How to reset context_info in connection pooling environemnt?
Posted by Ram at 10/19/2005 7:20:47 PM
Hi If we use connection pooling, then a sp 'sp_reset_connection' will be executed to clean the connection. Does this sp clears the context_info for the connection or not? Our initial tests shows that it is not clearing the context_info. How to clear context_info in connection pooling envir...more >>

SQL Server Connection Problem
Posted by amrandolph at 10/19/2005 1:34:44 PM
I can connect to the SQL Server database through Enterprise Manager and the SQL Server Service Manager is showing the database running but I cannot connect to the database through Query Analyzer. Any suggestions? ...more >>



alias w/IN operator
Posted by broski via SQLMonster.com at 10/19/2005 12:00:00 AM
running this now, but need the names, & not emp ID's. select ticketid, acct, date, createuser from ticket where createuser in ('k1001', 'k1002', 'k1003', 'k1004') group by createuser will the 'as' work in the IN operator? where createuser in ('k1001' as Dave, 'k1002' as Sue, 'k1003' as S...more >>

Interdev, SQL Server 2000 vs. SQL Server 7; open/design problems
Posted by tharshbarger NO[at]SPAM gmail.com at 10/18/2005 8:17:27 AM
I run Visual Interdev 6... I have 2 web servers and 2 database servers... (1 of each located in my home - A; and 1 of each co-located at an ISP - B with our own firewall at each location). Location A: Firewall, port 1433 opened (for specific IP#'s) Web Server: IIS5 SQL Server: 7 Location ...more >>

CONNECTION PROBLEM ON WIN2003
Posted by Savas Ates at 10/18/2005 12:00:00 AM
hi i have sqlserver that running on windows 2003 i have connecton to this server from an other computer and i need tcp/ip connection to this sql server but i cant connect to this sql with this port when i use netstat -an i dont see this port(1433) on pro...more >>

Connect via ServerName but not by IP or FQDN
Posted by Brett Wickard at 10/17/2005 4:36:50 PM
How can I make it so that our intranet clients can connect to the SQLServer via our FQDN? Our extranet clients work fine via that way, but once they go behind the VPN, the FQDN doesn't work. Also for onsite intranet clients we can connect fine via server name, but not via IP address or FQDN....more >>

Connecting via ODBC to SQLServer 2005 June CTP using MARS
Posted by Florian B. at 10/17/2005 3:56:02 AM
Hello newsgroup, after searching around the web, some reading and testing I'm still having problems using MARS via ODBC with the SQLServer2005 June CTP. I'm trying to enable MARS by connection string, after some looking about "MARS_Connection=yes" should be the setting. That right? I fou...more >>

Owner's Access to table
Posted by Jim Bunton at 10/17/2005 12:00:00 AM
SQL SERVER 2000 Personal Edition Win 2000 Connect using SqlServer Authentification Jim **pw** Run the following to create a new table:- -------------------------- USE SolutionsNet GO CREATE TABLE Companies (CompanyId INT PRIMARY KEY IDENTITY(1,1), Companyname VarChar(50) NOT NU...more >>


DevelopmentNow Blog