Database Lookup Error TAv5
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:
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
- 0 回复