coldfusion & mssql connection problem

[blackout2]

Trying to switch my coldfusion 5 site to the new coldfusion mx server.

For some reason, it kept giving me this error.
Error Executing Database Query.
Data source not found.

I have been using Coldfusion on NT12 for over a year, until they required all
coldfusion site to move to coldfusion mx server. So I know how to create db,
create odbc dsn, and all that. Coldfusion 5 code should work perfectly with
Coldfusion MX code. unless they have a different query method for MX ??

I was unable to connect to the original mssql database I created on NT12,
so I create a new mssql database under the new MX account and still giving me the same error.

This is my sample code i am trying to run.

<cfquery name="links" datasource="mydatasource" username="myusername" password="mypassword">
select id,link
from ref
</cfquery>
<cfoutput query="links">
#id# , #link# <BR>
</cfoutput>

Please let me know if the above code is wrong ?

[blackout2]

Thank you Carly! you are my Goddess. Fix my problem in less than 10 minutes from the time i submitted the trouble ticket.

[admin]

Carly does rock on tickets I have to give her that for sure..