ColdFusion DataSource not found

Question

I'm trying to connect ColdFusion 8 to SQL Server 2008 Express and I'm experiencing some issues when I try and run CF queries. When I try and run a query I get: (data source name removed, I didn't use [Name])

Datasource [Name] could not be found.

The error occurred in [FilePath]: line 1

1 : <cfquery name="tasks" datasource="[Name]" >

DATASOURCE [NAME] Resources:

The CF configuration pages show the datasource as being created correctly and verifies that it's able to connect. I set my database into 2005 mode to (hopefully) increase compatibility because SQL Server 2008 wasn't out at the release of CF 8.

Anyone have any idea why it can't find my datasource?

Answer 1

What's the datasource name? You say you don't use [Name] - is it Resources? Have you tried calling it something else?

Answer 2

Forgive me, I'm obviously new here. I had the wrong datasource name. It was off by a character. I'll go wallow in my own shame now.

Thanks.