VBA Rubberducking

12:01 AM

RELOAD!

[banane-io/PDB] 3 commits. 28 additions. 5 deletions.

[banane-io/pdb-frontend] 1 commit. 32 additions. 19 deletions.

[Minesweeper] Games Played: 177, Bombs Used: 95, Moves Performed: 19046, New Users: 55

RELOAD!

[rubberduck-vba/Rubberduck] 5 commits. 18 additions. 26 deletions. 1 issues closed. 1 issues opened. 20 issue comments

[Zomis/Server2] 10 commits. 1016 additions. 345 deletions

the VBE - it's right for me

4:00 AM

@MathieuGuindon let coercion +

Sub LetSet(ByRef var As Variant, ByVal val As Variant)

don't judge :)

Duga

9:48 AM

[rubberduck-vba/Rubberduck] Doev added label bug to issue #5450: Can't install Rubberduck cause Windwos Defender blocks it.

[rubberduck-vba/Rubberduck] Doev opened issue #5450: Can't install Rubberduck cause Windwos Defender blocks it.

[rubberduck-vba/Rubberduck] Doev edited issue #5450: Can't install Rubberduck cause Windwos Defender blocks it.

Duga

10:35 AM

[rubberduck-vba/Rubberduck] MDoerner added label support to issue #5450: Can't install Rubberduck cause Windwos Defender blocks it.

[rubberduck-vba/Rubberduck] MDoerner removed label bug from issue #5450: Can't install Rubberduck cause Windwos Defender blocks it.

FreeMan

11:04 AM

@Duga Unfortunately, this is very unintuitive and not well documented. The wiki reads, "When synchronizing attributes, this will add or update the module's VB_Description hidden attribute:" Granted, that does say "syncing", but that one word doesn't adequately describe the process of adding the annotation, parsing the project, looking at the inspections and applying the proper fix (is there a "fix all in project" quick fix for this one?).

Duga

11:30 AM

[rubberduck-vba/Rubberduck] testingoutgith1 created comment on issue #5443: Replace CodeName with Me keyword in code behind for same worksheet

> Okay thinking about this more, wouldn't there be at least a bit of generalization, like wouldn't you want the inspection to examine userforms too, for example?

FreeMan

11:52 AM

monking @all!

Interesting, I'm not getting this when I connect to our Azure data warehouse. I don't recall having received this warning before, but I may have and may have suppressed the message on my other machine.

Since I'm not certain what these settings do, I'm pretty sure I don't use them, and that, therefore, it is reasonably safe to ignore this warning?

Cyril

12:11 PM

week 3 has commenced; hope all are well

FreeMan

All good here. Y'all surviving without homicidal thoughts toward spouse or offspring?

;)

@FreeMan "I'm not getting..." Then why the heck you posting the message, you nimnod?

If only I could blame that on autocorrect or something... There's no autocorrect on the desktop machine, just incoherent typist

out of the blue, I'm getting this error from my Access application that was working just fine earlier last week, late the week before:

Source: Microsoft OLE DB Driver for SQL Server
Error Num: -2147467259
Description: SQL Server Network Interfaces: Error reading adalsql.dll path from registry. Verify that Active Directory Authentication Library for SQL Server is properly installed. For details, please refer to go.microsoft.com/fwlink/?LinkID=513072 [2].

some searching for the description string led me to this site where he indicated that the adalsql.dll file was present on the machine in question, but wasn't registered.

I've searched my machine, but I don't have that file at all.

Do I need to install the Active Directory Authentication Library for SQL Server locally on my desktop machine?

If so, why would I suddenly need it now when I didn't need it last week?

this

12:34 PM

That is a bit strange because AIUI, that is no longer needed since 18.3 something

techcommunity.microsoft.com/t5/sql-server/…

> Embedded Active Directory Authentication Library (ADAL). A separate installation of ADAL is no longer required to use certain authentication methods.

if you somehow downgraded to pre-18.3, then yeah, that'd be why.

FreeMan

Also found this indicating it breaks with every update to SSMS.

this

Interesting. Hasn't happened to me. Yet.

FreeMan

hrm... I wonder if I did do an SSMS update last week. Yeah... I'm pretty sure I uninstalled and reinstalled everything SSMS, VS, and ADO/DAO related last week to get my laptop working.

this

Yeah, I can see it if SSMS shipped pre-18.3, then ka-boom.

FreeMan

and... I'm pretty sure I haven't used my Access app to access the Azure database since I left the office...

this

12:40 PM

