Subject | cross-database queries using execute statement |
---|---|
Author | gita.psari |
Post date | 2011-07-22T08:23:15Z |
Hi,
I am using cross-database queries by this script
FOR EXECUTE STATEMENT
'select code, name from TMaster where group = 'A' '
ON EXTERNAL DATA SOURCE '[IP Adrress]:\Data\DB\master.fdb' AS USER 'u' PASSWORD 'p' ROLE 'R'
into :code, :name do suspend ;
previously this script is running well, until today we have upgrade operating system of the database server
and change the installed firebird database from classic server to super server.
To activate the database we just use the existsing fdb file and not backup and restored the database.
After that when I execute the script it is always not responding.
After we restart firebird service, execute process of this script is normal.
Although the problem was solved, I still need to know about the couse of problem.
Can anyone tell me ?
Thanks
I am using cross-database queries by this script
FOR EXECUTE STATEMENT
'select code, name from TMaster where group = 'A' '
ON EXTERNAL DATA SOURCE '[IP Adrress]:\Data\DB\master.fdb' AS USER 'u' PASSWORD 'p' ROLE 'R'
into :code, :name do suspend ;
previously this script is running well, until today we have upgrade operating system of the database server
and change the installed firebird database from classic server to super server.
To activate the database we just use the existsing fdb file and not backup and restored the database.
After that when I execute the script it is always not responding.
After we restart firebird service, execute process of this script is normal.
Although the problem was solved, I still need to know about the couse of problem.
Can anyone tell me ?
Thanks