Groups | Blog | Home


Archived Months
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
all groups > sql server connect > december 2005 > threads for december 15 - 21, 2005

Filter by week: 1 2 3 4 5

Login time out
Posted by Bernhard Wurm at 12/20/2005 2:59:16 PM
Hello together, I've got the following: SQL Server 2005 Express & SQL Server 2000 The sql server 2000 has got a database with some tables, which I want to show as view (readonly) in the sql server 2005 express. Now I did the following: I added a linked server to the sql 2005 I've choosen ...more >>


can not connect to local sql server 2005 express through jdbc
Posted by steven at 12/19/2005 3:34:01 PM
I was not able to connect to local sql server 2005 express database through the ms jdbc driver, my local sql server 2005 server name is: DENLAP0059987\SQLEXPRESS, my java code is following: .... Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); DriverManager.getConnection...more >>

Windows Authentication issue with SQL Server 2005 and Visual Studio 2005 webservices
Posted by glenn field at 12/16/2005 10:59:42 AM
I am implementing my first webservices with Visual Studio 2005 with connections to SQL Server 2005. Here is the problem I am experiencing. When I try to execute code for the webservice (local or remote) I get the page returned with the primary error: System.Data.SqlClient.SqlException: Lo...more >>

Connection
Posted by Mathew at 12/16/2005 7:04:03 AM
Hello, I don't know why i can not connect to a remote Sql server in my Enterprise Manager, While i can do it through Query Analyzer. Thanks...more >>

SQL 2000 server + windows xp client
Posted by Kitty at 12/15/2005 11:42:02 PM
2 servers SERVERA & SERVERB, are both SQL 2000 SP3a on Windows 2003 server. Named instances. Use tcp and named pipes. Everything worked fine when my desktop was Windows 2000 before. I upgraded my desktop to Windows xp sp2 last week and then i started to get the "SQL server does not exist...more >>

Joing tables from different databases - performance issues
Posted by MerlinXP at 12/15/2005 1:00:15 PM
Hello, What is performance difference between joining tables 1. from the same database 2. from different databases located on the same instance of MS SQL Server 3. from different databases located on different instances of MS SQL Server (linked servers) when these instances are locat...more >>

Connection Issue
Posted by mvp at 12/15/2005 11:33:02 AM
Hello EveryBody, If SQL SERVER is configured as a Maximun concurrent user connections = 1 (I know 0 = unlimited) in Connection tab of server property ? Who will able to login to server ? Because i have a similar case and not able to login with any other sql server Login. Is SQL SERVER ad...more >>

Aggregate Function Error
Posted by Preacher Man at 12/15/2005 8:13:10 AM
I am having a problem with a query statement when I try to use sum( ) on a field in the query. For example: select somast.fsono, somast.forderdate, somast.fcompany, sorels.fduedate, sum(fnetprice) from somast inner join sorels on somast.fsono=sorels.fsono where somast.fstatus<>'CANCELLED' ...more >>




DevelopmentNow Blog