like to set up a linked server to datawarehouse in SQL server

[laxminew]

Hi!
I am trying to set up a linked server to DATAWAREHOUSE in SQL server and I am getting a error for the provider name,

I tried using all providers to set up the like, MSDASQL, IBM OLE DB FOR DB2, and all the ones listed in the providers list which appears in the dialog box while setting up the new linked server. Can any one please help me with this.
Nalina

 

[dhookom]

You should probably try an SQL Server forum or news group. This forum is for Microsoft Access which doesn't support "linked servers".

Duane
MS Access MVP
Find out how to get great answers faq219-2884.