I've been doing a lot of research on the best way to integrate SQL Server
2005 and Access.  Many of Mary's suggestions to others lead me to these
decisions, so maybe she will comment?  What I've learned has lead me to the
following conclusions:

For SQL Server 2000, if the stored procedure threw an error and there
was a result set available, the return code from the ODBC call
SQLExecute was SQL_SUCCESS_WITH_INFO. However, with SQL Server 2005,
return code is SQL_ERROR. Has anyone else encountered this problem? Is

I have a  new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there  is no (local)
entry in drop-down "server Name" list. However the actual server name is

We are using JDBC to connect to a SQL Server 2000 database using JDBC.
We're having an odd problem, and I cannot find anybody else who is
having this issue.  The application server machine (WAS 6.0) is eating
up ports and generating SQL Server processes like there is no tomorrow.

My Windows XP client machines are using MDAC 2.8 SP1 to connect to a
clustered SqlServer 2005 database. SqlServer definition says null values are
acceptable in foreign key columns. But MDAC 2.8 SP1 says nulls are not
accepted. The same application connecting to the same ...

I have attempted to establish ODBC connections w/ the Microsoft SQL
Native Client Version 09.00.1399 (from 2 different machines) and get the
following error:
Connection Failed:

Good morning everyone,
How can I connect set up a TCP/IP connection to a SQL Server 2000 without
using MDAC??
Thank you

SQL 2000/SQL 2005(see below) running on Windows 2003 sp1, web server running
IIS 5.0 on Windows 2000 sp4.
Sometime in the first week of every month since at least Nov 2005, I get an
Dbnetlib connectionopen(preloginhandshake()) error. Connections to the

We use MSDE SP3a and are having a strange problem.
We have an ADO-based application that fails depending on the domain
that we use to login to the machine. It works   if I login to DOMAIN_A
but it fails to connect to the server if I am physically logged in into

I am trying to linka MySQL database to SQL 2005, but I am not sure what I
need to do.
I have set up a DSN using the MySQL driver. I get lost when I try and create
the linked server in SQL 2005. Can someone please outline the steps to create

I have TCP/IP enabled as a supported SQLExpress protocol.
There are three Active, Enabled IP addresses defined, and they are:
IP1: The DHCP assigned address on port 1433
IP2: The 'Default' localhost address (127.0.0.1) port 1432 (changed to this

I am trying to connect to a SQL 2005 Database from VB 6.0. If I use windows
log on all works well. If I try to use SQL server logon I always get this
error:
(Login failed for user '<LoginName>'. Reason: Not associated with a trusted

All,
I am using jdbc driver for sql server 2005 on weblogic/websphere, following
is the configuration I am using.
driver class : com.microsoft.sqlserver.jdbc.SQLServerXADataSource

When linking a SQL server 2000 table to Access 2003 using the standard MS
ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
are blank in Access.  
If I use a DataDirect ODBC driver the money fields are displayed correctly.

I have followed the installation instructions provided with the released SQL
2005 JDBC driver but adding a user to the SqlJDBCXAUser role doesn't work as
advertised with the released version of SQL 2005 or I don't understand how it
should work.  The install script defines the ...