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

General discussion forum about all databases other than SqlBase.
namita
India
Posts: 2
Joined: 27 Nov 2020, 12:45
Location: hyderabad,India

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

Post by namita » 04 Oct 2021, 17:52

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.

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 274
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand <--> Stroud, England

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

Post by Steve Leighton » 05 Oct 2021, 04:12

.
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.
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

thomas.uttendorfer
Site Admin
Site Admin
Germany
Posts: 243
Joined: 05 Mar 2017, 17:19
Location: Munich Germany

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

Post by thomas.uttendorfer » 05 Oct 2021, 15:14

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
Thomas Uttendorfer
[ frevel & fey ] Software-System GmbH
https://thomasuttendorfer.wordpress.com/

namita
India
Posts: 2
Joined: 27 Nov 2020, 12:45
Location: hyderabad,India

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

Post by namita » 06 Oct 2021, 07:56

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
India
Posts: 2172
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

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

Post by FRBhote » 07 Oct 2021, 05:30

The

comdll=sqlodb32

should be first.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest