Solved

TCP Provider Run Time Error

Posted on 2013-01-08
7
511 Views
Last Modified: 2013-01-16
screenshot of the Run time error
I have a VB6 app that has been running for 2 years and suddenly out of the blue i got this weird error.   Do you guys have any idea about the runtime error?

The application is made from VB6 with SQL Server 2005 database.

Below is the connection string I am using.
Public Sub Open_Connection()
  Set con = New ADODB.Connection
  With con
    .ConnectionString = "Provider=SQLNCLI;Server=xx.xxx.xxx.xx\instance;Database=myDbase;Uid=admin; Pwd=myPword1234;"
    .CommandTimeout = 0
    .CursorLocation = adUseClient
    .Open
  End With
End Sub

Open in new window


Any help is greatly appreciated.

-m3mdicl
0
Comment
Question by:m3mdicl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 25

Expert Comment

by:TempDBA
ID: 38758328
You need to check folllowing two things:-
1. Is your login + password is correct and there exists a valid login in the server.
2. Is the firewall opened.

•Remote OLEDB connection using TCP to a server that is blocked by Firewall
HResult 0x274C, Level 16, State 1
TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Error: Microsoft SQL Native Client : Login timeout expired.

Ref:- http://blogs.msdn.com/b/sql_protocols/archive/2005/09/28/474698.aspx?PageIndex=11
0
 
LVL 9

Expert Comment

by:shorvath
ID: 38759742
You are using an IP address in your connection string.

Has the IP address of this server cahnged? Are you using DHCP?  Can you PING the server using this IP from the client machine that is generating the error?

It is always best to use a named server and let your DNS/Hosts files resolve IP addresses.
0
 

Author Comment

by:m3mdicl
ID: 38759962
Hi everyone!!! Thanks for the quick reply.

As I've said the app is running for 2 years with no problem.  
Some additional info.

* The IP address is STATIC.
* The username and password is correct (didn't make any changes)
* The firewall is not blocking the app

Any more suggestions?
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

by:m3mdicl
ID: 38760006
Hi,
 The ip-address of the connection string has not changed. I can ping the server fine. The firewall is open for the traffic, the sql browser service is running. I can connect using the application from my home office.  I am kind of stumped on why this is happening.  Any ideas?
0
 
LVL 9

Expert Comment

by:shorvath
ID: 38760186
Check the Event Viewer to see if there is any more info on why the SQL is rejecting to connection.  (I have had a similar situation caused by a Windows Update.. )  Also check to see if anything has been done to the Server/SQL in terms of changes - new software, updates etc.
0
 

Accepted Solution

by:
m3mdicl earned 0 total points
ID: 38767971
Nothing has been done to the SQL server in terms of updates. What we did was
add xxx.xx.xx.xxx./abc,1433 in the connection string and could get it to work.
0
 

Author Closing Comment

by:m3mdicl
ID: 38781996
None of the responses helped.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question