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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
|