Help!! Need to get the MSDASQL provider in SQL 2005 EE 64 bit

I understand that the MSDASQL.dll is not available in 64 bit (unless you are running 2008 beta 3). I also understand that you can setup 32 bit ODBC without issues (using ODBCAD32.exe in WOW directory). My issue is how does SQL 2005 64 bit see these ODBC links? What is everyone doing to get around this? I want to be able to use openquery. Any advice would be much appreciated.

Carlton

I have also tried using the IBMDADB2 provider but im getting an interesting message of access denied.

sp_addlinkedserver @.server = N'name', @.srvproduct=N'sourcename', @.provider=N'IBMDADB2', @.provstr=N'DSN=sourcename'

Error using a select statement

SELECT *

FROM OPENQUERY (Name,'SELECT * FROM Database.table')

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "IBMDADB2" for linked server "sourcename" reported an error. Access denied.

Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider "IBMDADB2" for linked server "sourcename".