SQL Server Datasource not found error

[4midori]

Hi, I have a SQL Server DSN that verifies and looks fine in CF Adminstrator,
but when I try to call it, I get Data source kidsroe could not be found.
The error occurred in C:\datafiles\C-WEB\kidsroe\site\admin\cfcs\customer.cfc:
line 13 Called from C:\datafiles\C-WEB\kidsroe\site\admin\index.cfm: line 10
Called from C:\datafiles\C-WEB\kidsroe\site\admin\cfcs\customer.cfc: line 13
Called from C:\datafiles\C-WEB\kidsroe\site\admin\index.cfm: line 10 11 :
<cfset Var customerRec=''> 12 : 13 : <cfquery name='companyRec'
datasource='#request.dsn#'> Please advise, thanks.

[vkunirs]

Hi

Here you are getting DSN name from a varaible #request.dsn#.
check that is that dsn name is correct by displayng it.
<cfoutout>=#request.dsn#</cfoutput>

[4midori]

Hi,

The dsn name is correct, thanks.

Anyone else? {{BUMP}}

[jdeline]

You may have an unprintable character in your dsn. Len(dsn) will tell you if you have a spurious character.

[4midori]

Hi,

I hereby crown myself with the IDIOT tag. I had CF6 and CF7 both installed, and I confused the two.

Sorry to waste everyone's time.

So, how about that cold snap?!