I've spent hours searching through this forum and all over the internet for a solution to this one, but I'm a bit stumped.
I have a client where I am trying to link an Access 2007 front end to a SQL Server 2008 database. I have written code to establish a DSN-less connection, but I am getting the common/generic "Specified server does not exist or access denied." error message. This exact same error message appears if I use a DSN to attempt to establish the link.
The part that is really throwing me for a loop is that the EXACT same DSN returns a successful connection test when I am viewing it through the ODBC Administrator. I have established appropriate security for the user.. TCP/IP is enabled... If it's a common solution to this problem... I've probably tried/checked it (although I'm still very open to suggestion at this point).
I did notice that their SQL Server Browser service is not enabled... is it possible that would cause these symptoms?
Thanks in advance for the help!