Connect to SQL from MAC
lazarus / 16-Databases

----------------------------------------------------------------------
SteenJorgensen · 2015-11-14 11:02

I have big problems with connecting to MS SQL 2012 server via ODBC.
Have work on this in many days now (And night)

With the ODBCConnect component i get this error when i try to connect:
"Can not load ODBC client. Is it installed? (libodbc.dylib)"

Then i put in a SQLDBLibraryLoader component to projektet.
LibraryName=/usr/lib/libiodbc.dylib. (not libodbc.dylib)
Enable=true
ConnectionType=ODBC

Same Problems.....

ODBC is install on the MAC and testet....


In win i have no problems with the same code.

Then i have try with a MySQL56Connection component and also with bad
resuls:
"Can not load default MySQL libray....."

Maybe one have a good ide/hint?


I have Lazarus 1.44
FPC 2.6.2
i386-darwin-carbon

----------------------------------------------------------------------
SteenJorgensen · 2015-11-15 08:32

I am stuck!!! seek the libodbc.dylib-file for MAC everywhere with no
result.
Am i on the wrong road? 


procedure TForm1.Button1Click(Sender: TObject);
begin
  MYODBCConn  := TODBCCOnnection.Create(Self);
  Query       := TSQLQuery.Create(Self);
  Transaction := TSQLTransaction.Create(Self);
  LL          := TSQLDBLibraryLoader.Create(Self);
  try
    LL.ConnectionType := 'ODBC';
    LL.LibraryName    := 'libodbc.dylib';   <--- I can't find this
file?
    LL.Enabled        := True;
    LL.LoadLibrary;

    MYODBCConn.UserName    := 'sa';
    MYODBCConn.FileDSN     := 'B';
    MYODBCConn.Password    := 'pass';
    MYODBCConn.Transaction := Transaction;
    Query.DataBase         := MYODBCConn;
    Query.PacketRecords    := -1; //retrieve all data at once

    MYODBCConn.Connected := True;
    Transaction.Active := True;
    Query.SQL.Text := 'Select * from pagetable';
    Query.Active := True;
  except
    on E: Exception do
    Begin
      ShowMessage(E.Message);
    end;
  end;
end;