Im Connecting MY SQL To Tally Connection String is Not Working How Solve this problem [#Menu: Gateway of Tally] Add: Button : ConnectionStatus [Button: ConnectionStatus] Title : $$LocaleString:"Connection Status" Key : ALT+C Action : Call : SQLConnectionStatus [Function: SQLConnectionStatus] Variable : vNumItemsInColln : Number: 0 Local Formula : vDATABASE_TOTAL_TABLES : $$Number:$$CollectionField:$_1:1:SQLSERVERODBCConnectionWithPortNo 100 : LOG : "**********************************" 120 : Log : $$String@MachineTime + ": Checking Connection Status" 130 : Set : vNumItemsInColln : @vDATABASE_TOTAL_TABLES 150 : Do if : ( ##vNumItemsInColln < 1 ) : LOG :" Error!!!" + " Connection Failed !! Please check your Internet connection Or SQL Server Cofiguration Settings in Tally Or SQL OBDC Driver in Local System" 160 : Do if : ( ##vNumItemsInColln > 0 ) : LOG :" Success!!" + " Connection established successfully" 170 : LOG : "**********************************" [Collection:SQL SERVER ODBC Connection With PortNo] ODBC : "Driver="+@@ODBC8Driver+";Server="+"localhost"+";Port="+"3306"+";Database="+"Focs_tally"+"USER="+"root"+";PASSWORD="+"Your_Password; OPTION=3" SQL : "SELECT COUNT(*) from information_schema.tables WHERE table_type = 'base table'" Client Only : Yes Option : SQL SERVER ODBC Connection WithOut PortNo : $$IsEmpty@SQLSERVERMDBPortStr [System: Formula] ODBC8Driver : "{MySQL ODBC 8.0 Driver}"