I have tried everything..I cant get Java to connect to my sql
server...port 1433 is what sql server is running off of..my password
and username are correct..ive tried the ip, comp name and localhost for
server name and I cant make a connection to it...

Situation:
We have some custom code running on microsoft great plains **under
terminal services** on a windows 2003 machine.
We have a program (running under great plains) that will run for about

Database: SQL Server 2000 Developer Edition SP3a
Frontend: MS Access 2000 and Access 2003
A Custm-built Medical Records Database
I am having a problem connecting to my SQL server with certain ODBC drivers

  My application is working fine with SQL Server 2000 ; but when I
change the back end to Oracle 9i it gives an error "Invalid
attribute/identifier" .
  Any help would be appreciated .

I am using a VB6 frontend to a SQL server 2000 backend. What is good coding
and development practice with regards to when to open/close any database
connections?  I am using ADO.
Do you always close the entire database link each time you close a

How does a File DSN locate the server specified in the file? I am trying to
find out if it used DNS or WINS. As I am hoping it is DNS as I can then add
an alias to redirect the cilents of an application, rather than having to
change the dsn on all the client pc's.

I am getting: Error connection to database:
java.lang.ClassNotFoundException:
com.microsoft.jdbc.sqlserver.SQLServerDriver  - i installed
http://www.microsoft.com/downloads/details.aspx?FamilyID=9f1874b6-f8e1-4bd6-947c
-0fc5bf05bf71&displaylang=en#filelist

While working on MsSQL 2000 I'm trying to update table on remote server
(Sybase)
Here is the description of remote table (Sybase)
IF OBJECT_ID('adm.TransClient') IS NOT NULL

I'm a newbe on SQL Server;
Here my problem is:
In Server Explorer I create a Data Connection to Nortwind. After Creating
the connection I can reach tables of this database.

Hi, are there any alternative JDBC driver that support windows authentication
for Microsoft SQL Server 2000 beside jTDS JDBC Driver and JSQLConnect Driver?
I have tested both of the drivers and I can't get the jTDS JDBC Driver
works. Is there any online guide on how to connect ...

Are previous versions compatible with later versions - i.e. a server with
2.71 communicates with a server on 2.8.
any known problems?

   My application runs fine when I am using SQL Server 2000 as its db, but
it gives a message  "Invalid attribute/identifier error" when the db is
Oracle .
  Any help in this matter would be appreciated .

Hi all, heres my problem.
I have written a C# ASP.NET app that uses SQL Server, everything works fine
locally.
To simulate a remote connection to SQL Server I tried the following connect

Hello, I am new to SQL and I would like to connect to a remote sql server.
I have Win 2k Professional installed at my PC and I have installation CD of
SQL Server 2000 Developer Edition.
I have chosen following options during installation:

I've set up an alias for my laptop-clone of the production server with
the same name as that server (since I work disconnected most often).
This has worked swimmingly in the past. I went into Client Network
Utilities, "Added" a new alias, set the protocol to TCPIP, specified