we are having serious problems with an application that uses an ODBC
connection (System DSN) to a SQL Server in another subnet. The network is
fine, all network tests reveal nothing of consequence. However, the problem
does not appear when SQL server and client are in the same ...

I am having a pretty serious problem and I tried almost every thing (I
know…) but still with no success.
There are 2 computer on a workgroup (lets call them A and B). On A there is
an MSSQL Server 2000 with windows and QSL mixed authentication on Windows

Is it possible to load out an older version of MDAC i.e., 2.6 sp 2 on an XP
box which has 2.7 or 2.8?
Can the two co-exist?  

i have this code:
package com.milsoft.mvp.persistance;
import java.sql.*;
import javax.naming.*;

I have a new SQL Server installation on a remote dedicated web server server
hosting several websites.
If I use Remote Desktop, I can log in on the server and perform any DB task,
using any of the created logins without any problem.  I can use Enterprise

I have a VB application that is running fine in prod on a box without
the .net framework installed. The app queries a Oracle 8.1.7 64 bit
database. It uses the Microsoft ODBC Driver for Oracle and it works
like a champ. However I am adding some enhancements to this application

Hi I am a newbie so I will try to describe my situation below.
I purchased a Server running Windows 2003 and installed SQL 2000 with SP4.
The server is hosted in a co-location building at my ISP. I have terminal
Server access. I have a application that I will use to connect thru the

I am using VS2005 with sql server 2005 express.
I have database with atached datafile. when I am using Select command from
created table, there is not case sensitive in the result. I mean I have in
the table the row with value "Disp1" in col1, and when I am selecting with

I am unable to connect to a SQL Server on our network. I was able to
connect to this server until recently. I am not /aware/ of any changes
to the server or to the client that could have affected this, however,
the server was not responding to pings this morning and had to be

I have just created some DTS package wich pump data from Visual FoxPro
database to SQL Server 2000.
Everything works fine when I execute de package on my local machine or any
other machine that aren't servers.

Good day. I had my XP Pro PC hard drives formatted to NTFS but when I built
the 98SE PC it could not read the shared files from the XP PC. I
re-formatted the drives on the XP PC to FAT32. Does the PC on which SQL
Server 2000 is installed require the NTFS formatted hard drives? ...

I have an intriguing problem and I wanted to see if somebody could help me.
ENVIRONMENT:
Server Side: 2 identical Windows servers 2000 with SQL Server 2000
Enterprise Edition SP3a

Can I use integrated security in an ODBC connection string without using a
DSN?
If so, what would the syntax be for SQL Server and Oracle (if supported by
Oracle)?

I use enterprise to connect one SQL server from my pc, get the following
errors: access deny and connection fail, but, I can use my another server to
connect it, same setup, any suggestions?

We are trying to troubleshoot a complex issue with SQL server 2000.  We have
been using an *off the shelf* application for the last 6 months that is used
for portfolio management.  The application is written in ASP and the database
is SQL 2000.