I'm trying to connect to SQL Server using the string 'localhost', but I
always get a timeout error using either Query Analyzer or ADO. But if I
change the string to 127.0.0.1, it works.
A 'nslookup localhost' returns 127.0.0.1. If I run 'telnet localhost

can i use setString() for a text type column in the prepareStatement sql?Like
this:
create table cmm(test text);
PreparedStatement pstmt = null;

import java.sql.*;
public class SqlTest
{
 public SqlTest() throws Exception

Is there a way to use Windows Authentication  to log on to an SQL server
instance accross a peer to peer network without a Domain?

   Can we remote connect MSSQL 2005 express with IP address?
If can how to done it?
With regards,
Goh

Trying to make a new database project using VS2005 pro and SQL2005 dev (in
my local machine), I get the following error and the project can't be made:
"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be ...

I have 2 SQL Server 2005 machines each with a .NET2 web app.
Machine #1 is Windows XP
Machine #2 is Windows 2003
When I use EM on Machine #1 to connect to both instances everything is fine

Seem to be getting these consistantly in certain portions of our application.
Works fine with the older JDBC driver (2000) but under the 2005 driver we
see....
com.microsoft.sqlserver.jdbc.SQLServerException: Unsupported conversion from

We are testingn our DbVisualizer tool with:
Microsoft SQL Server 2005 JDBC Driver - Beta 2
Version: 1.0.419.102
The problem is that Driver.getPropertyInfo() method seems to return

I am having a problem with JDBC 2005 Beta when comparing against an empty
string.
tate  : S1093
Message: Index out of range1  Valid range is 1 to 0

Does anyone know when Microsoft is planning to release the RTM version
of their SQL Server 2005 driver? The link at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx
is only for the beta2 version

We just upgraded from SQL 2000 to SQL 2005. To do so we had to uninstall SQL
and install 2005 from scratch.
The problem now is we get this error:
Msg 3910, Level 16, State 2, Line 1

Does a client that connect to an SQL 2005 analysis services always need .NET
framework 2.0 installed?
Regards
Clarkie

I have a Window 2003 SBS with SQL installed (SQL 2000 includet in SBS).  
Everything worked fine for a long time, but now the SQL server starts but the
SQL agent doesn't start even manually.  When I try to start the agent it is
trying to connect but it doesn't.  In the log it says ...

I have two DataBases on different SQL2000servers, I have linked them both,
and what I want is, when a record is created on one DB it must create the
same record on the other DB. If the DB's are on the same server the trigger
works fine, but when they are on different ...