Blending life, nature and technology.
visual Studio .Net
SQL Server 2008 R2 Express
Jul 29th
Microsoft SQL Server 2008 R2 now has a maximum database size limit of 10Gb as opposed to the former limit of 4Gb. Small organizations and Microsoft Access migration will find this useful.
Heres a link for downloading SQL 2008 R2 Express
Heres an easy installation guide link.
Azure sample database setup….
Dec 29th
Notes on setting up the sample database – adventureworks [click here] for Microsoft’s cloud computing sql server called Azure:
- you need an account – get one from sql.azure.com - it takes some time for your access information to arrive by email.
- download the sample database using link above
- extract/unzip to a known location
- make sure you add your home/work/workstation actual external facing ip address to the firewall settings
- wait for 5-10 mins for your ip address to be accepted by the azure online firewall system
- run the script commands below
See commands/reference pictures below:
Server Name: serverx serverx.database.windows.net
Administrator Username: userx
Server Location: South Central US
db name: ankh
cd dw
buildawdwaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx
cd lt
buildawltaz.cmd tcp:serverx.database.windows.net userx@serverx passwordx
SQL Azure
Dec 6th
SQL Azure is a fully relational database in the cloud by Microsoft.
See this link for the main website.
For how to connect to Azure using ADO.Net heres a good link from msdn and another link which l’m currently using to work on plugging the northwind sample database to azure and using a WPF datagrid view to present the data.
Clickonce deployment issue….
Oct 30th
While deploying a Visual Studio Winform application using clickonce, the publishing goes okay but when l tried to run the setup program, l get this error message:
System Update required – The application requires that system.web.extensions version 1.0.61025.0 be installed in the global assemble cache (GAC) first.”
Clicking on the project properties in Visual Studio.Net, then references, l noticed this file exisits under C:\Program Files\Microsoft ASP.NET\ASP.NET 2.0 AJAX Extensions\v1.0.61025 – l copied this in a local \lib\ folder in my application source project folder, and referenced directly to it, rebuilt the application, republished it to our company shared folder and re-ran the setup.