Calendar - Using CalendarPro with MySQL

Print Page | Close Window

Using CalendarPro with MySQL

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=7206
Printed Date: 17 May 2024 at 9:14pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Using CalendarPro with MySQL

Posted By: Soren
Subject: Using CalendarPro with MySQL
Date 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.