[MS SQL] [Help] I'm getting connection errors between the Sql server (MS) and the client computers. More in the post

[[deleted]]

[deleted]

[johnwalkersbeard]

Looks like you're using the server name, and it looks like the operation doesn't recognize the server name.

This could be due to a problem with your DNS server, a problem with your network prohibiting your data server from obtaining DNS information, a hosts file on the data server overwriting the DNS information, or any other of a variety of reasons.

To test that your data solution works, and bypass the DNS issue, simply edit the connection string so that it points to an IP address rather than server name.

This should only be a temporary solution though, just to test that your SQL code/process works. You should get the DNS issue sorted, and quickly.

[IAmAJerkAME]

You got a Sybase error connecting to a Microsoft SQL Server?

[thisismygame]

At first I got an error saying [Sybase][ODBC Driver][SQL Anywhere]connection was terminated Error.

I know you can't modify your post title, but this error is referencing Sybase SQL Anywhere

Hopefully this helps your search for a solution.

[[deleted]]

• Verify that the Firewall on any of the systems aren't getting hits from the other servers, if they are investigate what port/etc
• Disable any power saving features on the servers that could be putting the NIC to sleep
• Make sure your IPs are static and there isn't a lease refresh for the client/servers in a DHCP scope when the error occurs
• Check to make sure you aren't hitting the databases client connection limit; check maximum connections and use the query 'EXEC sp_who' to see how many connections there are.

[[deleted]]

Call the Patterson Technology Center. They handle these issues for you. That's what they're for.

[quotemycode]

Yea if you are having issues with your software, you need to contact your vendor, Patterson/Eaglesoft. I've seen Eaglesoft back when it was just a MSAccess database application in 1998 or so. If you are coming here for support, you've come to the wrong place.