3.00.11 - Module Dev Doc Question - Survey Sample help! RSS

• • Reply
  salex2

  Member

  2 Points

  188 Posts

  3.00.11 - Module Dev Doc Question - Survey Sample help!

  Mar 02, 2005 05:46 PM|salex2|LINK

  Okay - I'm going through the Module Development whitepaper and have gotten to the "Configuring Your Database" section on page 15. It describes using a script to build the database structure - however, I cannot find the Database Provider Script it speaks of. Can someone help me out here? Thanks. ~A~
  Blessings,
  ~A~
• • Reply
  aus_nexxus

  Participant

  806 Points

  1147 Posts

  Re: 3.00.11 - Module Dev Doc Question - Survey Sample help!

  Mar 02, 2005 09:09 PM|aus_nexxus|LINK

  Look in this folder Providers\DataProviders\SqlDataProvider you will see a series of scripts that create the db and populate it. Cheers
  Philip Beadle (MVP, MCAD, MCT DotNetNuke Core Team)
• • Reply
  salex2

  Member

  2 Points

  188 Posts

  Re: 3.00.11 - Module Dev Doc Question - Survey Sample help!

  Mar 03, 2005 10:22 AM|salex2|LINK

  Okay found the folder and all of the scripts. Is there a master script or something that I should run that will invoke all of the other scripts? What is the process for setting this stuff up? I don't spend much time managing our SQL servers (we have dedicated folks for that) and I'm just running SQL 2000 on my local box for testing. What do I do with these scripts? Thanks in advance. ~A~
  Blessings,
  ~A~
• • Reply
  salex2

  Member

  2 Points

  188 Posts

  Re: 3.00.11 - Module Dev Doc Question - Survey Sample help!

  Mar 03, 2005 10:31 AM|salex2|LINK

  For clarification, I am looking in: C:\DotNetNuke\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider Is this the correct folder? It only has a single script that I can see...now what? OR - is this the right folder? C:\DotNetNuke\Providers\DataProviders\SqlDataProvider It has a ton of scripts in it and I still don't know what to do... Please advise.
  Blessings,
  ~A~
• • Reply
  salex2

  Member

  2 Points

  188 Posts

  Re: 3.00.11 - Module Dev Doc Question - Survey Sample help!

  Mar 03, 2005 11:24 AM|salex2|LINK

  I used the C:\DotNetNuke\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider script (since there was only one). Following the documentation I did a Find/Replace on "{databaseOwner}{objectQualifier}" and replaced them with "", however the script would still not run. I discovered that there are also "PK_{objectQualifier}" references that were breaking the script. So, do another find/replace of "{objectQualifier}" with "". Everything runs fine after making the additional modification. I wanted to post this here so other n00bs like myself won't be lost on the same thing. Perhaps it would be helpful to include the PK_{objectQualifier} removal step on the tutorial as well. Thanks.
  Blessings,
  ~A~