New answers tagged odbc
have you tried solutions proposed here: --Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level error" http://support.microsoft.com/kb/942861
I believe you are looking for FreeTDS or for pymssql. From pymssql docs: A simple database interface for Python that builds on top of FreeTDS to provide a Python DB-API (PEP-249) interface to Microsoft SQL Server.
I am running Access 2010 with linked MySQL tables. I discovered that the destination table had a field formatted as "Decimal" and a length of 3,0. I changed this to 4,0 in MySQL, refreshed linked tables, and the append to the table worked. So it appears the destination field was not wide enough for the resulting data.
It's not possible to use just ODBC. Linked servers use Distributed Queries which is dependent on the OLEDB interface. This is not an optional or interchangeable API. Below that API can be any OLEDB, ODBC or even JDBC provider so long as its implementation supports the OLEDB interface. For example, there is an OLEDB provider for ODBC which is one of the most ...
Top 50 recent answers are included