User Profile
MDell_Seradex
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Feb 2024 updates: Access->SQL Server performance issues in the Monthly Enterprise Channel
Karl_Donaubauermy apologies for the confusion, as I hadmeant a support article about the bug, not about turning it off. Thank you for the information. I do appreciate the clarity on how this works. So the reality of this is that Microsoft didn't reach out to our systems to adjust them, but instead our systems reach out to Microsoft to see if any new features should be disabled. Of course that would not work in environments where the user does not have access to the internet. The reason I am asking about this is because I have recently encountered what seems to be the same issue using "10.00.19041.4717" of the SQL Server driver. Just for transparency so you can confirm that, the symptoms I experience matches this bad behaviour, I am including them here: An application uses ADODB and the MSJet 4.x engine sends an INSERT INTO ... SELECT ... to an mdb file pushing data into an ODBC linked table from a specific source table with direct column to column mapping. That command is transformed into multiple INSERT INTO ... VALUES ... statements on SQL Server (which sounds normal). The performance of these is a bit slower than expected, but functional, until the default timeout of 30s is reached. If the ADODB.Connection has the "Jet OLEDB:ODBC Command Time Out" property set to say 300, it will continue, otherwise it will fail with a generic ODBC error. With the extended timeout, the submission of the VALUES commands slows down to about 1/min for several commands and then will speed up again, slowing down again after another 30s. This will continue until the command completes, sometimes taking longer than the 5m command timeout set on the connection (Connection.CommandTimeout property). I tried to use the "ODBC Driver 17 for SQL Server" instead as it was indicated that this does not have that issue, but that does not seem to be compatible with the MSJet engine 4.x provider. We are currently limited to using that because we have a 32-bit app and we cannot guarantee the 32-bit ACEDB drivers are installed. Unfortunately, it seems like the latest version of the ACEDB driver (Office 2021) is not downloadable. Note that Office is not actually installed on the affected machine. I will ask our IT to investigate the feature flag functionality to ensure that isn't blocked. If you have any additional information that you feel would be helpful, or can direct me to useful resources, I would appreciate it. Thank you1.1KViews0likes0CommentsRe: Feb 2024 updates: Access->SQL Server performance issues in the Monthly Enterprise Channel
Karl_DonaubauerHow could Microsoft have fixed the issue remotely without some kind of release? This makes it sound like they have remote access to our systems? Is there a support article about this?1.1KViews1like2CommentsRe: Unable to edit Outlook Meeting's body text (I'm not the organizer).
This new behaviour is a surprise and is kind of annoying. What before required no clicks to edit now requires two that include dismissal of an "Are you sure" prompt. I would like to be able to say "Don't tell me again."7.8KViews0likes0CommentsRe: How to report a bug in Windows?
I have posted a bunch of things to there about Windows 10, or apps on Windows 10, never to receive any feedback. A few things have actually been fixed, but still no feedback. Also, it sucks that there is no way to mark feedback as closed/fixed, so it keeps showing up when you go to look at your list. Also, the feedback app typically wants to record what happened and gather info from your PC. That is useless for Server feedback.2.2KViews0likes1Comment