Problem connecting to DB via ODBC in Windows 10
lazarus / 16-Databases

----------------------------------------------------------------------
Vodnik · 2019-09-09 15:02

My application works fine on Win 7 and Win 2012 server, but on Win 10
reports an error: Could not connect with connection string "DSN=... 
(see screenshot). Some time ago I have found a solution in internet -
switch off Windows manifest in Project / Options / Compiler. But now
it doesn't work anymore
I have no Win 10 PC, problem is reported by users.
Lazarus v1.8.4
Any ideas?
Users seems to have Russian interface in Win 10, that results with
unreadable error message. My application is fully in English. How can
I make error message readable?

----------------------------------------------------------------------
wp · 2019-09-09 16:17

Which kind of DB?

----------------------------------------------------------------------
Vodnik · 2019-09-09 19:03

Informix

----------------------------------------------------------------------
wp · 2019-09-09 22:11

Sorry, no idea about this one. I just want to note that the bitness of
the ODBC driver must match the bitness of the application. IOW: when
you compile a 32-bit application you need a 32-bit driver, for a
64-bit application you need a 64-bit driver. And I should also note
that sometimes the 64-bit drivers do not work

----------------------------------------------------------------------
af0815 · 2019-09-10 05:57

This look like the dialog have not the possibility to handle the
charset of the driver message.

Is it possible to catch the message as an exception and write it to a
utf-8 file ?

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i    try    
 Connection.Connected:=true;        if
not(GetConnectionUser.Connection.Connected) then begin         
DebugLn('Cannot connect to DB');        end;    except      on E:
Exception do begin        DebugLn( 'Connection not possible -
Connection Exception: '+ E.Message);       // here you can write the
exception to a file if you want      end;    end;

----------------------------------------------------------------------
Vodnik · 2019-09-10 10:32

@wp, application is 32 bit, ODBC driver is 32 bit, too.
Seems that discussion https://forum.lazarus.freepascal.org/index.php/t
opic,14203.msg74980.html#msg74980
may be relevant to my problem...

----------------------------------------------------------------------
Vodnik · 2019-09-12 13:52

This was my stupid mistake...
DatabaseName = "CRS" and Connected = True in TODBCConnection, this is
comfortable at design time.
UserName and Password are empty, they are set in ODBC driver.
Application tries to connect to DSN "CRS" at start time, before user
select another DSN in application.
This works when there is DSN with name "CRS" at user's PC and cause
error when not.
So unchecking Connected (False) solved the problem.

Question still left is what to do to make error message readable on
Russian Windows.