I have this weird problem and hope someone can help me.
I have a SQL Express 2005 installed in a WIndows 2000 server. After the
initial installation, I can login into the SQL server using the SQL
2005 console. However suddenly, I no longer can login either using SA

I'm trying to create an application, which would say if sql server is
running on a machine.
Hope i can get this from windows registry. Is there any other way do
achieve this programatically through windows SDK , or checking the

Not sure where to put this post, hope this is the right place.
Relatively new to SQL, not sure what info you need, so here we go:  We
have a Windows 2000 Server running SQL 2000 ("Server1) in location 1.
This server is outside of the firewall.

I am using a 2003 book by Dan Maharry called "Beginning VB .NET 1.1
Databases: from Novice to Pofessional" ISBN 1-59059-358-8. I'm simply
trying to view my MS-Access database tables and stored procedures from
my Visual Studio .NET 2003 Standard Edition (VB).

until today, with sql2000 i get recordsets connecting with
       "Provider=sqloledb;Data Source=myServer;Initial
       Catalog=myDB;Integrated Security=SSPI"
but now, having migrated to sql2005

I know there is one sql script "SELECT TOP n ..." only in the SQL
Server, but what's the difference of the "SELECT TOP n " script,
Statement.setMaxRows() and Statement.setFetchSize()? Thanks a lot.
Regards,

I can't connect to a server that's running on my machine.  I can't even
connect to it through Enterprise Manager. Im in big trouble. Can somebody
help?
I think this is happening because I had granted access to another database

I'm using the 2005 driver against an instance of SQLServer2000. The following
works just fine:
PreparedStatement s = conn.prepareStatement("select s.spid from
master.dbo.sysprocesses s where dbid = ?");

can anyone help me, please. thanks in advance.
i have installed sql server express 2005, and have a .mdb database in access
2003. with the upsizing wizard i have succeeded in connecting to a sql
database.

hi..
SQLConfigDataSource( NULL ,                            ODBC_ADD_DSN ,
    "SQL Server" ,
    "DSN=DBVoip\0"

I've got a web server running Windows 2000 Server that I need to make an
ODBC connection to a new SQL Express 2005 server running on Windows Server
2003. Using every logical combination I can think of I cannot make an ODBC
connection from this web server. I've tried this from ...

I recently added a new login/pwd for a database I couldnt connect through my
asp application. Now I can, which is nice. But, now I can't connect to other
databases. I have an adp project and when I try to pull it up, I get the
message that there's a problem connecting. I do get ...

username:  Jeff.Mitcham password:Abc1234
IP of the server is 202.138.138.73
Thanks,
Michael

I have two machines and same problem.
I installed SQL EE on XP HOME EDITION it is OK !
Localy work OK !
I try to connect from another machine with SQL Server Management Studio and

I've got a SQL 2005 with an odbc connection to a PROGRESS database. We can
transfer data from the progress to the sql but there is 1 field we can not
transfer. This field, proclaimed by the PROGRESS administration, is a field
wich can contain an empty string or up to 8 characters ...