Update - 15.0.2022 - New ODBC and OLEDB Driver from MS - Update

Hi,

15.02.2022 MS has released new ODBC and OLEDB drivers for download.

Caution - Maybe dangerous update - read first

https://accessexperts.com/blog/2022/03/07/new-drivers-for-sql-server-what-you-need-to-know/?utm_source=feedburner&utm_medium=email

 

MS Info OLEDB (ADO) Download
https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15

Connectionstring Access
Provider=MSOLEDBSQL; Server=myServerName\theInstanceName; Database=myDataBase; Trusted_Connection=yes;

------

MS Info ODBC (DAO)
https://docs.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server

Connectionstring Access
ODBC;DRIVER=ODBC Driver 17 for SQL Server; SERVER=myServerName\theInstanceName; DATABASE=myDatabase; Trusted_Connection=yes;

------

mfg Klaus

 

SQL Server 2017 - CU22 verfügbar

Update - New ODBC and OLEDB Driver and SSMA from MS - Update

Hi,

in Vorbereitung auf den neuen SQL Server 2019 hat MS neue ODBC und OLEDB Treiber zum Download bereitgestellt.

In preparation for the new SQL Server 2019, MS has released new ODBC and OLEDB drivers for download.

 

MS Info OLEDB (ADO)
https://docs.microsoft.com/de-de/sql/connect/oledb/oledb-driver-for-sql-server

Download
https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server

Connectionstring Access
Provider=MSOLEDBSQL; Server=myServerName\theInstanceName; Database=myDataBase; Trusted_Connection=yes;

------

MS Info ODBC (DAO)
https://docs.microsoft.com/en-us/sql/connect/odbc/microsoft-odbc-driver-for-sql-server

Connectionstring Access
ODBC;DRIVER=ODBC Driver 17 for SQL Server; SERVER=myServerName\theInstanceName; DATABASE=myDatabase; Trusted_Connection=yes;

------

ADO / DAO Background Article (de Soto)
https://accessexperts.com/blog/2018/09/11/new-sql-server-odbc-and-oledb-driver/

-------------

SSMA

Download newest SSMA Access Version (2020_Sept_30 Vers: 8.14 - incl. Big Int und Filtered Index)
https://aka.ms/ssmaforaccess

Info SSMA - SQL Server Migration Assistant Info - Access
https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-2017

Whats new in SSMA 8.14

https://docs.microsoft.com/en-us/sql/ssma/access/what-s-new-in-ssma-for-access-accesstosql?redirectedfrom=MSDN&view=sql-server-ver15

If having installed more than one database engine the program may fail

mfg

Klaus

MS Access VBA 64bit

 

Hi,

um die Access VBA 64bit Problematik zu vereinfachen, habe ich eine Datenbank hier online gestellt, die die wichtigsten Funktionen so bereitstellt, dass sie sowohl in Access 32 als auch in Access 64bit funktionieren. Die Datenbank funktioniert in allen Versionen zwischen Access 2010 und Access 2019 (32 und 64bit). 

PS: Das Formular „frm_Font_Symbol_Wingdings“ habe ich mit einem FontSuch VBA „aufgepeppt“, finde ich jetzt ganz praktisch, den Report dazu gibt’s auch …

Das Formular _frmHlp_Sysinfo speichert automatisch beim Verlassen die Werte pro User in die tbl_SysInfo….

----------------------------------------------------------------------------------------------

To simplify the Access VBA 64bit issue, I've put a database online here that provides the key features to work in Access 32 as well as in Access 64bit. The database works in all versions between Access 2010 and Access 2019 (32 and 64bit).

PS: I've "spiced up" the form "frm_Font_Symbol_Wingdings" with a Fontsearch VBA ", I think now quite practical, the report is also available ...

The form _frmHlp_Sysinfo automatically saves the values per user in the tbl_SysInfo when exiting.

mfg Klaus

Powershell Info zu SQL Server Updates

 

Hi,

bzgl. der verfügbaren Updates im SQL-Server gibt es ein Powershell-Modul, das einem das Leben vereinfacht:

SQLServerUpdatesModule - wie immer zu haben in der MS Gallery.

Der Aufruf von:

Invoke-SqlServerUpdatesScan  Servername

Invoke-SqlServerUpdatesScan ASTERIX    (oder ASTERIX\SQLExpress)

bringt als Ergebnis:

Name : ASTERIX
Product : Microsoft SQL Server
VersionName : SQL Server 2017
Edition : Developer Edition (64-bit)
ProductLevel : RTM
Build : 14.0.3223.3
LatestUpdate :
LatestUpdateLink :
Updates : 14.0.3223.3
ToUpdate : False      <----

Dies könnte man in eine Prozedur beim Starten einbauen ....

---------------------------------------------------------------

Regarding the available updates in the SQL server, there is a Powershell module that makes life easier:

SQLServerUpdatesModule - as always in the MS Gallery.

The call of:

Invoke-SqlServerUpdatesScan server name

Invoke-SqlServerUpdatesScan ASTERIX (or ASTERIX \ SQLExpress)

brings as result:
 
Name : ASTERIX
Product : Microsoft SQL Server
VersionName : SQL Server 2017
Edition : Developer Edition (64-bit)
ProductLevel : RTM
Build : 14.0.3223.3
LatestUpdate :
LatestUpdateLink :
Updates : 14.0.3223.3
ToUpdate : False      <----
 
This could be incorporated into a procedure at startup ....
 
mfg Klaus