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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|