|
|
|
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 August 2008 |
Filter by week: 1 2 3 4 Strange error on SQL2000 via ODBC connection Posted by Eric Lenington at 2/7/2004 10:21:26 PM Does anyone have any idea what causes the error below? I can't find any
reference to it anywhere. The stored procedure is a simple update and works
most of the time, but every one out of several thousand calls, we get this
error:
(21) State[HY000] Message[[Microsoft][ODBC SQL Server Driver][SQ...more >>
Use temp table function Posted by Grey at 2/7/2004 12:03:19 PM It's mean that I am just using "sa" as DB login username for my =
application now. For now, I need to use SQL server' s temp table =
function. Do I need to create different DB user for each application =
user. There are five users using the application. Do I need to create =
five DB user in orde...more >>
SQL Server corruption chance Posted by Vlad at 2/5/2004 12:33:16 PM I'm using Access 2000 database for my VB 6.0 multiuser application (db is
located on file server). Database gets corrupted pretty often. I've read
just general statement about SQL Server stability and robustness. Is SQL
Server database corruption happening too? If so then how often comparing to
...more >>
Update AS400 via Linked Server Posted by l11hill NO[at]SPAM hotmail.com at 2/5/2004 7:46:47 AM I have my linked server to our AS400 working. I can select any data
on the 400 and return it using either OPENQUERY, or the 4 part name
(select * from LINK.SERVER.LIBRARY.TABLE).
Sql server 2K, iSeries ODBC 10.0, Microsoft OLE DB Provider for ODBC.
I have the commit set to *NONE for the ODBC...more >>
Problem registering a remote server Posted by karl.rhodes NO[at]SPAM keywave.com at 2/5/2004 3:55:44 AM Hey all...
We have several websites running SQL server back ends and we have
successful registrations for each in SQL Servers Enterprise Manager.
We also have a client who hosts their own SQL Server Database and we
used to have a good registration for their SQL Server.
Our client has moved ...more >>
ExOleDB Permissions problem as linked server Posted by joikm NO[at]SPAM hotmail.com at 2/4/2004 11:50:27 PM I have Exchange 2000 server and SQL Server 2000 installed on the same
box. I using the ExOLEDB data provider to set up Exchange as a linked
server in SQL Server. A public folder is queried in a stored procedure
using OpenQuery and a SQL Query against the Exchange folder.
This all works fine, a...more >>
NT 4.0 machines cannot connect to SQL Server, but other Windows like XP can? Posted by Marco Napoli at 2/4/2004 4:53:23 PM We are having problems were NT 4.0 machines cannot connect to our SQL Server
2000 over TCP/IP, but other Machines like Windows XP, Windows 98 can connect
to our SQL Server???
Find below our ADO connection string. Port 1433 are blocked on the client
machines, so we use SSL Certificate on our...more >>
Fighting lost network connection Posted by Bojidar Alexandrov at 2/4/2004 3:22:14 PM Hello, all
I have next question - What are best practices to catch situation when there
is a loss of connection between application and SQL Server for few seconds?
As I have found till now in Internet - Connection.State is not affected by
loss of connection - it represents state after last e...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
c# and sql server for windows ce Posted by Steiner Hubert at 2/4/2004 12:49:16 PM hello,
i use in c# the following line:
using System.Data.SqlServerCe;
the following error is visible
"The type or namespace name 'SqlCeEngine' could not be found"
how can i fix this problem?
...more >>
Database permission error Posted by Taishi at 2/4/2004 7:23:41 AM Windows Pro
Receiving the following error:
CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NETSDK\Data\pubs.mdf'.
Here are some things done to try to resolve the problem:
Reboot 4-5 times
Sha...more >>
OLAP service and Excel XP Posted by Ching at 2/3/2004 9:52:19 PM Dear Friends,
Do we need to start both services, ie
MSSQLServerOLAPService and SQL Server in "SQL Server
Service Manager" if I want to use MS Excel XP to connect
to the SQL server? In case I want to access the cubes
which define in Analysis Server.
Best Rgds,
Ching...more >>
ConnectionOpen (PreLoginHandshake()). General Network Error Posted by Joel Gacosta at 2/3/2004 2:16:39 PM Hi all,
I'm getting the following error on my SQL on a local machine when running a
client program that connects to sql server located at the same machine. What
does it means? Do i have to configure in SQL settings?
[DBNETLIB]ConnectionOpen (PreLoginHandshake()). General Network Error.
th...more >>
Problem with SQL query Posted by Vinita Sharma at 2/3/2004 1:29:42 PM Hi All,
I have the following table suppliers and product.
The Supplier table have two columns Supplier_id and Supplier_name.
Below is my data in the supplier table:
Supplier_Id
Supplier_Name
2
New Orleans Cajun Delights
3
Grandma Kelly's homestea...more >>
=> Connection Failed - Cannot generate SSPI Context Posted by Rhonda Fischer at 2/3/2004 10:21:09 AM Hello
The connection to the SQL Server seems to be regularly breaking with the error message
MS Server Logo
Connection Faile
SQLState: 'S1000
SQL Server Error:
[Microsoft][ODBC SQLServer Driver] Cannot generate SSPI ...more >>
Cannot generate SSPI context Posted by DaveD at 2/3/2004 2:06:09 AM Hi All,
I am experiencing problems with a remote user (w2k pro,sql 7) attempting
to connect and replicate with a Sql Server 7 on NT server.
They are receiving 'Cannot generate SSPI context' messages when trying to
use a vb app over a vpn. This problem cleared (perhaps due to a server
reboot) ...more >>
Suddenly Disconnect ??? Posted by Stephen at 2/2/2004 8:06:08 PM Dear all experts,
Our company ERP system connect to the SQL server database; But start from yesterday, it found that the system connect failed to the database, so I go to check the SQL server working status ...
I found that I cannot connect to the SQL server with using enterprise manager (and ...more >>
Local Server not start Posted by anonymous NO[at]SPAM discussions.microsoft.com at 2/2/2004 4:41:51 PM I changed my local server from
(local) to Machine Name and every thing seemed work fine
after restart windows 2000 today the local SQL Server not
start.
Then I use . (period) to register again
But I got:
A connection could not be established to ...
Reason: SQL Server does not exist or acce...more >>
Unable to connect Posted by Tony Schlak at 2/2/2004 2:02:36 PM While in VS.Net i am able to see the tables, views etc. and setup my
databind ionformation and preview the configuration set. However when i try
to view the site from the web it gives this error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
I have it set tp use SSPI and this is the er...more >>
Terminal Server 2000 as client connecting MSSQL Server 2000 Posted by Steve at 2/2/2004 1:45:47 PM Does anyone if this can be done and how??
--
The information contained in this email is privileged and confidential and
intended for the addressee only. If you are not the intended recipient, you
are asked to respect that confidentiality and not disclose, copy or make use
of its contents. If...more >>
Firewall Problem Posted by AussieRules at 2/2/2004 12:10:26 PM I have opened port 1433 on my firewall, but I am still not able to get
remote clients to connect via query analyser, or enterprise manager.
Are there other ports required to be opened ?
...more >>
Upgrade killed my connection, ASP to SQL doesn't work Posted by Alex V. B. at 2/2/2004 8:26:06 AM I upgraded W2K to 2003 enterprise on my web server, my website accesses my SQL server so customers can track shipments etc. but now on the web site I a get the error Web Error 8007007f /Classlib.asp line 151, when trying to access SQL data. I also get this during startup, MSMDSRV.exe Entry point...more >>
Data Posted by Viraj at 2/1/2004 5:53:51 PM I am in the planning process of upgrading the hardware on
our cluster. I need info/advice/suggestions on how to go
about this.
I am running an active/active cluster on 2 ML370 servers.
They are running Windows 2000 Advanced Server/SP2, MSSQL
2000 Enterprise/SP2.
I want to know if all I hav...more >>
Strange Enterprise Manager Connection Problem Posted by Scott Edwards at 2/1/2004 2:50:01 AM Hi all,
I'm having a very weird connection problem that I thought someone
might be willing to help me with. I'm connecting to a 2000 SQL server
at work over a VPN using tcp/ip on port 1433. I can connect to the
server fine from Enterprise Manager, but the minute I click to expand
the Datab...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |