| Subject | RE: [firebird-support] Re: Error loading DB using FB 2.1.3 |
|---|---|
| Author | Dunbar, Norman (Capgemini) |
| Post date | 2010-08-10T15:27:03Z |
Afternoon,
-create on the command line. I wasn't sure if you were doing that or had
pre-created the new database and then tried to restore the data. Thanks.
You don't have any dates in your database that are greater that December
31 9999 or less than January 1 0001 do you? I assume the lowest time
portion of the date is 00:00:00.0000 and the maximum is 23:59:59.9999.
This would be in the LOADS table.
What is the result of selecting the min() and max() for the date
column(s) in this table - maybe there's a clue there. Just in case, in
isql (if you are using that) the default is not to display the TIME
part, you might need to execute "SET TIME;" to make isql display the
time portion of the DATE column.
Cheers,
Norman.
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
>> The original DB is dialect 1. If I am using gbak to restoreGbak will indeed create a new database with dialect one, if you use the
>> the DB the the new DB must also be dialect 1. But just on
>> the off chance, I checked the new database. It is dialect 1.
-create on the command line. I wasn't sure if you were doing that or had
pre-created the new database and then tried to restore the data. Thanks.
>> As long as both DBs are dialect 1 a DATE is a TIMESTAMP andIn dialect 1, a DATE is a TIMESTAMP, yes.
>> I should have no problem. Correct??
You don't have any dates in your database that are greater that December
31 9999 or less than January 1 0001 do you? I assume the lowest time
portion of the date is 00:00:00.0000 and the maximum is 23:59:59.9999.
This would be in the LOADS table.
What is the result of selecting the min() and max() for the date
column(s) in this table - maybe there's a clue there. Just in case, in
isql (if you are using that) the default is not to display the TIME
part, you might need to execute "SET TIME;" to make isql display the
time portion of the DATE column.
Cheers,
Norman.
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk