Our applications (day-end jobs) sporadically get the following errors
(usually between midnight and 1 AM):
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
[Microsoft][SQLServer 2000 Driver for JDBC]Address in use: connect

how can I create a Form with a Datasource of two tables.
Regards
cucmejc

I created the below script to track my linked servers.  I set it up that it
would record a record for each server along with all its corresponding
databases.  Unfortunately, I have not been able to successfully track a
server which is offline.

I'm administering serveral sqlserversin our company.
Most off the servers are in different domains. For the Enterprise Manager
that's no problem, you can register any server with it's ipnumber or name.
But on all the servers which are not in the same domain, it's security log

I have an application running on a MSSQL Server on local machine, but the
service has failed to start all in a sudden.  It has been working fine for
months.  All i got is this error message.
I tried to use the administrator account for the "Log on service"  rather

Hi, I created a simple VB.NET 2003 application through Visual Studio
that connects to a MySQL database and loads a table into a Dataset, and
then displays that table information in a DataGrid on a form for
editing.  The table fill works fine, the delete function works fine, but

I would be very thankful if anybody could help me with this:
If there is a date field with a null value it defaults to 1.1.1900
is it possible to change the default  to the empty datevalue or '  /  /   '
Thanks

Although it worked great for years when built with VS 6.0
class CMyRecordset : public CRecordset  // derive a class from CRecordset.
(actually the IDE does this for you)
{

I'm using SQL Server 2000
I'm trying to store a database to a test database as I have done in the
past, now I'm getting an error message saying "Exclusive access could not be
obtained because the database is in use. RESTORE DATABASE is terminating

I get the following error:
Server: Msg 11, Level 16, State 1, Line 1
General network error. Check your network documentation.
Need help.

I downloaded and installed SQL Express 2005 (Beta 2). I want to create
tables and see whether I can get the data from the trivial windows based
application or web application I will be building in C# using Visual Studio
2003.

If I log on to the master database in an SQL server, is there a way for me
to tell if a non-master database has any connections to it?
VB6
ADO

i have win xp pro Sp1 in SBS domain.
When i try to connect with sql server using ODBC i receive the following
error SQLState 08001 - SQLState 01000 with sql error 17 and i can't to
connect with DB. Until last week my odbc connection work ok, and now if i

I am connecting through ole db from Powerbuilder to Ms Sql Server 2000.  
Powerbuilder is not recognizing the column defaults which leads to problems,
especially for inserts.  Has anyone run into this and can you help me out?

I have SQL Server SPK3 and Visual Studio.NET running on the same machine.  
When I try to connect to my SQL Server from the VS.NET Server Explorer I can
expand the server and look at the SQL Server instance on my computer but when
I try to expand the instance, I get a login dialog ...