I have 3 instances of SQL server currently on my machine.  The default
instance is MSDE 2000, I also have an SQL Express 2005 instance
\MACHINE\SQLEXPRESS and I have an instance of SQL Server 2000 Workgroup
Edition, named \MACHINE\WORKGROUP.  When I execute SqlBrowseConnect or

I have installed a mdac 2.6 on my client's Windows XP PC, but the ODBC seems
to be the same.
What do I need to do so the ODBC will be changed to the ODBC comes up with
the MDAC?

I hope that I'm right here.
We have an intranet-site in ASP where, till now the data was in an
Access database and we connected to the data via DNS.
Now we would like to change the data to a SQL-server.

on our server  we have a default SQL 2000 instance and also another MSDE
instance with the name server\instance1.
In one of my database of the default instance I would like to create a view
to the table from the another instance. I have tried with select statement

Currently, I access a database and table that is not the current
database using Admin..CASES
INSERT INTO Admin..CASES
(CASE_CODE,CASE_NAME,CASE_CLASS_PERIOD_BEG_DATE,CASE_CLASS_PERIOD_END_DATE,

MS Access (with ODBC) and vb.net on my PC read SQL Server tables fine.
I want to write a java program that reads SQL Server tables.  I can't
prompt the users for their user name and password because the
administrators only allow authentication through Active Directory.  Do

I am extremely new to all this.  I have just built a MSSQL 2005 server on my
lap top and want to make a simple JSP to pull from the database.  I used a
sample that came with MYSQL and everything works.  I need to get this to work
with MSSQL now.  Does anyone have a basic setup to ...

Until recently, we were using the jtds drivers to access our MSSQL server,
but now feel the need (for a reason that escapes me right now) to the MS
drivers (sqljdbc_1.1.1501.101_enu.exe).
Unfortunately, this version of the driver doesn't seem to support named

JBDC Newbie here,
Using MS SQL Server version 8.0, JDBC 1.1.
My connection is being refused.  Can anyone point me in the right
direction?

I use the following code lines for connecting to SQL Server 2005:
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String connectionUrl =
"jdbc:sqlserver://SERVER;user=USER;databaseName=db;AuthenticationMethod=auto";

It has  been over 5 years since I've had to use MS SQL.
I'm finding out the interface has changed and now I can't figure out how
to install the ODBC driver to a Server 2003 R2 box.
It's not where it used to be.

We have a IIS server running and this server is not part of the domain
on which the databaseserver resides. However, it is possibile to ping
the IIS-server from the databaseserver and vice versa.
I try to connect to the database with a trusted connection. What I have

I use the following code lines for connecting to SQL Server 2005 using
JDBC in Java:
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
               String connectionUrl =

We have noticed for a long time queries originating from Access 97 that had
very long durations when traced using SQL Server profiler (2000) .  Queries
that would complete in less than a four seconds in Query Analyzer showed
durations of twenty minutes and in one case two and a ...

Hi Everybuddy,
I have a strange problem with VB6/SQL Server 2K. I am calling a stored
procedure from VB using ADODB.Command object. When I check the incomming
parameters into the stored procedure, that values in named parameters are