printreptopdf on ubuntu

[bms jkt]

hi , in past i use reportman in windows which is very good ,

now i need to create pdf on fly with printreptopdf on ubuntu with nodejs and firebird ,

i've downloaded reportman linux but don't know where to put those files  (dbxconnections, dbxdrivers, libdbx*.so, etc), to which folder in ubuntu ,

please help me , thank's a lot.

[Toni Martir]

https://reportman.sourceforge.io/doc/installlin.html

I will update the docs soon with the new updated Linux command line tool in mind.

But the path for configuration files is still valid.

Of course linux could be harder to configure, but most of the drivers are statically linked into the printreptopdf executable, so only vendor libs (or odbc libs) should be needed.

--
You received this message because you are subscribed to the Google Groups "reportman" group.
To unsubscribe from this group and stop receiving emails from it, send an email to reportman+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/reportman/07b9f729-7e04-4d2b-92b2-6ae673cfd363n%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Toni Martir

[bms jkt]

i use unixODBC(v239) downloaded from https://www.unixodbc.org/ ,
with firebird odbc libOdbcFb.so downloaded from https://github.com/FirebirdSQL/firebird-odbc-driver ,

then i fill /etc/odbcinst.ini with:
[Firebird]
Description = Firebird ODBC Driver
Driver = /usr/lib/libOdbcFb.so
Setup = /usr/lib/libOdbcFbS.so
Threading = 1
FileUsage = 1
CPTimeout =
CPReuse =

and /etc/odbc.ini with:
[bms_srbrc]
Description = Firebird bms_srbrc
Driver = Firebird
Dbname = localhost:/home/share/bms/srbrc/db/sr_brc.fdb
User = SYSDBA
Password = masterkey
Role =
CharacterSet =
ReadOnly = No
NoWait = No

and do a test with isql/unixODBC ==> result it can connect and query firebird database,

then i fill dbxconnections with:
[srbrc]
DriverName=OpenODBC
Database=DSN=bms_srbrc

and dbxdrivers with:
[OpenODBC]
GetDriverFunc=getSQLDriverODBC
VendorLib=libOdbcFb.so
LibraryName=libdbxoodbc.so
Database=ODBC DSN name, or ODBC connection string (DSN=SAMPLE;LANG=chineses..) or ? for Driver Prompt
User_Name=user name (can be ommited)
Password=password (can be ommited)

and do a test with printreptopdf(v375) ,
but it give me message ==> "table_name":Database driver not supported  - SQL Express (DBX) ,

as of mentioned in repman documentation , i try to copy dbxconnections and dbxdrivers to:
~ current folder where printreptopdf stored
~ /home/user1/.borland (user1 is my username)
~ /usr/local/etc
~ /opt/kylixlibs
~ also try to copy dbxconnections to dbxconnections.conf and dbxdrivers to dbxdrivers.conf
but still get the same message as a result ,

please help me , thank's a lot.

[Toni Martir]

AFAIK  SQL Express is not supported in Linux (by Embarcadero Delphi) , use Firedac or Zeos drivers.

Setup a Firedac ODBC connection in Windows ODBC, Firebird ODC, so you can test the report in the designer, then copy configuration files to Linux. 

To view this discussion visit https://groups.google.com/d/msgid/reportman/a3e88ee4-baae-4c07-8e38-a744402789c0n%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Toni Martir

[bms jkt]

thank you.