My SQL Connection String is Not Working

Discussion in 'Free Source Codes' started by Sadakkatha, Feb 11, 2022.

    
  1. Sadakkatha

    Sadakkatha New Member


    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:mad:@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:mad:@SQLSERVERMDBPortStr


    [System: Formula]

    ODBC8Driver : "{MySQL ODBC 8.0 Driver}"
     


Share This Page