ODBC connection
lazarus / 16-Databases

----------------------------------------------------------------------
mlody87 · 2017-01-24 21:01

Hi!
I use Ubuntu as my server. I configure ODBC connection like this:

 odbcinst.ini:
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
[myodbc_mysql]Description     = ODBC for MySQLDriver          =
/usr/lib/i386-linux-gnu/odbc/libmyodbc.soSetup           =
/usr/lib/i386-linux-gnu/odbc/libodbcmyS.soUsageCount      = 1 
odbc.ini:
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
[myodbc_mysql_dsn]                         # this is your system
DSNDescription = description of your DSNDriver      = myodbc_mysql   
            # custom driver nameServer      = localhost              
    # or external IP if neededPort        = 3306                     
  # or custom port if neededSocket      = /var/run/mysqld/mysqld.sock
 # socket, see aboveDatabase    =                      # MySQL DB name
or emptyOption      = 3ReadOnly    = No
now when I use in terminal:
"isql -v user password"

then I get:
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
+---------------------------------------+| Connected!                
          ||                                       || sql-statement  
                     || help [tablename]                      || quit
                                ||                                   
  |+---------------------------------------+SQL> 
Looks like everything is ok. But when I configure ODBC connection i
Lazarus I cant connect. I set connection this way:

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 with
AConnection do begin      Driver := 'myodbc_mysql_dsn';     
Params.Add('Trusted_Connection=Yes');     
Params.Add('DATABASE=mydb');      Params.Add('HostName=MyHost');     
Params.Add('UserName=root');     
Params.Add('Password=password'); end; 
and this didnt work. I cant connect  Can you tell my how I should
prepare this connection?
Thx!

----------------------------------------------------------------------
LacaK · 2017-02-02 07:57

Look at http://wiki.freepascal.org/ODBCConn