Raspberry pi and sqlserver
lazarus / 63-Database

----------------------------------------------------------------------
superc · 2018-06-22 14:57

Hello,
there are components can I use in Raspberry to connect to sqlserver?
Thanks in advance

----------------------------------------------------------------------
af0815 · 2018-06-22 17:56

No problem here to connect with zeos and maybe with sqldb. The correct
driver are more the problem.

----------------------------------------------------------------------
Thaddy · 2018-06-22 18:48

If you are using raspbian jessie sqldb works out of the box provided
sqlserver is installed correctly and you have a client driver
installed..
It only works with ODBC, though...

----------------------------------------------------------------------
af0815 · 2018-06-23 07:34

with $sudo apt-get install freetds-bin libsybdb5 there are the correct
freetds drives on Raspi for MS-SQL installed in
  /usr/lib/arm-linux-gnueabihf/libsybdb.so.5   (=link)
  /usr/lib/arm-linux-gnueabihf/libsybdb.so.5.0.0
with ZEOS you can access now

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        //
SQLCon is a TZConnection from ZEOS       DebugLn('Using Linux
Connection');       SQLCon.Protocol := 'FreeTDS_MsSQL>=2005';     
 {$ifdef RasPi}       SQLCon.LibraryLocation:= '/usr/lib/arm-linux-
gnueabihf/libsybdb.so.5';       {$else}       SQLCon.LibraryLocation:=
'/usr/lib/x86_64-linux-gnu/libsybdb.so.5.0.0';       {$endif}     
 SQLCon.HostName:= 'MSSQLServer';       SQLCon.User:= 'jondoe';     
 SQLCon.Password := 'secret';       SQLCon.Database:= 'mytestdb';    
 SQLCon.Properties.Add('appname=MyWorkingApp'); 
This code is working for me on Debian (PC) and Rasbian (RasPi3). Also
on windows PC with the correct driver-dll.

Actual i have not found to change the drivers-nane and position in
SQL-DB.

----------------------------------------------------------------------
superc · 2018-06-25 06:19

wow, now I will try and thank you very much  .

----------------------------------------------------------------------
marcov · 2018-06-25 06:39

Quote from: af0815 on June 23, 2018, 09:34:39 amActual i have not
found to change the drivers-nane and position in SQL-DB.

Put dblib as first unit in your .lpr and then call
dblib.initialisedblib('/position/to/libsybdb.so');

----------------------------------------------------------------------
af0815 · 2018-06-25 12:50

Quote from: marcov on June 25, 2018, 08:39:58 amPut dblib as first
unit in your .lpr and then call
dblib.initialisedblib('/position/to/libsybdb.so');
THX, Info added to the mssqlconn/dblib wiki :-)

----------------------------------------------------------------------
superc · 2018-06-25 15:27

I know Zeos from version alpha.... I've tryed and works very well....
My day is better now, thanks a lot