ODBC string Connection Error
lazarus / 16-Databases

----------------------------------------------------------------------
eldonfsr · 2022-12-22 18:16

Hello I star testapp with odbc, I tested the odbc or datasource create
on windows odbc , also i tested with c# but when try that on lazarus
send me error....
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 {$ifdef
CPU32}    ODBCCon.Driver:='MAS 90 32-Bit ODBC Driver';  {$endif} 
{$ifdef CPU64}    ODBCCOn.Driver:='MAS 90 32-Bit ODBC Driver'; 
{$endif}    ODbCCon.FILEDSN:='DSN=MAS90_ODBC;UID=ep;PWD=5807;Directory
=C:\\Best\\version4\\mas90;IniFile=providex.ddf ; Company=001;LogFile=
\\PVXODB32.LOG;BurstMode=0;DirtyReads=0;CacheSize=4;EnforceNULLDate=0;
SERVER=NotTheServer;StripTrailingSpaces=1'  You can see error and odbc
datasource test connection sad is good... I teka e values from
odbcsource on sonnection string..

----------------------------------------------------------------------
Zvoni · 2022-12-23 07:32

Why are you assigning the Connection-String to FILEDSN-Property???
And either you have a DSN, in which case you shouldn't need a
connection-string defining Driver and whatnot, or you don't

and i was under the impression, that the Driver-Name has to be put in
curly brackets

----------------------------------------------------------------------
eldonfsr · 2022-12-23 18:10

Yes is true. well you know when you tried diferents ways  is possible
make a mistake... now i more confident as i get better
understand.......

some time when you receive error is not clear what is wrong....

Thanks for you advance....