Re: [MS_AccessPros] Access wont talk to SQL Server

 

Art-

Delete all your linked tables in Access and re-link them.  You can get this sort of error particularly if you've changed any of the table designs in SQL Server.  A re-link should get the latest definitions.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Dec 18, 2015, at 8:44 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I am having an interesting experience with my Access frontend and SQL Server backend. When I try to refresh my Linked Tables from within Access I Get the following errors:

Connection failed:

SQLState: '08001'

SQL Server Error: -1

[Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

Connection failed:

SQLState: '08001'

SQL Server Error: -1

[Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

Now the curious thing is I can use window explorer to look at the files on the server. I can remote into the server. And I can create ODBC connection to the server from the desktop that is in question. But every time I try to access the server from with Access I get the above error.

I have verified the SQL Server is up and running. I can also

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___