|
|
|
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 5 A connection could not be established between networks Posted by Steven at 9/14/2004 8:47:04 PM While trying to connect SQL server from one network to another I'm suddenly
getting this error message:
A connection could not be established to ServerName.
Reason: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection..
Please verify SQL Server is runni...more >>
"network name is no longer available" Posted by network name is no longer available at 9/14/2004 7:41:11 PM Hi all,
I'm having a problem with backing up SQL to a network share, often I would
get the "network name is no longer available". Sometimes it works and
sometimes it doesn't. During the backup, both servers - source and
destination are at minimal cpu , memory and network utilization. Netw...more >>
Remote Stored Procedure Posted by Rick at 9/14/2004 11:44:27 AM If I create a link server on my SQL Server to another SQL Server and run a
stored procedure using:
EXEC otherserver.database.dbo.sp_myproc
Does the procedure actually "run" on the remote server or on my SQL Server?
Thanks!
...more >>
Basic MSDE Setup Question on Windows Server 2003 Posted by Jolly Student at 9/14/2004 12:50:22 AM Dear Colleagues:
This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).
Ok...more >>
For GURU with big ball !! Posted by Giuseppe Pezzella at 9/13/2004 7:34:11 PM Hi
Data Link Properties, open by test.udl file, when open don't show any
istance of MSDE sp3 installed.
By Visual Studio.NET 2003 Server Manager I can see the server and database.
If I insert manually name istance and try test connect it return me this
message:
Test connection failed becau...more >>
what's the problem? Posted by the error string is as follow:
"The text, ntext, and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator."
...more >>
Win2K3 Client / Win2K3 & 2K SQL Server DBNETLIB Problem! Posted by Teddy Smith at 9/13/2004 4:47:59 PM Hi all,
I am having a major problem with a simple application that queries a
database.
Firstly we have SQL2000 SP3a running on a Windows 2003 Server with all the
latest patches and updates. Windows 2003 is running the shipped MDAC 2.8 and
I've run the component checker to make sure there is...more >>
Compare records between two tables Posted by Kiran B. at 9/13/2004 12:39:38 PM Hi all,
I have table A and populate table B with table A but before I do that I
need to compare records in between those two tables....
If there are new records on table A, I need to insert it into
newTable and if there are records that has changed then I need to insert
into upda...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Invalid object name 'db_student.myuser.tbl_studentname'. Posted by HI, i am a newbie of SQL server.
What I got is an error shown as the title in which an ASP file made the SQL
call.
The script is just as follow:
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_cia_STRING
'Recordset1.Source = "SELECT * FROM fund WHER...more >>
Can not connect to SQL Database Posted by john.pederson (removethis) NO[at]SPAM akorn.com at 9/13/2004 7:36:56 AM We periodically receive an error message: Database 'db
name' can not be found or is busy....
We seem to get it more often with users who attempt to
connect to our DB using a wireless network card in their
laptop. However, we periodically get it with users on
our network. Is this a conn...more >>
Data Link properties don't show any istance Posted by Giuseppe Pezzella at 9/12/2004 9:48:08 PM Hi
Data Link Properties, open by test.udl file, when open don't show any
istance of MSDE sp3 installed.
By Visual Studio.NET 2003 Server Manager I can see the server and database.
If I insert manually name istance and try test connect it return me this
message:
Test connection failed becau...more >>
ADODB connection mode adModeShareExclusive still allows other connections. I need the SQL database to myself! Posted by William Hildebrand at 9/11/2004 8:17:36 PM Hello,
I'm opening an ADODB connection to an SQL database in VB6 using the
adModeShareExclusive mode for the connection object. The connection opens
successfully, but I'm still able to modify records in the database using
Enterprise Manager. Why is this? I want to open the SQL database a...more >>
Registration from Enterprise Manager Posted by Renu Doda at 9/10/2004 3:44:06 PM Here is my problem:
I have a sqlserver SQLA which I have registered in EM with a sqlserver
authentication with a uid and password and that connection works fine. The
problem is that when I look at the security log of SQLA, i see continuous
failure audits but with a uid that I am logging in to my...more >>
LinkedServer Failure to connect Oracle 8.1.7 Posted by Paul at 9/10/2004 2:56:44 PM The Error Occured while connecting to oracle from
SQLServer 2000 in WINDOWS 2003, I have tried with MDAC
2.8, MDAC 2.7 and restarted the Server, nothing is
working. We are always getting the Same Error
Error 7399: OLE DB Provider 'MSDAORA' Reported an error.
OLE DB error trace [OLE/DB Pr...more >>
Intermittent connection loss? Posted by news.microsoft.com at 9/10/2004 10:57:10 AM Hi all,
I have a .Net windows application that uses the micrsoft application block
to make calls to the database. I am doing a few thousand records that must
be inserted. I have a problem where on occasion I get an exception that
says "SQL Server does not exist or access denied." This seems t...more >>
New to SQL Posted by cds at 9/10/2004 7:36:35 AM Hi
I am setting for the first time SQL to access a database. I can get the
Enterprise Manager and the Network Utility to see the databases (on 2
computers) but when I go to the program to access the databases, I get a
Connection error.
Strangely, I set up the exact replica on the server ...more >>
Linked SQL 2000 server and views Posted by Marcus at 9/10/2004 3:35:01 AM I only have basic SQL knowledge and am trying to modify some previously
created views, the problem I have is the views were originally only accessing
tables on the local SQL 2000 server which was fine, but now one of the
databases has been moved to another server and I'm trying to modify the v...more >>
stale connection handle in ODBC Posted by TN at 9/9/2004 4:43:01 PM A quick question from an SQL novice trying to debug problems of connection
link failures between client and server. Here is the scenario:
- application opens connection from client to SQL server
- lots of intermittent activity between client and server (connection to
server stays alive th...more >>
How to check which port that SQL Server currently using? Posted by ricard at 9/9/2004 11:13:35 AM Hi, I'm trying to connect to MS SQL server using PHP Pear DB package. I
have 2 SQL server running on different machine. 1 is using SQL Server
2000 Standard Edition and the other is SQL server from .NET SDK.
I can connect to the standard edition but not to SQL Server from .net
SDK. Did they us...more >>
freedom software Posted by Debbie at 9/9/2004 9:47:17 AM I run Freedom software on my clients machines. When the
computer name changes
we have to completely reinstall the Freedon software or it
will not connect
to the MSSQL server. Someone told us that there is a
command in MSSql that
will allow us to change the computer name of the client
A...more >>
Unable to Connect to SQL 2k server Posted by SqlJunkies User at 9/9/2004 7:02:15 AM Here's my dilemna:
I have an SQL 2000 server. We have about 10 people that connect to it using Enterprise Manager. Here's what we do: we register the SQL server using an sa account, no problem. The problem that we face is that we can view all the "options" (the management, replication, data transfe...more >>
Limit of SQL Posted by Jessy at 9/9/2004 2:56:20 AM I would like to know if there is any no. of SQL limit
within a transaction....more >>
Exchange Server as a LINKED SERVER Posted by perry at 9/9/2004 1:51:13 AM
I have successfuly link Exchange to my sql server...what i
am trying to do is fetch all the data of the Exchange and
archive it to an SQL database... my question is it
possible when i got all the information from exchange and
archive it... i can use that archive to restore my
exchange ma...more >>
SQL Server 2000 Posted by Bill at 9/8/2004 8:51:23 AM Hi,
I am getting and error message and need some help.
The message is
Unable to attach to SQL Server SQLSERVER as PSI. The server
maybe down or improperly configured.
Thanks in advance
Bill...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |