CSK 3.1b using SQL Server

Topics: Help
Jan 6, 2008 at 3:02 PM
Does anyone have or is there any documentation to use CSK 3.1b with SQL? I modified the connection string, regenerated the DALs, but still having problems publishing the site.
Jan 6, 2008 at 3:28 PM
Line 9: Public Class Events
Line 10: Public Shared Sub Delete(ByVal Id As String)
Line 11: Dim eventqry As New Query(Tables.ClubEvent)
Line 12: eventqry.QueryType = QueryType.Delete
Line 13: eventqry.AddWhere(ClubEvent.Columns.ID, Id)

=========================================
connection string
<connectionStrings>
<add name="ClubSiteDB"
connectionString="Data Source=www.mysite.com;Integrated Security=false;User Id=UID;Password=password"
providerName="System.Data.SqlClient"/>
</connectionStrings>

=========================================
Generate DAL (subsonic 2.0.3)

sonic.exe generate /override /spStartsWith SP_ /viewStartsWith View /out c:\DALs /lang vb /server www.mysite.com /db myDb /userid UID /password password /generatedNamespace ClubStarterKit.Data /fixPluralClassNames false /spClassName SPs /provider ClubStarterKitData
sonic.exe generateODS /override /out c:\DALs /lang vb /server www.mysite.com /db myDb /userid UID /password password /generatedNamespace ClubStarterKit.Data /fixPluralClassNames false /spClassName SPs /provider ClubStarterKitData
sonic.exe generateviews /override /out c:\DALs /lang vb /viewStartsWith View /server www.mysite.com /db myDb /userid UID /password password /generatedNamespace ClubStarterKit.Data /fixPluralClassNames false /spClassName SPs /provider ClubStarterKitData