|
|
|
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 Named Pipes problem Posted by pogo at 3/7/2007 2:47:41 PM We have just installed SQL server on a Win 2003 server. We are getting the
following error message when we try to use it from the 2003 machine.
A connection was successfully established with the server, but then an error
occurred during the login process. (Provider: Named Pipes. Provider error ...more >>
Connect Error Posted by Demi at 3/7/2007 12:28:21 PM We have a SQL 2005 clustered server (Microsoft Cluster Services) that is
queried from 4 IIS6 Windows Server 2003 frontends. Each frontend runs both
classic ASP apps connection with SQL Server ODBC and .NET2 apps connecting
with System.Data.SqlClient. Ocassionaly we get a string of errors ti...more >>
Connection problems SQL Express Posted by Allan G. P. at 3/7/2007 3:01:16 AM I have a serious SQL Express connection problem on one of our customers
machine. The errormessage reads: "User does not have permission to perform
this action".
Our application is a .Net 2.0 Windows Application. Using the
System.Data.SQLClient.SQLConnection class to connect. The user is log...more >>
Path to exe Posted by Michael Tissington at 3/3/2007 9:45:29 AM I'm trying to automate opening the firewall for an instance of SQL.
For a given instance of SQL how do I find the path to the executable ?
...more >>
WMI and Instance Posted by Michael Tissington at 3/2/2007 6:35:51 PM The following code works ...
Set objWMIService =
GetObject("winmgmts:\\.\root\Microsoft\SqlServer\ComputerManagement")
Set colItems = objWMIService.ExecQuery("SELECT * FROM
ServerNetworkProtocolProperty WHERE PropertyName = 'TcpPort'",,48)
For Each objItem in colItems
objItem.SetString...more >>
Change existing application to use sqlncli Posted by Michael Tissington at 3/2/2007 3:17:37 PM I have a large application that currently uses SQLOLEDB as the provider.
The application needs to connect to SQL 7 thru SQL 2005.
I have tested changing the provider to SQLNCLI and everything still seems to
work.
I have a couple of questions ..
1) Is it really this easy ?
2) Can I sti...more >>
What is a best practice, Keep connection open, or Connect/Disconne Posted by Alfredo Becerril at 3/2/2007 11:00:10 AM Hi all,
What is a best practice,
Keep connection open,
or Connect/Disconnect in each sql statement?
I´m using visual studio 2005, c#.
Thanks in advance.
...more >>
cannot conect to sql server 2005 from xp client Posted by barry2007 at 3/2/2007 8:50:10 AM Newbie here,
I am trying to link tables from an access 2003 frontend to sql server 2005
backend.
I am doing this in a vmware test environment. I am using vmware server and
running sbs 2003 and xp sp2 client. Both virtaul machines can talk to each
other(using local host connection).
I...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Can not connect to some tables with seagate crystal report Posted by db at 3/2/2007 6:15:08 AM Seagate crystal reports:
When i am trying to attach a table to seagate crystal report i am getting
this error:
Database Error: [Microsoft][ODBC SQL Server Driver][SQL
Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
I can connect to other tab...more >>
SQL Express Command Options Posted by Michael Tissington at 3/1/2007 6:29:09 PM I'm trying to package SQL 2005 Express SP2.
1) How do I specify which TCP/IP port to use (instead of the default of
1433)
2) How do I automatically configure the firewall for the port specified
above
...more >>
How to add a Network Library Config (Server Alias) using Transact- Posted by Jamie_C at 3/1/2007 3:41:03 AM Hi,
I can create an Alias for a remote server fine using the Client Network
Utility (Alias tab, Add -> "Add Netwok Library Configuration" - TCP/IP,
Server name = IP Address, specify port number).
.... how can I accomplish the same thing using TRANSACT-SQL so I can create a
script which w...more >>
Connectivity between vb 6.0 and Sql server 2000 (data base is in Server) Posted by sudhir9992003 NO[at]SPAM gmail.com at 3/1/2007 3:36:23 AM Hai all
I am sudhir
I am facing problem to establish connection between vb 6.0 and ms sql
server 2000, ie data base is in Server. I want to make conneciton
between them.
please help me.
Advance thank you alll
...more >>
Access SQL Server from SOLARIS. Posted by Retf at 3/1/2007 12:00:00 AM Hi All,
I heve one system that need access SQL Server 2005.
This system run on SOLARIS 10.
Have any way to do this?
Thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |