Codejock Developer Community : MySQL + Calender Control without using DNS http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 30 May 2026 08:35:44 +0000 Tue, 03 Apr 2007 05:00:50 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=6786 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[MySQL + Calender Control without using DNS : Got the problem solved. Thanks...]]> http://forum.codejock.com/forum_posts.asp?TID=6786&PID=21644&title=mysql-calender-control-without-using-dns#21644 Author: cybeh
Subject: 6786
Posted: 03 April 2007 at 5:00am

Got the problem solved. Thanks !!]]> Tue, 03 Apr 2007 05:00:50 +0000 http://forum.codejock.com/forum_posts.asp?TID=6786&PID=21644&title=mysql-calender-control-without-using-dns#21644 <![CDATA[MySQL + Calender Control without using DNS : Hi all,I am using tring to use...]]> http://forum.codejock.com/forum_posts.asp?TID=6786&PID=21639&title=mysql-calender-control-without-using-dns#21639 Author: cybeh
Subject: 6786
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 !!!
]]> Mon, 02 Apr 2007 21:26:06 +0000 http://forum.codejock.com/forum_posts.asp?TID=6786&PID=21639&title=mysql-calender-control-without-using-dns#21639