20041 - Error - 20041: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[namita]

Hello

i am getting Error - 20041: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified while running my exe file.
My problem is working fine and connecting to database also. but when i tried to run my .exe file it is not connecting to database and giving this error.

[Steve Leighton]

.
Search for all the sql.ini files in your path. Agent Ransack is good to use. https://www.mythicsoft.com/agentransack/
Chances are your exe is picking up a rogue sql.ini with the wrong entries specified.
Rename each sql.ini , except the one that works with your .app , until the exe works.

[thomas.uttendorfer]

Hi,
find also every gupta.ini and delete it.
TD copies configuration data vom ODBC to gupta.ini and uses this information firsthand.
If you change ODBC-settings they will not get to your TD-application.
It's always safe to delete gupta.ini files!
Regards
Thomas

[namita]

i am the following sql.ini file and i am using windows 10 machine
[win32client]
clientname=Win32User

[win32client.dll]
comdll=sqlora32
comdll=sqlodb32



; -------------------------------------------------------
; Database section
; -------------------------------------------------------

[oragtwy]
remotedbname=shelby,@tns:shelby
remotedbname=buf1,@tns:buf1

longbuffer=32767
;substitute=",
;substitute=SYSSQL.,
fetchrow=20

; ODBC
[odbcrtr]
odbctrace=off
odbctracefile=sql.log
longbuffer=32767
REMOTEDBNAME=ascndbuf,DSN="ascendbuf"
REMOTEDBNAME=Fieldbuf,DSN=ThuFieldBuf
REMOTEDBNAME=Thutest,DSN=Thutest

[FRBhote]

The

comdll=sqlodb32

should be first.