|
|
|
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 MSSQL 2000 & two nics Posted by Pavel Balus at 3/20/2005 2:25:50 PM Hello,
How can I select IP address(es) for listening of MSSQL on server with two
(or more) nics?
Thank you for ideas.
Pavel Balus
...more >>
large union query Posted by Loane Sharp at 3/18/2005 10:49:33 PM Hi there
I have a large union query that produces a "timeout expired" error. I've
changed the timeout settings to 600 seconds but I still get the message.
My query and underlying database are characterized as follows:
a) two fairly large database tables (1.5m and 0.7m rows respectively)
...more >>
can't access server Posted by js at 3/18/2005 10:09:14 PM Hi, I'm having problem with a workstation connecting to the Server's SQL
Server. The workstation can access the server's hard drive via share and
TCP/IP seems to be working. But the workstation just can't access the
server.
how to tack it down? Thanks.
...more >>
Java servlet, tomcat, SQLServer Posted by hide.me NO[at]SPAM nowhere.com at 3/18/2005 12:49:50 PM Are there any standard things to check for when using SQLServer with JDBC
and tomcat/java servlets?
We have an application with an unreasonably large memory footprint. The java
programmers swear it is an SQL Server memory leak. I can't see a similar
problem when we use other methods to access ...more >>
Connection Problems to Client Sql Server Posted by Cornelius Wipf at 3/18/2005 6:19:06 AM Hello,
I am using a front end VB application to connect to sql server desktop
engine. Connecting to the (local) server work perfectly. However, I need to
connect to a sql server on a machine on my network that is also running the
sqlserver destop engine and access a database on that computer...more >>
Foxpro Linked Server Using Enterprise Manager Posted by Martin Barrett at 3/18/2005 4:27:03 AM Hi,
I am struggling with what surely should be a very simple process. I am
simply trying to establish a basic linked server connection to a number of
foxpro dbf files.
What is the required syntax within Enterprise Manager for both the ODBC
version and the OLEDB version?.
I have tried ...more >>
How do File DSN find the server Posted by Russell at 3/18/2005 3:25:02 AM How does a File DSN locate the server specified in the file? I am trying to
find out if it used DNS or WINS. As I am hoping it is DNS as I can then add
an alias to redirect the cilents of an application, rather than having to
change the dsn on all the client pc's....more >>
How Do I test a SQL Server Connection? Posted by nick at 3/17/2005 8:21:46 AM Hi all, heres my problem.
I have written a C# ASP.NET app that uses SQL Server, everything works fine
locally.
To simulate a remote connection to SQL Server I tried the following connect
string...
myConnection = new SqlConnection ("data
source=xxxx,xxxx,xxxx,xxxx,1433;Network=DBMSSOCN;In...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Login Problem Posted by Arif Çimen at 3/16/2005 7:39:11 PM Hi everybody,
I'm a newbe on SQL Server;
Here my problem is:
In Server Explorer I create a Data Connection to Nortwind. After Creating
the connection I can reach tables of this database.
But: When I want to configure the dataAdapter the problem occurs:
In the configure wizard "Data So...more >>
Database and Recordset Connections Posted by David Oberer via SQLMonster.com at 3/15/2005 7:35:14 PM I am using a VB6 frontend to a SQL server 2000 backend. What is good coding
and development practice with regards to when to open/close any database
connections? I am using ADO.
Do you always close the entire database link each time you close a
recordset, or only at the end of the application...more >>
Protocol Error in TDS Stream vs Network Packet Size Posted by Gavin Chan at 3/15/2005 6:51:02 PM We encounter the 'Protocol Error in TDS Stream' error in Excel that connect
to SQL Server 2000 (SP3) with MS Query. We later found that this occurs when
the user select too many fields from the MS Query Designer.
Interestingly, we later found that this can be fixed by enlarging the
'Networ...more >>
OLE/DB provider returned message: Invalid authorization specification Posted by Eric Spijk at 3/15/2005 5:41:20 PM Hello,
I'm trying to import a table from a MSDE database (databaseB) into a SQL
server database (database A).
Using to following sql statement:
insert tableA
select a.*
from openrowset(sqloledb,'Provider=sqloledb;Password=pwd;User ID=usr;Initial
Catalog=databaseA;Data Source=server', se...more >>
Alternative to Microsoft Enterprise Manager? Posted by Victor at 3/15/2005 3:18:33 PM I can't use Enterprise Manager - I've got a cable connection and Comcast
blocks port 1061 which EM uses.
Anyone know a browser-based alternative to EM (preferably written in ASP)???
Thanks!
-Bill.
...more >>
Invalid attribute/identifier error Posted by ghosh.sujay NO[at]SPAM gmail.com at 3/15/2005 7:10:05 AM HI ,
My application is working fine with SQL Server 2000 ; but when I
change the back end to Oracle 9i it gives an error "Invalid
attribute/identifier" .
Any help would be appreciated .
Thanks ,
Sujay
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |