Revision
79 -
Directory Listing
-
[select for diffs]
Modified
Fri Jul 13 02:24:25 2012 UTC
(11 years, 4 months ago)
by
william
Diff to
previous 78
change Database Name: AnywhereTS ==> AtsDb
+ need to add user settings
- set ServerIP
- set ServerDBInstance (SQLEXPRESS or other)
- need to set other settings
* build connection strings from these user settings at RunTime
and remove the atsConnectionString user settings
Connection string types:
- SQL Server Express Database
- SQL Server Database (Enterprise, etc [not an Express version])
- SQL Server Database File (.mdf)
Revision
78 -
Directory Listing
-
[select for diffs]
Modified
Fri Jul 13 02:21:43 2012 UTC
(11 years, 4 months ago)
by
william
Diff to
previous 77
+ comment-out NDC using statments that pass-in .sql script as context (this will keep the log file(s) lean an' mean)
Revision
77 -
Directory Listing
-
[select for diffs]
Modified
Fri Jul 13 01:35:49 2012 UTC
(11 years, 4 months ago)
by
william
Diff to
previous 76
+ fix syntax error in UpdateDatabase4.sql (commas cannot come after the last item in an ALTER table statement)
Revision
76 -
Directory Listing
-
[select for diffs]
Modified
Fri Jul 13 01:22:58 2012 UTC
(11 years, 4 months ago)
by
william
Diff to
previous 75
+ automatically replace the hardcoded database name AnyhwereTS with ATSGlobals.strDatabaseName when accessing SQLServerResources class
Revision
72 -
Directory Listing
-
[select for diffs]
Modified
Thu Jul 12 21:23:35 2012 UTC
(11 years, 4 months ago)
by
william
Diff to
previous 70
atsDataSet.Designer.cs:
ConnectionString = global::AnywhereTS.Properties.Settings.Default.atsConnectionString.Replace("AnywhereTS", "master");
Revision
51 -
Directory Listing
-
[select for diffs]
Modified
Thu Jul 12 16:21:35 2012 UTC
(11 years, 4 months ago)
by
william
Diff to
previous 50
fix an issue that was resolved by connecting to master database instead of AnywhereTS database
Revision
22 -
Directory Listing
-
[select for diffs]
Modified
Wed Jul 11 20:13:17 2012 UTC
(11 years, 4 months ago)
by
william
Diff to
previous 21
+ finish support for creating tables in an empty database (incase the database are pre-created, but contains no tables)
- still have AD login issues when creating the database from scratch (ie. it did not exist to begin with)
Revision
10 -
Directory Listing
-
[select for diffs]
Modified
Wed Jul 11 16:01:40 2012 UTC
(11 years, 4 months ago)
by
william
Diff to
previous 9
SetupDatabase():
sqlCon.ConnectionString = Properties.Settings.Default.atsConnectionString;
+ this enables the user to set the connection string
(they could use SQLEXPRESS or a full Server install with named instances)
Data Source=.\SQLEXPRESS
-or-
Data Source=IPADDRES\INSTANCENAME