It probably won't help, but try it without the username and password. They are unnecessary.
You might be confusing the table name with the datasource name. Why don't you run the following code to verify the names of all the datasources:
<cfset adminObj = CreateObject("component","cfide.adminapi.administrator")>
<cfset adminLogin = adminObj.login("my_cfadmin_password")>
<cfset datasourceService = CreateObject("component","cfide.adminapi.datasource")>
<cfset datasources = datasourceService.getDatasources()>
<cfset datasourceList = structkeylist(datasources)>
List of datasources: <cfoutput>#datasourceList#</cfoutput>
I figured out what the issue was.
I had both Coldfusion 9 and Coldfusion 10 installed. It appears I was getting the database connected with Coldfusion 9 but then I was building and running on the coldfusion 10 server. Uninstalling coldfusion 9 and ensuring the datasource was connected to the coldfusion 10 administrator resolved the issue.
A curious one for the books! Please mark it as answered.