Codejock Developer Community : Help with Connection to DB PLEASE! http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 28 Apr 2026 11:30:33 +0000 Wed, 25 Nov 2009 09:11:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=15582 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Help with Connection to DB PLEASE! : You can still use the custom data...]]> http://forum.codejock.com/forum_posts.asp?TID=15582&PID=55142&title=help-with-connection-to-db-please#55142 Author: SuperMario
Subject: 15582
Posted: 25 November 2009 at 9:11am

You can still use the custom data provider.  The calendar doesn't have to connect to the database.  In this case you can just tell it to use the custom provider.

Scripts for the tables the Calendar uses are here:
...\Calendar\VB\CalendarSample\SQLscripts

It doesn't matter how\where you store the data really, as long as you provide the calendar what it wants when it needs it.
]]> Wed, 25 Nov 2009 09:11:12 +0000 http://forum.codejock.com/forum_posts.asp?TID=15582&PID=55142&title=help-with-connection-to-db-please#55142 <![CDATA[Help with Connection to DB PLEASE! : I download the demo and I look...]]> http://forum.codejock.com/forum_posts.asp?TID=15582&PID=55095&title=help-with-connection-to-db-please#55095 Author: arrozcon
Subject: 15582
Posted: 23 November 2009 at 10:42am

I download the demo and I look at the sample. I like the software and I'm willing to buy it but I still dont undestand how to use your code. Your code has a statement to open the database by the use of connectionstrings. I cannt use string to connect to my database because I already have a conection. I sue SQL statements to creade, delete and edit records only.

What I need is to use my data and put it on your calendar, as simple as that. I have my own table. My own record ids, etc. How I can do that?
 
I'm willing to pay anyone that can do that for me.

Thanks,
Jose
]]> Mon, 23 Nov 2009 10:42:27 +0000 http://forum.codejock.com/forum_posts.asp?TID=15582&PID=55095&title=help-with-connection-to-db-please#55095 <![CDATA[Help with Connection to DB PLEASE! : Did you even look at the sample?...]]> http://forum.codejock.com/forum_posts.asp?TID=15582&PID=54780&title=help-with-connection-to-db-please#54780 Author: SuperMario
Subject: 15582
Posted: 12 November 2009 at 8:49am

Did you even look at the sample?  If you opened the sample it would be hard to miss.]]> Thu, 12 Nov 2009 08:49:35 +0000 http://forum.codejock.com/forum_posts.asp?TID=15582&PID=54780&title=help-with-connection-to-db-please#54780 <![CDATA[Help with Connection to DB PLEASE! : SuperMario wrote:Sounds like...]]> http://forum.codejock.com/forum_posts.asp?TID=15582&PID=54761&title=help-with-connection-to-db-please#54761 Author: arrozcon
Subject: 15582
Posted: 11 November 2009 at 6:45pm

Originally posted by SuperMario SuperMario wrote:

Sounds like you need the custom data provider.  See the VB6 sample and look at the SQL Server code to see how.
 
WHERE?
]]> Wed, 11 Nov 2009 18:45:05 +0000 http://forum.codejock.com/forum_posts.asp?TID=15582&PID=54761&title=help-with-connection-to-db-please#54761 <![CDATA[Help with Connection to DB PLEASE! : Sounds like you need the custom...]]> http://forum.codejock.com/forum_posts.asp?TID=15582&PID=54744&title=help-with-connection-to-db-please#54744 Author: SuperMario
Subject: 15582
Posted: 11 November 2009 at 10:30am

Sounds like you need the custom data provider.  See the VB6 sample and look at the SQL Server code to see how.]]> Wed, 11 Nov 2009 10:30:55 +0000 http://forum.codejock.com/forum_posts.asp?TID=15582&PID=54744&title=help-with-connection-to-db-please#54744 <![CDATA[Help with Connection to DB PLEASE! : Hello, I download the demo...]]> http://forum.codejock.com/forum_posts.asp?TID=15582&PID=54727&title=help-with-connection-to-db-please#54727 Author: arrozcon
Subject: 15582
Posted: 10 November 2009 at 10:57pm

Hello,
 
I download the demo to test the Calendar since I want to put that on my App. I have been working on my App for years so changing the way my database is setup is not an option because is alot of work!.
 
I want to show my records on the Calendar using my own TableName (i.e. tblGOActivity) and my own database (ie. Databasenm = go.mdb). This the code I;m working on and I cannt do it because I really dont know! I attach the database connection also for reference.
 
Code I'm working on: 
 
 Dim cur_set As Recordset
 Dim sql_str As String
 
 sql_str = "SELECT * FROM tblGOActivity" 'This is the database I want my Events to be saved"
 If Not goDatabase.CreateSnapshot(cur_set, sql_str) Then
 Exit Sub
 End If
 

    CalendarControl.SetDataProvider WHAT SHOUD I PUT BASE ON THE INFO I TOLD YOU ALREADY?        
    
    
    If Not CalendarControl.DataProvider.Open Then
        CalendarControl.DataProvider.Create
    End If
   
    'm_eActiveDataProvider = eDataProviderType
       
    CalendarControl.Populate
    wndDatePicker.RedrawControl
 
 
This is a sample of the Database Connection Code:
 
 
Function ConnectJet(ByVal db_name As String, ByVal user_id As String, _
ByVal password As String, Optional ByVal ip_addr As String = "") As Boolean
    On Error GoTo ConnectJet_EH
    Set wCurWS = DBEngine.CreateWorkspace("DefaultWS", "Admin", "", dbUseJet)
   
    If password = "" Then
        Set dCurDB = wCurWS.OpenDatabase(db_name, False)
    Else
        Set dCurDB = wCurWS.OpenDatabase(db_name, False, False, ";pwd=" & password)
    End If
   
    Call goGeneral.MouseDefault
 
    sDatabase_nm = db_name            ' Database file name with path.
    sPathToDatabase = goGeneral.GetPath(db_name)
    ConnectJet = True
    Exit Function
 
ConnectJet_EH:
     db_name = UCase(db_name)
    goGeneral.DisplayBox db_name & goMessage.IS_NOT_FOUND
    sDatabase_nm = ""
    ConnectJet = False
    Exit Function
 End Function
]]> Tue, 10 Nov 2009 22:57:28 +0000 http://forum.codejock.com/forum_posts.asp?TID=15582&PID=54727&title=help-with-connection-to-db-please#54727