Database Mappings

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

   Hi

I have decided to move to SQL Server .... YAY !!  I used the upsizing wizard and all went ok. Good.

I have adjusted my VB6 code to use a custom provider and apart from minor changes it works. What I have found however is that the recurrence tables do not seem to map to the SQLDataHelper column names. I can see that some of the names in this code do not appear in the database table at all and some are misspelled. It is not immediately obvious how to map the columns. Can somebody provide a list of mapped columns between the Access version and the SQLDataHelper so I can rename or add tables etc? 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Boris Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 21 June 2007 Location: United Kingdom Status: Offline Points: 179	Post Options Post Reply Quote Boris Report Post Thanks(0) Quote Reply Topic: Database Mappings Posted: 27 April 2012 at 4:28am
	Hi I have decided to move to SQL Server .... YAY !! I used the upsizing wizard and all went ok. Good. I have adjusted my VB6 code to use a custom provider and apart from minor changes it works. What I have found however is that the recurrence tables do not seem to map to the SQLDataHelper column names. I can see that some of the names in this code do not appear in the database table at all and some are misspelled. It is not immediately obvious how to map the columns. Can somebody provide a list of mapped columns between the Access version and the SQLDataHelper so I can rename or add tables etc?
	Boris Product: Xtreme SuitePro (ActiveX) version 16.4.0 16.3.1 Platform: Windows XP (32bit) - SP 3 Language: Visual Basic 6.0 SP6 VS 2005-2008-2010-2013

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 27 April 2012 at 1:15pm
	there is a VB6 sample "CustomCalender" sample that shows this. With custom provider "you" make the tables, fields, etc, so the names are not important. What is important is that you give the calendar the correct information when it asks.

Boris Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 21 June 2007 Location: United Kingdom Status: Offline Points: 179	Post Options Post Reply Quote Boris Report Post Thanks(0) Quote Reply Posted: 27 April 2012 at 1:19pm
	Hi There are very important as I have shipped the CJ Access database with a few mods in to all my clients. When I have upsized their databases the Sql helper does not work. I don't want to map to the wrong field in case it breaks what they already have. Does that explain the issue better? Regards Boris
	Boris Product: Xtreme SuitePro (ActiveX) version 16.4.0 16.3.1 Platform: Windows XP (32bit) - SP 3 Language: Visual Basic 6.0 SP6 VS 2005-2008-2010-2013

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 27 April 2012 at 9:49pm
	Still not an issue, simply use the same tables and fields you used in the access database.

Boris Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 21 June 2007 Location: United Kingdom Status: Offline Points: 179	Post Options Post Reply Quote Boris Report Post Thanks(0) Quote Reply Posted: 28 April 2012 at 10:18am
	Hi Mario If you read my post you will understand that it does not work!! I.E The Access database that Codejock shipped does not map to the RecordSet fieldnames that exist in the SQL Custom Provider. I would recommend that you actually have a look at the code . Believe me I have and it just fails on Debug.Assert over and over again.
	Boris Product: Xtreme SuitePro (ActiveX) version 16.4.0 16.3.1 Platform: Windows XP (32bit) - SP 3 Language: Visual Basic 6.0 SP6 VS 2005-2008-2010-2013

SuperMario Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 14 February 2004 Status: Offline Points: 18057	Post Options Post Reply Quote SuperMario Report Post Thanks(0) Quote Reply Posted: 30 April 2012 at 12:22am
	There is only a custom provider, it don't care what names you use. Did you look at the VB6 custom calendar sample?

Boris Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 21 June 2007 Location: United Kingdom Status: Offline Points: 179	Post Options Post Reply Quote Boris Report Post Thanks(0) Quote Reply Posted: 30 April 2012 at 3:16am
	I have shipped the code that I first had when I bouth CJ back in Version 10. ?? Have you changed the provider code since then. I have found that the recordset now refers to a field called UseEnd wheareas in mine it refers to EndMethod. I will take the code from the latest cut and use this from now on. Thanks for your time
	Boris Product: Xtreme SuitePro (ActiveX) version 16.4.0 16.3.1 Platform: Windows XP (32bit) - SP 3 Language: Visual Basic 6.0 SP6 VS 2005-2008-2010-2013

danypd69 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 29 May 2012 Status: Offline Points: 1	Post Options Post Reply Quote danypd69 Report Post Thanks(0) Quote Reply Posted: 02 May 2013 at 4:14am
	Hello Boris, I have the same problem. Have you solved it ?