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".

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".

HELP! Installing SQL Server

Help!

I saw the Visual Studio 2005 beta and got that sent out to me. That had some SQL server trial on it. Everything was hunky-dory until microsoft put the free express editions on the web and i downloaded them. I Uninstalled the Visual studio beta and sql server but in the wrong order. I go to install the Microsoft VB Expres edition and that works fine. It gets round to the SQL Server and it fails. Why and how can i solve it?

Many thanks
luke.Have you tried the instructions here?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137700&SiteID=1

Thanks< MJ