ODBC Error occurred when using Remote Server?

Asked By lane andrews 0 points N/A Posted on - 02/04/2013

I am using a remote server database software. This  software is shared by multiple users at a time. Sometimess I see “ODBC Failed” an error and immediately it stopped working. Can anyone have any idea reading how to get rid of it?

• Status: Open
• Question Views: 629
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Databases

Best Answer by Drake Vivian

Go To Solution

Answered By Spreckelmeyer Kayla 0 points N/A #157123

ODBC Error occurred when using Remote Server?

Hello Lane,

First of all I’d like to say that the problem isn’t very serious cause the server is functioning. You didn’t mention about the server configuration. Though lets share some experience and lets see is it working or not.

Please follow these steps below.

1. Ping the remote server. Is it pinging or not. If yes then Have a check at the firewall option.

2. Just disable the firewall for a few minutes and try again.

3. You’ve to restart the server

Don’t forget to check every connection name and its spelling.

Good luck.

About Spreckelmeyer Kayla

Questions
1

Answers
135

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 02/15/2013
• Question Category: Misc Databases

Best Answer

Best Answer

Answered By Drake Vivian 30 points N/A #157125

ODBC Error occurred when using Remote Server?

Hi there Lane Andrews,

 

The error you're getting basically means that your connection to the server was broken and that you are not able to access it at that moment. Unfortunately, you gave us way to little details to give you the exact solution – it could be the network speed, server misconfiguration or just a temporary error.

 

I would suggest you to do some troubleshooting to see how many users can simultaneously work on the server without crashing it, to check your network connection speed and quality and to double check the configuration of the server to see if there are some problems with multiple users accessing the server.

 

The quickest workaround for your problem is to reboot the server after the crash. 

 

Best regards,

Drake Vivian

About Drake Vivian

Questions
0

Answers
820

Best Answers
186

• Vote Up 0 Vote Down

• Posted on - 05/28/2013
• Question Category: Misc Databases