Stage right enter: Nelson walking up and kicking in the nuts and ha-ha'ing.

Cyril

@FreeMan my wife may want to go jack torrence on me, but on my end we're all good and things are fine. kids still have some day care so we get a little time to work, then unwind after

FreeMan

Yeah, pretty much ^

this

I only be crawling on the walls here. That's not a big deal, right?

FreeMan

@this indicates that was released Oct '19. Since I just installed the "latest" download from MS last week, surely I'd have picked up v 18.3 or newer, right?

right?

@this you're fine. Just don't lick the toilet. That's gross.

this

Yes, the recent-ish download ought to be 18.3

@FreeMan Hmmm.....

FreeMan

12:42 PM

where can I go to determine the exact version

@this supposedly, there was some video of some idiot doing that to say "look COVID-19 isn't bad!". Maybe not, but licking the toilet bowl is gross!

under any circumstance!

Cyril

@FreeMan someone got arrested for that and is being charged for domestic terrorism, since there have been 4 persons to "take the challenge"

this

wait, wut, it was a "challenge" thing?

is grateful he does not read news

Cyril

i ~~heard~~ read about it on imgur and that was one of the top comments

this

@FreeMan boy they don't make it easy, do they?

I would presume you have to dig up the DLL itself and look at the version via Windows' file properties.

I just checked via the UDL & the opened connection string and indeed they don't deign to share it.

FreeMan

12:59 PM

@Cyril What's that old saying? "Make it fool-proof and the world will quickly make a better fool." How frickin' stupid are people these days?

this

Well, keep in the mind that turds float.

Cyril

"Intelligence is the ability to acquire and apply knowledge, and the lack of knowledge is ignorance. It is a sad world where the ignorant can stifle the intelligent, and morose when it is encouraged."

Quack Exchange

1:23 PM

0

Q: Extract data from API using VBA & XML (Performance)

First post here. I sincerely hope that I am doing everything by the book. Also, I want to thank you in advance for any help and assistance that you may be able to provide me. I have been coding VBA for 2 weeks and I realise that my code may suck. Problem: What can I do to make my code faster? I ...

FreeMan

1:39 PM

sorry... got distracted by putting my contacts in (nothing quite like the fun of poking yourself in the eye several times waiting for the lens to stick when the lens has already slipped down your finger and is no longer anywhere near where the poking part), then by the id10t telling other people to "note the self-reported data by adding an "*" to the otherwise numeric field"

ARGH!!! if the cell is supposed to contain digits, only put digits in it. If you need to make a comment about the number, then use Excel's bloody comment feature!

mansellan

ahh, regex, i'd missed you...

^(?:\d{1,4}|[0-5]\d{4}|6[0-4]\d{3}|65[0-4]\d{2}|655[0-2]\d|6553[0-4])(?:\.(?:\d{1,4}|[0-5]\d{4}|6[0-4]\d{3}|65[0-4]\d{2}|655[0-2]\d|6553[0-4])){0,3}$

FreeMan

Thinks @mansellan is a bit fevered...

mansellan

lol

FreeMan

@this I don't think I need to go find the version info, I installed using msoledbsql_18.3.0.0_x64.msi. Unless, of course, they broke the installed and shipped an older driver with the new version in the filename...

doesn't trust MS to not screw it up, searches just to be safe...

ummmm.... the file versions reported are 18. 2 .0003.0. That's not right, is it?

this

