Database Lookup Error TAv5

Hello
We are trying to do a lookup of a database that worked fine in TAv4 but now does not.
I have attempted to transpose what was in TAv4:

Lookup Field , Database Connection String
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DATABASE=cncapps;DESCRIPTION=CNCCRM-CNCAPPS;DSN=CNCCRM-CNCAPPS;OPTION=0;PORT=0;SERVER=CNCCRM;UID=autorequest;";Initial Catalog=cncapps

Lookup SQL Select Statement:
SELECT contact.con_email
FROM contact
INNER JOIN customer ON contact.con_custno=customer.cus_custno AND con_mailflag9 = 'Y' AND ACTIVE = '1'
AND con_custno = (SELECT LEFT('%msg_to%',LOCATE('@','%msg_to%')))

With a Database Field Name of EmailAddress1

and in TA v5 I am unable to use the same Database Connection String as i get errors about "keyword is not supported: extended properties" or DSN if i edit out the issues until i am forced to connect with a user name and password which pulls nothing through at all.

The failure message states
2022-12-19:17:56:26 Variable EmailAddress1 Set To: Line: 5
2022-12-19:17:56:26 *Could not read from column EmailAddress1 in database lookup. Column does not exist Line: 6

Do i need to do anything with the OBDC 32 Bit System DSN at all (runs 32 bit MySQL ODBC 3.51 Driver and we are using MySQL v8.x, i have installed ODBC 8.0 and added the Unicode Drivers to the ODBC 64 Bit but no joy.

Thanks in advance

Matt