-
Behind on posting, Yes I know
So, yes I’ve not been posting as much. It’s been a very busy time with doing some Raspberry PI things… teeth problems… you know the normal stuff where posting kind of falls off a bit. Oh, yeah… I’ve also been working at moving over one of my sites to Blazor (that should be interesting considering how mush I dislike CSS). Ok, I’ll be back soon.. ~SG
-
ATT Gateway Issues, again?
I know I’ve mentioned this before- ATT fiber gateway “thing” has got to be one of the most annoying network devices to try to setup, so everyone can see all of this site. Indeed yes! We had a power fail during some storms last Friday, and of course there was some disruptions. Not many, most of my servers are on UPS. But for some reason, the fixed IP from the Gateway to my Lan changed the IP address to the primary NIC. REALLY!! It’s supposed to be a fixed address, not DHCP. And yet here we are. The gateway did not in fact give the same IP address to the…
-
The Error AspNetCore.Components.Forms Requires value for ‘ValueExpression’ on a Blazor Page
What the hell is that? Let’s start with the full error throw from our Blazor Page: Microsoft.AspNetCore.Components.Forms.InputText requires a value for the ‘ValueExpression’ parameter. Normally this is provided automatically when using ‘bind-Value’. It’s here we see this in our little Blazor .Not 6 App: On our page we must have a @bind-Value that has gone off the tracks. Yes we do. Here’s the page Razor code in a EditForm – do you see the problem? <EditForm Model="hero" OnSubmit="HandleSubmit"> <div> <label for="FirstName">First Name</label> <InputText id="FirstName" @bind-value ="hero.FirstName" class="form-control"></InputText> </div> <div> <label for="LastName">Last Name</label> <InputText id="LastName" @bind-Value="hero.LastName" class="form-control"></InputText> </div> <div> <label for="HeroName">Hero Name</label> <InputText id="HeroName" @bind-Value="hero.HeroName" class="form-control"></InputText> </div> <div> <label>Comic</label><br /> <InputSelect…
-
SQLlocalDB – and How to add a latest version of a LocalDB instance
For those that develop with a backend DB, localdb has always been a good ‘go to’ option. A Dev db hosted on a localDB instance provides a good base that is simple to move to Production. It also has a benefit of Migrations. (Yes, SQL Server is not the only DB engine to provide such, but we will talk about SQL Server here). LocalDB is a handy, for free, SQL instance that basically comes with VS installations (yes, now a days you do have to pick the correct workload). With that in mind, those of us that long ago installed the venerable LocalDB, we were often suck with older versions…
-
Dotnet 6 API with a HttpDelete and that 405 Method not allowed error
As we can tell from the title of the Post, we are going to talk about figuring out why in a client app one gets a Http Status code of 405 (Method Not Allowed). When does this happen? Usually when a http request does a http PUT or DELETE. Yet, when one uses Swagger (openAPI) or Postman to directly call the same API Delete or Put, it works! This is starting to feel like a CORS issue, right? Read On ==> So 405! Indeed looking at the surface of what is going on, one thinks Ah! CORS is at it again! Absolutely, this is what it feels like. After all,…
-
Autumn 2021
…. Welcome Autumn! ….
-
Blazor with dotnet watch run in the Pre-Dotnet 6 and VS 2022 days
Oh, how we do wait for the release of dotnet 6 and most important VS 2022. Why? Well the promise of hot-reload without hoops to jump through. For the most part in VS 2019 16.10.4, “hot-reload” of a Blazor app is not too bad <= Circle that “not too bad”- it does actually work… mostly! Yes, I do refer to the “dotnet watch run”. It does detect changes in your Blazor files and reload the browser page… yeah, BUT it does have issues. Here comes the list…. It doesn’t detect new files added… go ahead add a new razor page while your project is in “dotnet watch run” – nope…
-
BCP and Clustered SQL Oh the Errors
I got a curious message concerning problems that someone from work was having issues getting a relatively simple BCP (Bulk Copy for SQL) to work. So here we go: bcp "select top 5 [Data] from [ADataBase].[dbo].[ATable] where [ProcessedTime] <= GetDate()-1 and MessageType=''SomeProduct'' order by [ProcessedTime] desc for xml raw, root(''MyexportRoot'')"' + ' QUERYOUT ""B:\BCPBatch\Data\sample.xml"" -T -c -S TheSQL\Instance'; It’s a little complicated… Basically pull data from a table in DB on a SQL Instance… and output as xml to an xml file. After spending, a few hours, getting all kinds of errors about drive not found, path not found, can’t open the file… bah bah bah. It’s like what the…
-
Micro Build 2021 Is Here!
YES Build is here! I’m really liking the Backpack! ~ScottGeek
-
A slight issue when one wants to install SQL 2019 Dev, etc The ODBC 17 SQL Driver
On my way to getting the latest SQL Server installed on one of my Dev PC’s- I ran across the issue of getting prompt for: msoledbsql.msi What the hell… ODBC Driver 17 is what that is about. Apparently, the SQL installed is not smart enough to know that one already has ODBC 17 SQL Driver installed and runs into a major “cannot resolve” the problem. The end result is that one does not get the SQL instance installed… But after reading lots of “not really helping” blurbs from the Internet, the Solution is simple… well mostly. You have to uninstall the “Microsoft ODBC Driver 17 for SQL Server” – one…