would be painfully hilarious if they shipped a `msoledbsql_18.3.0.0 ....

didn't even have to finish the sentence

FreeMan

1:53 PM

this

lemme see

mansellan

strange timing... that regex is validating version numbers.

FreeMan

Misses the joke... that's the exact name of the file I downloaded...

this

why would my windows not have the Details tab?

FreeMan

@mansellan that just looks... painful... no matter what it's doing.

mansellan

1:56 PM

yeh... thank god for online testers and cheat sheets!

this

Bizarre. Re-opened the file properties and I now see Details....

anyway it's saying the same thing as yours is.

sooo.... #BlameMicrosoft

FreeMan

@this I was trying to, but I haven't yet found my official #BlameMicrosoft inception post...

s'what'r the odds that if I uninstall, DL a fresh copy and reinstall, Imma get the exact same thing?

And why in the world is this suddenly a problem? It worked fine on my desktop machine a couple of weeks ago.

this

didn't we blame SSMS for that?

FreeMan

:derp: because this isn't my desktop machine and I must have that other driver on the desktop from somewhere for some reason

you're thinking SSMS installed an older version?

this

Yes, as per your linked SO post, no?

FreeMan

2:01 PM

reinstall from my already DLd installer should give me 18.3 instead of 18.2

@this yeah, guess that makes sense...

this

should being the operative word....

FreeMan

thought I would have installed the driver after SSMS, but who knows.

I'll do an un/re-install

sigh

this

you need to do a nasty email to MSFT, too.

mansellan

"fun" fact: .net 2.0 can run on Windows 98...

this

no way.

mansellan

2:04 PM

.NET Framework version history

Microsoft started development on the .NET Framework in the late 1990s originally under the name of Next Generation Windows Services (NGWS). By late 2001 the first beta versions of .NET 1.0 were released. The first version of .NET Framework was released on 13 February 2002, bringing managed code to Windows NT 4.0, 98, 2000, ME and XP. Since the first version, Microsoft has released nine more upgrades for .NET Framework, seven of which have been released along with a new version of Visual Studio. Two of these upgrades, .NET Framework 2.0 and 4.0, have upgraded Common Language Runtime (CLR). N...

FreeMan

not entirely sure... this looks like the stand-alone install gives me the wrong version:

will try anyway

this

hm.

yet, it's 3/24

FreeMan

which is right about the time I was attempting to beat the laptop installs into submission. I spent Monday installing everything and Tuesday reinstalling.

this

@mansellan hmm interesting, but I wouldn't be surprised if it just seized Win98 & Me up every minute or something, though.

FreeMan

reinstall can't hurt, I s'pose...

mansellan

2:07 PM

@this yeh they dropped it pretty quick. I imagine it would've been a nightmare trying to get it stable on a 9x kernel.

FreeMan

good sign (I think). uninstall went fine, but the install complained that I had SSMS open.

this

bizarre - my windows can't find the OLEDB driver in programs & features in both places.

no, that's because it's "OLE DB"

hooray!

so apparently I've been running 18.2.1

I may have had it downgraded when SSMS updated and I didn't noticed yet

oh, this gets better and better:

let's play "guess the bitness" game!

Ok, updated and now it does show 18.3.0... in the details as expected

Well, that is very good that you shared your experience. Otherwise I'd never have realized that Microsoft sneakily downgraded my driver without ever telling me about it.

FreeMan

Yup. Same here. After the reinstall, I've got 18.3.0.0

now, the real test... does my code work...

this

If doesn't, send a double nasty email to MSFT

Maybe CC Bill, Steve and Satya. That'll get their attention!

FreeMan

like a boss.

will have to remember to reinstall the driver after every SSMS update...

this

2:23 PM

at least until MSFT unfubar itself.

FreeMan

decides not to hold breath

mansellan

3:10 PM

anyone used bitbucket? I want a private repo, but I'm too cheap to pay for GH :-)

FreeMan

I've sent things to the great bit bucket in the sky, does that count?

this

@FreeMan That bytes.

FreeMan

haha

this

@mansellan only as an user. It did feel clunky compared to GH, tbh.

But if you want to be cheapo, you can just host your own git server, you know?

FreeMan

or even just put the repo on your local network

mansellan

3:15 PM

yeah I guess. was looking for something off-prem though

this

cheapo godaddy server, install git, done!

mansellan

lol true

this

ok, maybe not godaddy but any one of bajillion cheapo web hosting solution

you're basically want a off-prem storage, essentially

hmm could one git to a dropbox folder?

probably a bad idea™.

mansellan

meh, i'll park it for now, and just hope my SSD doesn't explode

it'll be going MIT on GH soonish anyway, but wanna clean house in private and would be gutted to lose it near the end

FreeMan

well, some sort of backup is always recommended. Even if it's just 2 cheapo 1TB external drives that you make backups to daily, then once a week swap for an offsite at the folks or a trusted friend.

mansellan

3:18 PM

wait, I can just plug a thumb drive in...

FreeMan

seriously, 1TB externals are a dime a dozen these days...

or that.

this

@mansellan Well, in which case, it'll be in the bit bucket!

FreeMan

:)

heck, 2 of these and an external dock is pretty cheap to not lose important stuff

and will give you acres (or hectares, your choice) of storage for years to come

mansellan

well.. I've actually got two of these - one (currently?) broken. But I moved some stuff about in the house a while ago and never got around to setting them back up. I should probably address that...

Just waiting on those 20+TB HAMR/MAMR drives that have been "a couple of years away" for like 10 years now, then I'll be rocking some serious space.

Picked up a couple of 10TB WD Reds last Prime day, wish I bought more now. Maybe this year.

FreeMan

You may be interested in unRAID. Very low cost server software. Raid-like, but, as the name suggests, not RAID. I've been running a server for about a decade now, and it grows quite nicely as needed.

Fantastic support, loads of docker support (including a git server), and I think it'll even run on repurposed QNAP hardware.

Best part is that you can grow your storage by one drive at a time and they can be any size because it's not RAID

mansellan

3:30 PM

@FreeMan Hmm, interested. The broken one has a dud backplane, which are impossible to source. I'm gonna get an electronics chap to see if it can be repaired, but if not i'll just pick up a cheap HBA and hack the enclosure/mobo to run something other than Qnap OS.

this

@FreeMan so it's a just a NAS?

mansellan

@this NAS software

this

seems naming it "unRAID" is a poor name.

FreeMan

DL a trial copy of unRAID, follow the instructions to make a bootable USB and fire it up. It runs totally off the USB and a RAM drive created on boot

this

Since one RAIDs for redundancy

mansellan

3:32 PM

Will do... Not sure if the QNAP BIOS (american megatrends) has been locked to prevent USB booting, usually the thing boots from a disk-on-module.

FreeMan

Yeah, NAS software. It does require a parity drive for data protection (1 parity drive can survive a single drive failure, dual parity can survive 2 simultaneous drive failures)

this

ahh, so that's where the "unRAID" bit comes in

FreeMan

take a look through the forums - I'm about 99.90% sure someone (or more than 1 someone) is running it on old QNAP hardware

OK, it doesn't require a parity drive, but it is recommended... ;)

mansellan

yeah the DOM is just a custom USB header, I'm sure its doable.

this

Yeah it's just that calling it "unRAID" kind of implies there's some redundancy that's not using RAID approach somehow

so if it was a mere NAS software, I'd be gobsmacked.

mansellan

3:34 PM

The working one was running raid-6 but I lost a drive

so its effectively 5 now

protip: don't buy seagates...

this

@mansellan Did they revoke your driving license for that?

FreeMan

The parity drive provides protection against data loss if a drive dies. However, I'd strongly recommend posting a question on the forums to get support on recovery.

It's shocking how many people seem to think formatting an apparently failed drive is the first step in data recovery

mansellan

wait, wut?

this

@mansellan Remember death stars?

FreeMan

@mansellan hopes he didn't follow that link earlier

mansellan

3:35 PM

@this never got bit by that, but remember the fuss.

this

Me neither but that was what made me try and avoid Seagates in my purchases.

mansellan

apparantly they're better these days. idk...

WD all the way

this

@mansellan How so western of you. :-p

mansellan

@this I'm a digital native :-)

this

pot calling kettle black

mansellan

3:39 PM

Ugh, this clickonce thing seemed such a good idea at the time. now it just feels like a slog. Maybe I need a break.

FreeMan

lol

Frankly, I've had drives of many different brands. I'm a big proponent of "whatever's on sale when I desperately need one". I had one drive go bad back in the late 80s costing me data, but most of the data loss was my own fault, not the drive's fault. Bad attempts at recovering data were to blame.

with unRAID, there's a tremendous amount of disk health monitoring & notification (if you turn it on). The only data I've lost with it was, again, user error.

I deleted about 10TB of stuff by accidentally clicking the wrong thing then letting it run a while wondering why it took so long.

Fortunately, the critical stuff was backed up, so I restored. The rest involved re-ripping DVD/Bluray disks

so that just cost time.

I did lose quite a few ZIP disks to the dreaded click-of-death, though.

ahhh... the good ol' days when 100MB on a 3.5" disk media was massive storage

this

@FreeMan provided you actually had the drive to load the disk

FreeMan

Oh I had one. Two, actually, if I remember correctly! One of the best things about the ZIP drives, is that they actually did the daisy chaining of the LPT port that USB promised and never delivered.

this

That period was kind of painful when it came to trying to transfer data between two computer via sneakernet.

FreeMan

Because of the way my desk was setup, I had the 'puter on one side and the printer on the other. I used the ZIP drive in the middle with the longest LPT cables I could find/afford on either side. It was a powered LPT extension as well as storage!

this

3:49 PM

I can't remember but there were many times where I had a zip disk and no drive; it wasn't practical to bring around the drive ( probably because it wasn't mine, or because it was shared among the family and thus had to stay with the computer ).

The other option was burning a CD. Everyone had burners, right?

yeech

mansellan

@FreeMan My current plan involves RAID-6 (or equivalent), plus also backing up rips to externals, the latter being whatever size/quality I can acquire for cheaps (within reason). Once I get enough Reds, the seagates are gonna be relegated to offline backups.

ripping takes way too long for me to trust any raid entirely

Especially UHD ripping...

FreeMan

I stick with 720p (since that's all the TV displays). Saves time & space!

mansellan

heh, 4k is like 50GB+

FreeMan

yerp.

Don't know that my eyes could tell the difference. :(

mansellan

4:04 PM

But I just rip raw, no transcoding.

Only tried a couple of UHDs so far, I don't really have a client device (or network) that's fast enough to keep up with the bitrate yet.

But usually its the native blu ray stream

IvenBach

Lazor disk all the way!

FreeMan

lol

Had a friend in college buy an LD player and some Disney disks. That was some pretty hot tech back then

mansellan

Remember Dragon's Lair?

IvenBach

Sorry. I didn't get much sleep and my brain doesn't work normally in the morning anyways.

FreeMan

oh yeah! was never any good at it, though

mansellan

4:10 PM

Never actaully played it but saw it in the arcarde

this

Had a Commodre64 port of it. Saw the youtube play of DL, and htat really made it look like a slug in comparison.

FreeMan

played the console version a few times back in the day. When they had an arcade in every mall in the country

this

Which console? Was it a good port?

FreeMan

sometimes there were 2!

sorry, stand up arcade console, not at home console. mah bad

this

oh yes

DL was one of those games that didn't port very well

IvenBach

4:29 PM

I don't think there was much to the game to begin with. I never played it so hold no attachment to it.

this

It's basically a computerized version of "choose your own adventure" books.

IvenBach

Did any of those games have much of a plot?

this

but even so, the books had more than one way to "win" but I think Dragon's Lair had only one way every time.

IvenBach

A 'But Thou Must!' railroading?

this

I don't know of any other LD games besides DL, TBH, so can't really answer.

Yes

IvenBach

4:33 PM

I was scarred by Princess Gwaelin when I could never say No.

I was like #NoMeansNo. But she just wouldn't listen.

this

You'll get the idea ifyou watch the playwithme youtube video fo the DL arcade console.

lot of button smashing required.

FreeMan

@this: any thoughts?

5 hours ago, by FreeMan

I get that connecting to our Azure db. Don't remember seeing it initially, but I may have and just clicked "Yes always"

this

Keep in mind I've never worekd with Azure data warehouse, that might be expected

FreeMan

mkay. I just assumed you were the master wizard of all databases. #BubbleBurst

this

docs.microsoft.com/en-us/sql/t-sql/statements/…

Suggests that for isolation level, READ UNCOMMITTED is the only option.

docs.microsoft.com/en-us/sql/t-sql/statements/…

Strangely, no mention about data warehouse beside that it's apparently supported

FreeMan

4:41 PM

I'd presume that our DBAs have set what they think are the best options. I just didn't recall seeing that warning. Prolly not a lot I can do 'bout it. Guaranteed there's not a lot I understand about it

this

docs.microsoft.com/en-us/sql/t-sql/statements/…

Not supported.

@FreeMan Not necessarily - that might be just SSMS' default setting, and not their doings.

FreeMan

I guess it's safe to ignore them for the future.

ah, true dat

this

I've seen lot of reports where they go "it was fast in SSMS but slow in my application WHY!"

Turns out because the settings aren't identical between the two. Yay!

FreeMan

well, Buford, if you're querying a local DB, it's gonna be faster than if you're querying one hosted on a server somewhere else

FreeMan

5:12 PM

well... that was fun...

The wife just asked, "what happened to my gmail?"

went to gmail.com and Firefox just showed an empty tab. https://www.gmail.com showed an empty tab.

calendar & photos worked just fine, gmail didn't exist.

BigBen

that's so cool

FreeMan

restarted firefox. all is better now.

weird...

of course, that interrupted me while I was trying to figure out how I'm missing 2 records for one client, and I've got 2 other clients, 1 is reporting 1 more record than it should and the other is reporting 1 less than it should.

A simple query of the DB is showing the right numbers, I'm just not picking them up in my reporting query.

le sigh...

#BorkenStoredProcedure

FreeMan

6:57 PM

AAAARRRGH!!! No wonder I was pulling the wrong numbers, the queries were looking at different date columns. :( Took a lot of looking to finally see that...

BigBen

I hate stupid issues like that

FreeMan

I'm happy that at least I found it instead of posting it somewhere and asking why I was getting the wrong data. That's much more embarrassing.

Transcript for