On a Windows Server 2008 (on a 64bit machine) - Server Manager - Microsoft Corporation - Version: 6.0.6002.18005
I am trying to create passthrough queries in Access 2007 SP2 MSO and am unable to get the connection string right. I've attached screen shots of all the settings - that's I think may be useful... and also a shot of the error message I am getting.
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.0.6002.18005
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.19048
Microsoft .NET Framework 2.0.50727.4211
Operating System 6.0.6002
Any help would be appreciated.
Thanks a lot!