|
|
|
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 |
Filter by week: 1 2 3 4 5 connectivity only installation Posted by marwan hefnawy at 6/14/2004 7:52:29 PM Is the "connectivity only installation" is equvilant to installing MDAC on
the client machines, or the "connectivity only installation" has more
functionality to do.
Thanks
...more >>
Multiple Port Configuration Posted by sbawa at 6/14/2004 2:50:01 PM Using the server configuration utility, I have configured my SQL Server 2000 box to listen on multiple ports: (ie (1433, 9000, 9001, etc).
http://support.microsoft.com/?id=294453
Now I would like to be able to tell a client to connect to the server through any of these available ports. How...more >>
Multiple Ports Open for the Same Connection Posted by dj_also at 6/14/2004 12:53:29 PM Is this strange: "SQL server listening on TCP, TCP, Shared
Memory." ? It's SQL Server 2000 on a dual-homed W2K DC.
I have two "listening on" records for every IP. Also, the
SQL Sever application is running on the first port using
the correct IP and port # and IP 0.0.0.0 is on the second
(di...more >>
Restoration of Server Posted by Henry at 6/14/2004 11:13:03 AM Thanks in advance.
I have a webserver with win2000 advanced server and sql server 2000 installed in one physical drive with different logical drive. I have back up everything into tape. After a hard drive failure, I restored everything into the new drive. The only different is that, the size of ...more >>
Bulk Insert problem Posted by Mike at 6/14/2004 10:35:24 AM Bulk insert report the following code after being
used for a period.
When this happens, we need to re-start the SQL Server
and then it will disappear for a while and then happen
again.
Any body have idea about how to work around this problem?
Server: Msg 7302, Level 16, State 1, Line 1
C...more >>
SQL 200 Server Connection with VB Posted by Sue P at 6/13/2004 2:47:52 PM
I hope this is the correct place to post this. I have a VB program that
is running on a server. It connects clients to a SQL database. All of
the clients are connecting except for one. This one will run the program
(so I know it is mapped to the correct drive), take the login info and
then t...more >>
Problem connecting to SQL Server over the internet Posted by John Kotuby at 6/11/2004 2:24:28 PM I have opened ports 1433 and 1434 on a SQL Server on our network to allow
our customers to receive a monthly subscription "key" for the software they
lease from us. Within an encrypted Stored Procedure I am using the
OPENDATASOURCE method with a connect string containing our IP address. It is
wo...more >>
Help required Urgently: Intermittent connection failures Posted by Nags at 6/11/2004 2:24:15 PM I am trying to connect to SQL Server from another box and I keep getting
this error intermittently.
DB-Library: Unable to connect: SQL Server is unavailable or does not exist.
Unable to connect: SQL Server does not exist or network access denied.
Net-Library error 10060: Connection (Connect())...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Create a SQL2000 Linked server to an EssBase server/cube Posted by EssBase Neophyte at 6/11/2004 2:06:02 PM Hello
Please forward any information that you might have on how to do this.
Thank you :)...more >>
Connect Error Posted by modori at 6/11/2004 11:56:24 AM Hi all.
Now, Sql Server is remote area.
I'd like to connect remote Sql Server, but i can't.
Remote IP is authority and 1433 port open.
Error Message is below.
"SQL Server does not exit or access denied"
Help me please!
...more >>
Connecting a node in cluster Posted by sarma pisapati at 6/11/2004 10:49:15 AM I have 2-node cluster. I can connect to the cluster from
enterprise manager. However, due to some reason, the
administrator wants to run enterprise manager connecting
to an instance on a node rather than cluster. How do we do
it?...more >>
database connections after the migration Posted by Kiyomi at 6/10/2004 3:57:29 PM Hello,
We are planning to upgrade SQL Server 7 databases to SQL Server 2000 on a
different server. There are many ASP and other applications running on the
current SQL Server 7 and pointing to its databases.
After the database migration, is there any way to make all the applications
to con...more >>
Same ODBC driver for SQL 7 & SQL 2000 ? Posted by E-Double at 6/10/2004 2:06:05 PM Does SQL 7 use the same ODBC driver as SQL 2000 ? After upgrading to SQL 2000 will the previous ODBC driver setups from SQL 7 still work ? Or do they have to be reconfigured/updated/or reinstalled ? TIA ......more >>
add a sybase server as a linked server to sql server 2000 Posted by SqlJunkies User at 6/10/2004 1:58:15 PM I have done a search on google and as of yet have found nothing to help me add a sybase server as a linked server on sql 2000. I really need the param string values to sp_addlinkedserver. We are running sybase Ase 12.5 on a unix platform. Here is my example
sp_addlinkedserver @server = 'myservern...more >>
VIA(giganet) Posted by Bill at 6/10/2004 12:36:53 PM We have just upgraded our servers and switch to Gigabit
ethernet equipment. We have a cluster running enterprise
edition of SQL 2000 and 3 sql servers running standard
edition. Is it possible to take advantage of VIA. The Via
(giganet) protocol/network library is only available at
this t...more >>
[DBNMPNTW]ConnectionOpen (CreateFile()). Posted by Motati at 6/10/2004 9:57:17 AM Hi,
When i tried to run insert statement ,i am getting below
error,please give your expert solutions.We are running
sqlserver7 on active/active cluster on NT4.0.
&&&&
[OLE/DB provider returned message: Client unable to
establish connection]
[DBNMPNTW]ConnectionOpen (CreateFile())
...more >>
Connection error after already connected Posted by Michael Beck at 6/10/2004 9:06:15 AM I am using Access 2002 as a front end and SQL Server 2000 as a back end.
After I have connected, I use ADO to run a process that gets ten different
sum queries from various SQL Server tables and writes the results to local
Access table. This loops thru 300 to 800 records.
The second time th...more >>
mssqlserverADhelper service terminated, Access Denied when trying to connect Posted by Steve Cohen at 6/9/2004 7:27:11 PM This problem just started recently. This computer connected to the database
when it was first installed. All computer are new Compaq running Windows xp
pro.
This is a problem with MSDE. We are running MS Retail Management system.
One Point of Sale station won't connect to the server. I am r...more >>
Re: [Shared Memory] ConnectionRead (recv()) ... error Posted by frk at 6/9/2004 5:43:07 PM Hi I've got error below when i ran a stored procedure:
---------------------------------------------------
[Microsoft][ODBC SQL Server Driver][Shared Memory]
ConnectionRead (recv())
General network error.
---------------------------------------------------
The same error occured in differen...more >>
Broken Linked Server Posted by Russ at 6/9/2004 1:17:37 PM Been running SQL 7.0 sp4 for 1 1/2 years on two NT4.0 sp6a
servers on the same subnet with no problems. ServerA is
linked to ServerB, and ServerB is linked to ServerA.
I haven't loaded any new software. This past Monday, all
the jobs on ServerA that use data from ServerB failed.
All th...more >>
timeout exception Posted by pmcguire at 6/9/2004 7:36:03 AM I have a vb.NET solution with a Windows Application project that contains my user interface and a Class Library project that contains (among other things) a class I call DataAccessComponent. This class inherits from System.ComponentModel.Component and contains a single SQLConnection object and a bu...more >>
Cannot register SQL server Posted by Edwin at 6/8/2004 7:17:34 PM Hi
It is the same old problem again but mine is a bit strange. I have read
other discussion on this problem but still cannot locate the cause.
I have a primary domain controller (PDC) running W2000 and SQL Server 2000
serving my main database. I have another W2k3 server running SQL Desktop
En...more >>
server name shows up twice Posted by Kiran at 6/8/2004 11:43:42 AM Hi,
We are running sql2000 on our server. our application uses
odbc connection to connect to these servers. Last week we
installed 2nd instance of sql on one of our server . from
all machines i was able to connect to the second instance
of sql except one. On this machine I couldn't see the ...more >>
Server appears twice / connection problem Posted by Dave Lewis at 6/8/2004 9:56:33 AM Hi,
When I try to register one of our SQL Servers in Enterprise manager the name
of the server appears twice, and which ever one I select fails to register.
If I enter the IP address of the machine then it registers fine.
However, when I try to connect to the server from a C# Application it ...more >>
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Posted by SqlJunkies User at 6/8/2004 7:52:09 AM We have a classic ASP application which runs fine on NT Server, W2K Server and with SQL7.0 and SQL 2000.
However, we are having problems with IIS6.0 and Windows 2003 Server when connecting to a second Windows 2003 Server running SQL 2000 Server. IIS6.0 and SQL on the same server works fine.
W...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |