10 Years
Discussion Span
Last Post by webchanger

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.


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.

Set con_server = New ADODB.Connection
con_server.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
           & "SERVER=servername;" _
           & "DATABASE=databasename;" _
           & "UID=userid;" _
           & "PWD=password;" _
           & "OPTION=3"

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.


This is system name.... not system anme... U can use system name(server name) instead of IP address.

Edited by webchanger: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.