Pete,

There are a lot of things that you have been able to rule out as problems. I have a couple of suggestions below, looking at the issue from a...

Checking with the driver vendor, good show! Now on to the next technical hurdle ...

Ah yes, OPENQUERY ... let me grab my notes ...

You are really close ......

I am thinking that there may be a problem with the Access 2000 front end. You seem to have exhausted issues with the SQL Server backend.

These are areas I...

pete.doyle,

You have checked the SQL Errorlog, which can give spotty information at best. You can also check the Windows Event Logs (Application, Security and System) for the same time...

Ziljan4,

I typically just don't want the SQL Server version. I use this script:

-- Show information about all SQL Server Databases in a given instance.

-- SQL Server 2000

-- SQL Server...

lijusmail,

When you create your ODBC connection (whether or not you create a User DSN, System DSN or a File DSN) to the CMIS system, you will chose either the SQL...

Paul,

It looks like you are on the right track. It is good news if your System DSN tests successfully in the ODBC Admin tool.

The syntax *always* gets me with...

PaulSp,

I have not worked with Interbase systems and I am not sure if you would need an Interbase client install on your SQL Server machine.

If there is not an Interbase...

raym,

I second the recommendation to verify your MDAC components.

Troubleshooting Guide:

Component Checker: Diagnose problems and reconfigure MDAC installations

http://support.microsoft.com/kb/307255/

You can download the MDAC Component Checker software tool here:

MDAC Utility: Component Checker

http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

The...

jschroeder

There is a negligible of a performance hit when enabling Database Mail. You can...

You can create an SSIS (SQL Server 2005) package that runs an "Execute DTS 2000 Package Task" around an existing DTS (Sql Server 2000) package.

**Note**: The SSIS package...

jschroeder,

It is always nice to see someone that has been thrust the crown of thorns that is the role of DBA/Developer, and you have accepted it with open arms and...

SELECT Response

FROM Emotes

WHERE HeadMovement = 'Nod'

Adam,

Thanks for catching that. I corrected my posting.

I use the script below:

-- Author: Damon T. Wilson

-- Creation Date: 13-DEC-2006

--

-- Runs on SQL 2000.

-- Runs on SQL 2005.

SELECT name AS NameOfFile,

size/128.0 as TotalSizeInMB,

CAST(FILEPROPERTY(name, 'SpaceUsed' )AS int)/128.0 AS SpacesUsedInMB,

size/128.0...