MySQL + Calender Control without using DNS

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

   Hi all,

I am using tring to use Codejock calender control with mySQL database in VB (for the MultiSchedule).
Due to some special problem, we do not want to crease DNS or ODBC @ the client server.

We were using this connection string
"driver={mysql odbc 3.51 driver};server=localhost;database=cjcalendar;uid=root;pwd=demopass;option=165932"

in our database connection. Can anyone give me a simple sample on that ?
I really try hard to get the things done by editing the sample code.

    If eDataProviderType = cjCalendarData_MySQL Then
        strConnectionString = "driver={mysql odbc 3.51 driver};server=localhost;database=cjcalendar;uid=root;pwd=demopass;option=165932"

        Set m_pCustomDataHandler = New providerMySQL
        m_pCustomDataHandler.OpenDB strConnectionString

        m_pCustomDataHandler.SetCalendar CalendarControl
    End If

    CalendarControl.SetDataProvider strConnectionString

    'strConnectionString

    If eDataProviderType = cjCalendarData_SQLServer Or eDataProviderType = cjCalendarData_MySQL Then
        CalendarControl.DataProvider.CacheMode = xtpCalendarDPCacheModeOnRepeat
    End If

    If Not CalendarControl.DataProvider.Open Then
        CalendarControl.DataProvider.Create
    End If

    m_eActiveDataProvider = eDataProviderType

    CalendarControl.Populate
    wndDatePicker.RedrawControl

This return no error, but it will not load from the database too. Please advice. Thanks !!!