Calendar - MySQL + Calender Control without using DNS

Print Page | Close Window

MySQL + Calender Control without using DNS

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=6786
Printed Date: 06 October 2024 at 2:03pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: MySQL + Calender Control without using DNS

Posted By: cybeh
Subject: MySQL + Calender Control without using DNS
Date Posted: 02 April 2007 at 9:26pm

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 !!!

Replies:

Posted By: cybeh
Date Posted: 03 April 2007 at 5:00am

Got the problem solved. Thanks !!