I'm sorry but I just can't figure it out how I will connect to my MySQL-database.

 

In my database I have the four tables which is needed.

 

I use the following string to connect:

 

db_name = "handson"
db_server = "10.0.0.1"
db_port = "3306"

db_user = "user"
db_pass = "xxxxxxxxx"

ConnString = "Provider=MSDASQL.1;Password=;Persist Security Info=True;User ID=;Extended Properties=" & Chr$(34) & "DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=" & db_name & ";SERVER=" & db_server & ";UID=" & db_user & ";PASSWORD=" & db_pass & ";PORT=" & db_port & ";OPTION=16387;STMT=;" & Chr$(34)

 

In the Form_Load of my calendar-form, I use

 

    m_eActiveDataProvider = cjCalendarData_MySQL

    OpenProvider cjCalendarData_MySQL, ConnString

The connection works fine for me else where in the program, but not with the calendar.

 

What happens is, that when I try to create a new event, the event is not shown in the calendar, and is not created in the database.