Join Stack Overflow to learn, share knowledge, and build your career.Apr 02, 2018 Method 1: . Note down the port your SQL instance is listening on from the SQL Server Errorlog; Try connecting to the named instance using the port number appended to the server name using the format, portnumber and see if that works. If it does work it is an indication the firewall is blocking the port UDP port 1434. odbc sql server driver unspecified error occurred on sql server
Download ODBC Driver for SQL Server. ; 2 minutes to read Contributors. In this article Microsoft ODBC Driver 17 for SQL Server Windows. Microsoft ODBC Driver 13 for SQL Server All Platforms. Download the Microsoft ODBC Driver 13 for SQL Server All Platforms; Windows.
Finally, I switched the ODBC source to use the SQL Native Client driver instead of the SQL Server driver, and that finally DID work. SoaperGEM Nov 9 '09 at 14: 08 Thank you SoaperGEM! odbc sql server driver unspecified error occurred on sql server
In case you try to use the server IP address, check in the SQLServer configurator that SQL Server is listening on the IP address you use in your connection. ( SQL Server Configurator screenshot ) Other useful thing to check try: Nov 27, 2017 Describes a problem that occurs when the network load on SQL Server is high or when a multipleuser application accesses databases in SQL Server. General Network error , Communication link failure , or A transportlevel error message when an application connects to SQL Server [ODBC SQL Server Driver[DBNETLIB General Hi All, I am getting the following error when i am running swing program. I have a large volume of data. My resultset is running upto 2 hours. after 2 hours process odbc sql server driver unspecified error occurred on sql server May 05, 2010 Note: None of the Microsoft SQL Server ODBC drivers listed is certified to work with Sybase SQL Servers. Applications needing to connect to Sybase SQL Servers must get an ODBC driver certified for use with Sybase from either Sybase or a thirdparty ODBC driver vendor. Hi All, I have job in sql server which restores database backup and permissions thereafter. Sometime one step in this job fails with below message. This step restores users permissions on the Microsoft SQL Server ve Microsoft SQL Server ile ilgili dier uygulamalar, aralar ve haberlerle ilgili Trke ierii bu gnlkte bulabilirsiniz.