bicyclensw
Guppy
Hello,
My company uses Microsoft Access as a front end to a SQL Server database. Access runs on people's local work stations, while the SQL Server database sits on a JodoHost database server. I set up ODBC links in Access to the tables in the SQL Server database.
This works well, except that very often the connection to the database (on the JodoHost database server) is dropped. I see error messages such as:
ODBC-- connection to 'SQL Servermssql8.jodoshared.com' failed.
ODBC--call failed.
[Microsoft][ODBC SQL Server Driver]Communication link failure (#0)
ODBC--call failed.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).(#10054)[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
This is driving my users crazy. JodoHost support doesn't have an explanation for this, so I'm getting desperate.
Does anybody know what is causing this?
What can be done about it?
Thanks in advance for your help,
Matt Perdeck
Bicycle NSW
My company uses Microsoft Access as a front end to a SQL Server database. Access runs on people's local work stations, while the SQL Server database sits on a JodoHost database server. I set up ODBC links in Access to the tables in the SQL Server database.
This works well, except that very often the connection to the database (on the JodoHost database server) is dropped. I see error messages such as:
ODBC-- connection to 'SQL Servermssql8.jodoshared.com' failed.
ODBC--call failed.
[Microsoft][ODBC SQL Server Driver]Communication link failure (#0)
ODBC--call failed.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).(#10054)[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
This is driving my users crazy. JodoHost support doesn't have an explanation for this, so I'm getting desperate.
Does anybody know what is causing this?
What can be done about it?
Thanks in advance for your help,
Matt Perdeck
Bicycle NSW