TCP Provider Run Time Error

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
m3mdiclAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TempDBACommented:
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
shorvathCommented:
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
m3mdiclAuthor Commented:
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

m3mdiclAuthor Commented:
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
shorvathCommented:
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
m3mdiclAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
m3mdiclAuthor Commented:
None of the responses helped.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.