Using CalendarPro with MySQL

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi everyone

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.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Soren Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 09 May 2007 Location: Denmark Status: Offline Points: 13	Post Options Post Reply Quote Soren Report Post Thanks(0) Quote Reply Topic: Using CalendarPro with MySQL Posted: 22 May 2007 at 9:36am
	Hi everyone 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.