I don't believe the statement that Outlook 2003 is not MAPI compliant.

I have 3 SQL 2000 servers on Windows 2003 running SQL Mail using the Outlook 2003 client that shipped with...

Create and test an ODBC DSN connection using the Start | Control Panel | Administrative Tools | Data Sources (ODBC) menu selection.

In Access or wherever you are creating the DAO...

Since this is a Jet provider and MDAC stopped supporting the Jet ISAM files in v2.5, I suggest that you download and install the latest Jet4 Service Pack (v8, I...

I cannot suggest any explaination for the IS NULL behaviour, however since you say that CRID is varchar(3) and BOL states:

ISNULL ( check_expression , replacement_value )

check_expression

Is the expression to be...

I use Visio for Enterprise Architects that comes with Visual Studio for Enterprise Architects (VERSION 6, 2002, or 2003).

It has the ability to reverse engineer an existing database and convert...

In ADO you can access multiple recordsets using the NextRecordset method, re:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthnextrec.asp

Andy

You can pick and choose what you need.

if exists (select * from sysobjects where id = object_id('Category') and sysstat & 0xf = 3)

 drop table Category

GO

CREATE TABLE Category (CatID int not...

You could use 3 input parameters for your Stored Procedure, @CreateTable varchar(1000), @InsertTable varchar(1000), @SelectTable varchar(2000)

Then change the code like:

SET @DDL = @CreateTable

SET @sql = @InsertTable + ' ' +...

Noel,

Since this is a FULL OUTER JOIN the problem was in:

SELECT turnover.client

 , turnover.[year]

 , turnover.[month]

 , turnover.turnover, costs.costs

Caused the costs fields not being included in the output, so using COALESCE caused both...

I think that you will find that the reason is in the ADSDSOObject, re:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/ldap_dialect.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;269361

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/example_code_for_using_ranging_to_retrieve_members_of_a_group.asp

Andy

Depending on the version of Oracle, you might have to use:

UPDATE p

   SET p.name=m.name

FROM tabl p , tab2 m

WHERE p.number = m.number

Andy

I posted a script that does this whole task for my Developers, plus it uses the backup date to uniquely name the database, so it will not overwrite older versions...

I suggest that you look at using ADODB.Stream:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjstream.asp

...

Dim oST As ADODB.Stream

...

For Each fldColumn In rstImportedTable.Fields

  If fldColumn.Name = "Icon" ' change this for your Blob field name

    Set oST...

Why not output your DDL to a .SQL file on the other server and run it on the other server using OSQL?

Andy

Try:

SELECT COALESCE(turnover.client,costs.client) AS Client

 , COALESCE(turnover.[year],costs.[year]) AS [Year]

 , COALESCE(turnover.[month], costs.[month]) AS [Month]

 , turnover.turnover, costs.costs

FROM turnover

 FULL OUTER JOIN costs ON turnover.client = costs.client

  AND turnover.[year] = costs.[year]

  AND turnover.[month] = costs.[month]

Andy