We're a community of 1077K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,076,289 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Mysql ocbc connection just stopped working

Below is my code which worked up until this morning.

conn.Open if giving error 10060. I downloaded the latest odbc driver from MySql and that didn't help.

Dim rst As ADODB.Recordset
Dim conn As ADODB.Connection
Dim gs_SQL As String
Set rst = New ADODB.Recordset
Set conn = New ADODB.Connection
CheckADOConnection = True
conn.CursorLocation = adUseServer
conn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=" & WebIP & ";DATABASE=" & WebDb & ";UID=" & WebUID & ";PWD=" & WebPw & "; PORT=3306; OPTION=3"
conn.Open
If Err Then
msg.Title = "ODBC Connection Error"
msg.Prompt = "Please check to make sure IP#" & GetURLDownLoad("http://automation.whatismyip.com/n09230945.asp") & " Is allowed by server"
msg.Button = vbCritical
msg.Response = MsgBox(msg.Prompt, msg.Button, msg.Title)
CheckADOConnection = False
End If
rst.Close
conn.Close
Set rst = Nothing
Set conn = Nothing

2
Contributors
1
Reply
3 Hours
Discussion Span
11 Months Ago
Last Updated
2
Views
TerryReno
Newbie Poster
1 post since Jun 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

10060 error means connection timeout. Did anything change in your setup?

pritaeas
Posting Prodigy
Moderator
9,309 posts since Jul 2006
Reputation Points: 1,178
Solved Threads: 1,465
Skill Endorsements: 86

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.5109 seconds using 2.66MB