I have SQL Server 2000 running on a Win2000 server, and MSDE 2000
running an XP Pro machine (named ASUS).  I also have two client
machines from which I wish to connect to both of these.  All 4 machines
are in a workgroup, not in an domain.

I have a small workgroup of computers (4) all running windows xp sp2.  One
of them is running msde2000. I can connect to a named instance of sql server
but can not connect to the default instance.  I am using osql and using
trusted connection.  I am not sure what other ...

I have a linked server to an Oracle 8i database.  When I attempt to query the
Oracle tables I get the following error:
Server: Msg 7317, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' returned an invalid schema definition.

using access 2000
how i can link a table from sql server by code?

I'm running MSSQL2k on a Win2k box used as a webserver.  I imagine that
using a "localhost" type of connection would be faster than referring to the
server name and thus invoking the DNS lookup.  The connection string I am
using as an ASP include is:

I am attempting to connect SQL to a SQL page.  I get the following error:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'SQLSERVER2\IUSR_SQLSERVER2'.

Hi,
    I have recently started using the JDBC MS-SQL driver. I am facing a
problem with the setdate() function of the prepared statement.  if we are
using the setDate function of the prepared statment then the date gets

Hi. I have a database established by MS SQL, and I want to make online
queries to my database over the net by a GUI developed in Visual Studio .NET.
Could someone explain the procedure I must follow to accomplish such an aim.
I mean that database is in the desktop computer in my ...

In the past, I needed to add the 'use pubs' prior to my select * from
employee statement when accessing the pubs database on my sql server.
Now, when I add it to my sql statements in my programs, I get only a
few of the fields instead of all of them.  

After an office move (accompanied by IP Address changes), I can no longer
use Windows authentication to connect to one of my SQL Server machines.
Nothing else seems to have changed. This is an example of what I am facing.
For simplicity, I conducted this with Query Analyzer, ...

When using windows authentication mode should should the connection work if
the server and client are logged on to windows using "this computer", or must
they log on to windows using a domain account - i can't seem to connect using
windows authentication, only with a sql account

Have an APP running IIS on one box and SQL on a Win 2K3.  
When running through a browser located on a completely
different box (double hop) the credentials get lost (as
designed by MS) and user is only known as Anonymous.  

I used Resin to connect SQL Server 2000, but it spent almost 1 minute when I
connect it as follow:   Why???
con =
DriverManager.getConnection("jdbc:microsoft:sqlserver://wks01:1433";User=tes

one of our users gets an error message when trying to connect to our SQL
Server database:
Connection failed:
SQLState: '28000'

If IIS cached a logon just for one particular page, but not for other pages
performing the same logon, is that normal?  I know it sounds bizarre but I
have an ASP page that makes an ADO connection to MS SQL Server.
Authentication on SQL is set to SQL and Microsoft.  ...