Db Netlib Error Vb6
Contents |
help? Post your question and get tips & solutions from a community of 418,478 dbnetlib connectionopen preloginhandshake . general network error. check your network documentation IT Pros & Developers. It's quick & easy. Problem connect vb6
Dbnetlib Connectionopen (connect()). Sql Server Does Not Exist Or Access Denied
to sql server P: 5 Sky86 i'm new in vb, got some problem in connect to sql server 2000. i use the following code to connect, n got error. Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset Set conn = New ADODB.Connection Set rs = New ADODB.Recordset conn.ConnectionString = "Driver={sql server};server= ABC ;database= test" conn.ConnectionTimeout = 30 conn.Open The error i got in vb is Run-time error ‘-2147467259(80004005)’: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied but i hav start my sql server already. need help on this problem, thank for helping! Nov 26 '06 #1 Post Reply Share this Question 6 Replies 100+ P: 1,646 willakawill i'm new in vb, got some problem in connect to sql server 2000. i use the following code to connect, n got error. Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset Set conn = New ADODB.Connection Set rs = New ADODB.Recordset conn.ConnectionString = "Driver={sql server};server= ABC ;database= test" conn.ConnectionTimeout = 30 conn.Open The error i got in vb is Run-time error ‘-2147467259(80004005)’: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied but i hav start my sql server already. need help on this problem, thank for helping! Hi Is the security for sql server set to Windows or mixed? Nov 27 '06 #2 reply Expert 100+ P: 1,754 sashi i'm new in vb, got some problem in connect to sql server 2000. i use the following code to connect, n got error. Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset Set conn = New ADODB.Connection Set rs = New ADODB.Recordset conn.ConnectionString = "Driver={sql server};server= ABC ;database= test" conn.Con
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: Vb6 Ado Sql Server Error -2147467259 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jul 19th, 2006,06:10 AM #1 reado View Profile View Forum Posts Thread Starter Lively Member Join Date Mar 2005 Posts 78 Vb6 Ado Sql Server Error -2147467259 Hi, I am getting intermittant https://bytes.com/topic/visual-basic/answers/568861-problem-connect-vb6-sql-server Errors when using ADO, VB6 and SQL server I get the following error [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation. -2147467259 Would this be due to a busy network, or iffy network or is something more..?? Cheers Paul Reply With Quote Jul 19th, 2006,07:14 AM #2 Shuja Ali View Profile View Forum Posts Visit Homepage Shared Member Join Date May 2005 Location Kashmir, India Posts 2,277 Re: Vb6 Ado Sql Server Error -2147467259 Take a look at http://www.vbforums.com/showthread.php?417449-Vb6-Ado-Sql-Server-Error-2147467259 this article om MS knowledgebase http://support.microsoft.com/default...NoWebContent=1 Use [code] source code here[/code] tags when you post source code. My Articles Reply With Quote Jul 19th, 2006,07:18 AM #3 Static View Profile View Forum Posts Visit Homepage eltiT resU motsuC Join Date Oct 2000 Location Rochester, NY Posts 9,389 Re: Vb6 Ado Sql Server Error -2147467259 Thats what I would guess. I would say more of a connection issue then traffic... traffic would give u a connection, but then probably time out. id say the connection is spotty. Does it work most of the time? JPnyc rocks!! (Just ask him!) If u have your answer please go to the thread tools and click "Mark Thread Resolved" Reply With Quote Jul 19th, 2006,07:44 AM #4 reado View Profile View Forum Posts Thread Starter Lively Member Join Date Mar 2005 Posts 78 Re: Vb6 Ado Sql Server Error -2147467259 Yep it works most of the time but I do seem to get quite a few of these erros?? Reply With Quote Jul 19th, 2006,08:01 AM #5 Shuja Ali View Profile View Forum Posts Visit Homepage Shared Member Join Date May 2005 Location Kashmir, India Posts 2,277 Re: Vb6 Ado Sql Server Error -2147467259 Originally Posted by reado Yep it works most of the time but I do seem to get quite a few of these erros?? Did you try going through the Link th
here for a quick overview of the site Help Center Detailed answers to any questions you might http://stackoverflow.com/questions/1857875/dbnetlibconnectionopen-preloginhandshake-general-network-error-connect have Meta Discuss the workings and policies of this site About http://www.sqlservercentral.com/Forums/Topic374493-324-1.aspx Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million dbnetlib connectionopen 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 I have a VB script which connects to a local SQL database to retrieve a value. The exact same script runs db netlib error 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 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
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » SQL Server Express » -2147467259 - [DBNETLIB][ConnectionWrite... 38 posts,Page 1 of 41234»»» -2147467259 - [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation Rate Topic Display Mode Topic Options Author Message Mark StoryMark Story Posted Saturday, June 16, 2007 6:23 AM Forum Newbie Group: General Forum Members Last Login: Sunday, August 12, 2007 8:27 PM Points: 4, Visits: 1 I Have SQL Express installed on 17 ships. Each ship has a VB6 Client application using OLEDB to connect to the database on local machine. Other workstations on network also connect - we think without error.The error above is thrown on 4 of the 17 ships. The workstations acting as the file server are supposed to be identical (Windows XP). We have been assured that all poer save settings on LAN Card and motherboard have been disabled.If I google on this error, I get over 100 hits going back several years ! Ideas to fix have included turning off connection pooling and using TCPIP instead of Named Pipes on client workstation where database server and application are running.Any other ideas on what could cause this, or why 13 machines are OK, but 4 are not ? Thanks. Post #374493 Michael MeierruthMichael Meierruth Posted Monday, June 18, 2007 8:15 AM Mr or Mrs. 500 Group: General Forum Members Last Login: Thursday, September 22, 2016 10:11 AM Points: 571, Visits: 2,484 Have been getting this error sporadically for years on a largeSS2K site. Fortunately, it does not happen that often. But, in my case,it ismostly associated with something that goes through ADO+ODBC using TCP/IP. For a long time our software was blamed on it until I wrote a simple VB script routine that runs in a loop and remains permanently connected and executes a simple 'select 0' every mìnute. When an error occured it would get logged and then attempt to re-establish the connection.The ADO Err stack always had two errors with the second one always being 'General network error'. The first error would varyincluding your 'ConnectionWrite(Send())'.Now the problem was squarely in Microsoft's terrrory. This problem was never solved. We checked the hardware, routers, service packs - you name it. We even ran the script on the database server itself and it would happen there as well. Post #374638 Jeffrey IrishJeffrey Irish Posted Monday, June 25, 2007 7:31 AM SSC-Enthusiastic Group: General Forum Members Last Login: Tuesday, September 27, 2016 6:46 AM Points: 155, Visits: 1,108 By far this is the