>Is there
something else I need to set to be able to find the problem?
- you need to know how Tie::RDBM is working
- you need to know Firebird specific DBD driver settings
- you need to know the Firebird specific data types to be used with
Tie::RDBM
- you possibly need to change (add) Firebird specific settings in the
assp.pl (sub init)
- you have to define the import SQL statement for Firebird in the
assp_db_import.cfg file
>I'm seeing ASSP errors on startup relating to illegal tokens
ASSP uses Tie:RDBM -> used ANSI SQL
Without any Firebird specific changes the following data types are used:
pkey pvalue pfrozen
varbinary(254) varbinary(255) integer
$Tie::RDBM::CAN_BIND{Firebird} is undef
the import definitions from assp_db_import.cfg (used in sub importDB)
are the default ANSI-SQL:
$sql_sm="ALTER TABLE $mysqlTable DROP CONSTRAINT $PK_NAME"|$sql_sm="ALTER
TABLE $mysqlTable ADD CONSTRAINT $PK_NAME PRIMARY KEY
(pkey)"|$sql_sm="INSERT INTO $mysqlTable SELECT
"|$sql_sm="CONVERT($pkey_TYPE_NAME,$k),CONVERT($pvalue_TYPE_NAME,$v),CONVERT($pfrozen_TYPE_NAME,\'$f\')"|$sql_sm="UNION
ALL SELECT "|2000
Thomas
Von: "Daniel L. Miller" <[email protected]>
An: ASSP development mailing list <[email protected]>,
Datum: 11.07.2012 19:02
Betreff: [Assp-test] Firebird as database
I'm trying to use Firebird instead of Mysql. I've installed the perl
driver, and ASSP lists it as available in the possibilities for
DBDriver. I'm seeing ASSP errors on startup relating to illegal tokens
- which I think means ASSP is talking to Firebird just using improper
syntax.
I've set DatabaseDebug on - didn't change anything else - but I don't
see anything new in the log files nor any new debug files. Is there
something else I need to set to be able to find the problem?
--
Daniel
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Assp-test mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Assp-test mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test
