[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Reply

•
•
Join Date: Jul 2008
Posts: 9
Reputation: sutanu_halder is an unknown quantity at this point 
Solved Threads: 0
sutanu_halder sutanu_halder is offline Offline
Newbie Poster

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060

 
0
  #1
Jul 29th, 2008
How to connect dynamic IP in ODBC Driver using Visual Basic 6.0
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2008
Posts: 9
Reputation: sutanu_halder is an unknown quantity at this point 
Solved Threads: 0
sutanu_halder sutanu_halder is offline Offline
Newbie Poster

Re: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060

 
0
  #2
Jul 30th, 2008
How to connect ODBC Driver with MySQL using dynamic IP internet connection in Visual Basic 6.0 application? I am getting error while connecting using [MySQL][ODBC 3.51 Driver] in Vb 6.0 application. I find that using static IP internet connection the application is working successfully but using dynamic IP internet connection occurs
error Description:-"[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060"
and Error No:- "-2147467259". Actually we are using internet connection by "Tata Indicom internet service provider" and this is static IP internet connection and other connection is by "BSNL internet service provider" and this is dynamic IP internet connection.
Please help me as soon as possible.
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2007
Posts: 2,134
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 132
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

Re: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060

 
0
  #3
Jul 30th, 2008
why you need to connect dynamically to any IP ?
Share your Knowledge.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2008
Posts: 9
Reputation: sutanu_halder is an unknown quantity at this point 
Solved Threads: 0
sutanu_halder sutanu_halder is offline Offline
Newbie Poster

Re: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060

 
0
  #4
Jul 30th, 2008
•
•
•
•
Originally Posted by debasisdas View Post
why you need to connect dynamically to any IP ?
Sorry you couldn't get my question. Actually my internet service provider giving us dynamic IP and we couldn't connect to MySQL server using that connection. But using another connection application is working properly.
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2007
Posts: 2,134
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 132
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

Re: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060

 
0
  #5
Jul 30th, 2008
try to use system anme instead of IP address for the connection.
Share your Knowledge.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2008
Posts: 9
Reputation: sutanu_halder is an unknown quantity at this point 
Solved Threads: 0
sutanu_halder sutanu_halder is offline Offline
Newbie Poster

Re: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060

 
0
  #6
Jul 30th, 2008
what is "system anme"?
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2008
Posts: 9
Reputation: sutanu_halder is an unknown quantity at this point 
Solved Threads: 0
sutanu_halder sutanu_halder is offline Offline
Newbie Poster

Re: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server 10060

 
0
  #7
Jul 30th, 2008
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
  1. Set con_server = New ADODB.Connection
  2. con_server.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
  3.            & "SERVER=servername;" _
  4.            & "DATABASE=databasename;" _
  5.            & "UID=userid;" _
  6.            & "PWD=password;" _
  7.            & "OPTION=3"
  8. con_server.Open
this code is working with "tata indicom internet connection provider" but while i using "bsnl internete connection provider "gives me error.
plese help me it is very urgent.
Last edited by Tekmaven; Jul 30th, 2008 at 9:50 am. Reason: Code tags
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC