Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2012-05

Missing some database components

4 messages · 2 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

William Oliveira Ferreira

I'm seeing that registersqldb.pas try to register all connectors (if it corresponding flag is active). So, i'm seeing too that TMSSQLConnection, TSyBaseConnection, TMySQL55Connection and TFBAdmin aren't available to drop on my projects. How can i install them?

procedure RegisterUnitSQLdb;
begin
  RegisterComponents('SQLdb',[TSQLQuery,
                              TSQLTransaction,
                              TSQLScript,
                              TSQLConnector,
{$IFDEF HASMSSQLCONNECTION}
                              TMSSQLConnection,
{$ENDIF}
{$IFDEF HASSYBASECONNECTION}
                              TSybaseConnection,
{$ENDIF}
{$IFDEF HASPQCONNECTION}
                              TPQConnection,
{$ENDIF}
{$IFDEF HASORACLECONNECTION}
                              TOracleConnection,
{$ENDIF}
                              TODBCConnection,
{$IFDEF HASMYSQL4CONNECTION}
                              TMySQL40Connection,
                              TMySQL41Connection,
{$ENDIF}
                              TMySQL50Connection,
{$IFDEF HASMYSQL51CONNECTION}
                              TMySQL51Connection,
{$ENDIF}
{$IFDEF HASMYSQL55CONNECTION}
                              TMySQL55Connection,
{$ENDIF}
{$IFDEF HASSQLITE3CONNECTION}
                              TSQLite3Connection,
{$ENDIF}
                              TIBConnection
{$IFDEF HASFBADMIN}
                              ,TFBAdmin
{$ENDIF}
                              ]);
end;
________________________________ William de Oliveira Ferreira Bacharel em Sistemas de Informa??o -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20120520/484f64c4/attachment-0001.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: Captura_de_tela.png Type: image/png Size: 13657 bytes Desc: not available URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20120520/484f64c4/attachment-0001.png>

Reply by email

Reinier Olislagers
to William Oliveira Ferreira
William Oliveira Ferreira wrote
I'm seeing that registersqldb.pas try to register all connectors (if it corresponding flag is active). So, i'm seeing too that TMSSQLConnection, TSyBaseConnection, TMySQL55Connection and TFBAdmin aren't available to drop on my projects. How can i install them?

You haven't mentioned Lazarus+FPC version+platform, which would surely have been helpful...

The secret is indeed in the flags... They are meant to make sure that people seeing the components on the palette actually can use them as well.

The flags are defined earlier based on FPC version and platform, depending on which FPC version supports the underlying components.

E.g. FBAdmin depends on the FPC TFBAdmin component, which is only available on FPC trunk.

IIRC, MSSQLConnection depends on FPC fixes 2.6 (=2.6.1) or higher, and will run on all major platforms except OSX.
Same for Sybase.
(Note: you'll also need the FreeTDS library installed to connect to a database, similar to how you would install a PostgreSQL or Firebird driver).

You might want to upgrade to a newer snapshot/version of FPC+Lazarus that uses FPC 2.6.1.

Either that, or compile the relevant db units yourself in an earlier FPC version.
I don't think FBAdmin will have big problems (but don't know the code too well). Sybase/MSSQLConnection will work on FPC 2.6.0, but you'll need to adapt it a bit on 2.4.x

Good luck!

Reply by email

William Oliveira Ferreira
to Reinier Olislagers

2012/5/21 Reinier Olislagers

You haven't mentioned Lazarus+FPC version+platform, which would surely have been helpful...

Both Linux and Windows, trunk from last saturday morning. FPC 2.6.0 on Windows and Linux.

The secret is indeed in the flags... They are meant to make sure that people seeing the components on the palette actually can use them as well.
Show quoted text 6 lines
The flags are defined earlier based on FPC version and platform, depending on which FPC version supports the underlying components. E.g. FBAdmin depends on the FPC TFBAdmin component, which is only available on FPC trunk.

So, i must use fpc 2.7.1 to enable it, ok?

Show quoted text 16 lines
IIRC, MSSQLConnection depends on FPC fixes 2.6 (=2.6.1) or higher, and will run on all major platforms except OSX. Same for Sybase. (Note: you'll also need the FreeTDS library installed to connect to a database, similar to how you would install a PostgreSQL or Firebird driver). You might want to upgrade to a newer snapshot/version of FPC+Lazarus that uses FPC 2.6.1. Either that, or compile the relevant db units yourself in an earlier FPC version. I don't think FBAdmin will have big problems (but don't know the code too well). Sybase/MSSQLConnection will work on FPC 2.6.0, but you'll need to adapt it a bit on 2.4.x

Thanks, i'll try it.

________________________________ William de Oliveira Ferreira Bacharel em Sistemas de Informa??o -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.lazarus.freepascal.org/pipermail/lazarus/attachments/20120521/9258aed8/attachment-0001.html>

Reply by email

Reinier Olislagers
to William Oliveira Ferreira
William Oliveira Ferreira wrote 9 lines
2012/5/21 Reinier Olislagers < <mailto:>> You haven't mentioned Lazarus+FPC version+platform, which would surely have been helpful... Both Linux and Windows, trunk from last saturday morning. FPC 2.6.0 on Windows and Linux.

Perhaps you could move to fixes 2.6 (aka 2.6.1)... a lot of goodies get backported ;)

Show quoted text 5 lines
E.g. FBAdmin depends on the FPC TFBAdmin component, which is only available on FPC trunk. So, i must use fpc 2.7.1 to enable it, ok?

Yep...

Reply by email