Dbnetlib Connectionopen General Network Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow dbnetlib connectionopen (preloginhandshake()). general network error the company Business Learn more about hiring developers or posting ads with us Stack dbnetlib connectionopen (secdoclienthandshake()). ssl security error Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of dbnetlib connectionopen invalid connection 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error - connecting to SQL database in VB script up vote 1 down vote favorite
Dbnetlib Connectionopen (connect()). Specified Sql Server Not Found
I have a VB script which connects to a local SQL database to retrieve a value. The exact same script runs on about 100 servers, but a few of the servers produce this error: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation Here is the code that runs: Function GetPrimaryServerID On Error Resume Next Set objConnection = CreateObject("ADODB.Connection") Set objRecordSet = CreateObject("ADODB.Recordset") objConnection.Open "Provider=SQLOLEDB;Data Source=127.0.0.1;Initial Catalog=xxx;User ID=xxx;Password=xxx" sqlquery = "SELECT ServerID FROM dbnetlib connectionopen invalid instance tblSettings" objRecordSet.Open sqlquery,objConnection objRecordSet.MoveFirst GetPrimaryServerID = objRecordSet("ServerID") objRecordSet.Close objConnection.Close End Function The error occurs on the 5th line when trying to open the connection string. I'm confused as to why this script is working on nearly all servers and failing on only a handful. The database that they connect to is identical on every server in terms of structure, its only the data that changes. sql database vbscript ado share|improve this question asked Dec 7 '09 at 4:50 VBscripter 43237 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote accepted Fixed the problem by doing the following: Opened SQL Server Configuration Manager and went to Protocols for MSSQLSERVER -> TCP/IP. In the 'IP Addresses' tab, I noticed that IP2 which has address of 127.0.0.1 was active but not enabled. Changed to enabled and restarted SQL services. My VB script now successfully opens the connection to 127.0.0.1. share|improve this answer answered Dec 9 '09 at 5:32 VBscripter 43237 add a comment| up vote 0 down vote It could fail if the database is not configured to listen to TCP/IP traffic. The error "Named Pipes Provider, error: 0 - No process is on the other end of the pipe." points in that direction. You can test that with: telnet 127.0.0.1
360 games PC games dbnetlib connectionopen (connect()). sql server does not exist or access denied. 2012 Windows games Windows phone games Entertainment All Entertainment
Dbnetlib Connectionopen (connect()). Sql Server Does Not Exist Or Access Denied 2008
Movies & TV Music Business & Education Business Students & educators
Dbnetlib Connectionopen (parseconnectparams()). Invalid Connection
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/1857875/dbnetlibconnectionopen-preloginhandshake-general-network-error-connect Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/942861 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post http://www.codeproject.com/Questions/738823/Error-SQL-SERVER-ConnectionOpen-PreLoginHandshake your Blog quick answersQ&A Ask a Question View Unanswered Questions View All Questions... C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL dbnetlib connectionopen / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product dbnetlib connectionopen (connect()). Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird & The Wonderful The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ Error SQL SERVER ConnectionOpen(PreLoginHandshake()) Rate this: Please Sign up or sign in to vote. See more: SQL-server-2000 SQL-server-2005 , + Dear Friends, Please Give me your help about this problem: 1) I can't access to sql server 2000 throught SQL Server Enterprise Manager 2) I cant access to sql server 2000 throught SQL Analizer. The sql server is in another machine but in the same network. Please there is some way to reset the ip list or another mechanism to recover the connection Thanks in advance. Leonardo Ayala R. Posted