I have a remote server with a SQL Server 2008 database on it.
I have two desktop machines.
One machine connects to the SQL Server database over the internet using the 'SQL Server' driver. The other machine refuses to connect using the same driver but will connect using the 'SQL Server native Client' driver. However there seems to be an error produced when using the 'Native Client' driver whn accessing stored procedures.
I have checked the driver version on both machines = All good - Exactly the same.
Checked that firewall is switched off on both machines.
I am using identical connection strings.