Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yahazim
Starting Member
13 Posts |
 Posted - 2002-09-26 : 11:08:42
|
| I have deployed in my Enterprise an Access MDB database.It connects to a SQL Server through ODBC using the TCP/IP network library "File DSN".At certain times during the day, my users experience getting "kicked out" of the database due to ODBC errors:-------------ODBC - call failed[Microsoft][ODBC SQL Server Driver]Communication link failure (#0)ANDODBC-insert on a linked table ‘tblLetter failed[Microsoft][ODBC SQL Server Driver][DBNETLIB}ConnectionReas(recv()). (#10054)[Microsoft][ODBC SQL Server Driver][DBNETLIB}General Network error. Check your network documentation. (#11)-----------------I am having SERIOUS issues with this and cannot resolve it. Any ideas anyone?THANK YOU IN ADVANCE.Jim |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-26 : 11:33:00
|
| The network is causing the trouble. The connection between the client computer and SQL Server either blew up completely, or had some kind of hiccup that caused the connection to drop.It's possible also, if your file DSN resides on a network drive, that may be the cause of the problem for a similar reason: the network drive couldn't be read to retrieve the file DSN.Have you tried setting up the Access database to use DSN-less connections? It's possible to do it without a DSN at all, and unless you need to change connection information regularly I would recommend this approach instead. |
 |
|
|
yahazim
Starting Member
13 Posts |
Posted - 2002-09-26 : 12:43:31
|
| How would I setup a DSN-Less connection? I have the tables linked in to Access through the "Link Table" function of Access.Would I write a VB Module that makes these connections? I have to link about 35 tables. |
|
|
|
|
|
|
ODBC Errors PLEASE HELP!