0

Hi,

If you are interest in using MySQL as your back end database, here is one way to connect:
By using ODBC:

'Declare ADODB variable
Public ConnectData As New ADODB.Connection

Set ConnectData = New ADODB.Connection
ConnectData.Open "DSN=MySQL_ODBC"


If you want to use MySQL ODBC 3.51 Driver , You can write the connection like this:

Set ConnectData = New ADODB.Connection
'ConnectData.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;Database=Databasename;UID=Username;PWD=Password;OPTION=3"

ConnectData.Open


If you want to use MySQL ODBC 5.1 Driver , You can write the connection like this:

ConnectData.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;Database=Databasename;UID=Username;PWD=Password;OPTION=3"
ConnectData.Open


I hope this will be helpful for New learner. If there is another new easy and simpler way, give your sugestion here.

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by debasisdas
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.