I discovered that IIf statements always evaluate all paths, even if a path is not going to be executed. So even though I check to see if a field...

Well, one problem with your code is that if Item is not present in the array, it will continue past the end of the array. Then you would get...

Thanks Matt -- I was able to create an ODBC data source using your excellent instructions.

However ... when I try to import it into SQL Server using the NET ODBC...

Scott: if I open it in notepad it looks kind of like this:

CDSCODE C ...

Well ... Here are my only choices:

Net Framework Data Provider for Odbc

Net Framework Data Provider for Oracle

Net Framework Data Provider for SqlServer

Flat File Source

MediaCatalogDB OLE DB Provider

MediaCatalogMergedDB OLE DB Provider

MediaCatalogWebDB...

Yes, this seems to work Greg! Thanks very much.

Thanks for the update on the trigger, Tommy, but Greg's solution seems to be easier :)!

OK, when I try to run this, it's telling me: Must declare the scalar variable "@data".

What is "@data" supposed to be? (Remember, I am really ignorant here!)

Oops -- dumb error!  I was trying to update a table that had nvarchar(4000) instead of the one with ntext. It actually does...

I did try nvarchar(max), and still it would only allow 4000 characters.  That made me assume that the "max" was 4000.

I will check books online and see what they say.

Thank you -- the information in that article is exactly what I need.

Cynthia

OK, you may be right that the backup order was wrong, because when I start over, doing a full backup, and two differential backups using INIT for the differential backups,...

I discovered the problem.  In my differential backup

BACKUP DATABASE AdventureWorks

TO DISK='C:\SQL2005_Backups\AutoBackups\AdventureWorksDiff.bak'

WITH DIFFERENTIAL, INIT

I should not be using "INIT".

I thought that since you just use the last differential backup file, it...

So ... I should do WITH RECOVERY for both full and differential?

I just tried it -- now I get this error:

Msg 3117, Level 16, State 1, Line...

I discovered the problem -- actually, someone on the MSDN forums enlightened me to it.

Apparently, the code does not get compiled until the report is deployed.  I had not deployed...

I already tried that -- that's how I originally had it, and I added the Public and Shared to see if it made a difference (it didn't).