Hello,

I'm a newbie and am trying to transfer a pretty straightforward database from MS SQL Server 7 to Firebird 2.1.3 on Windows Web Server 2008 R2.

To start, I downloaded and installed FlameRobin. I've found a website that tells me what data types to use in Firebird. Using FlameRobin, I'm trying to run the following CREATE TABLE command:

CREATE TABLE Addresses
(
AddressID {INTEGER} NOT NULL ,
CustomerID {INTEGER} NOT NULL ,
Name {VARCHAR} NOT NULL ,
Company {VARCHAR} ,
Address1 {VARCHAR} NOT NULL ,
Address2 {VARCHAR} ,
City {VARCHAR} NOT NULL ,
Region {VARCHAR} NOT NULL ,
PostalCode {VARCHAR} NOT NULL ,
Country {VARCHAR} NOT NULL ,
Phone {VARCHAR}
);

What I get back is:

Error: *** IBPP::SQLException **
Context: Statement::Prepare( CREATE TABLE Addresses
(
AddressID {INTEGER} NOT NULL ,
CustomerID {INTEGER} NOT NULL ,
Name {VARCHAR} NOT NULL ,
Company {VARCHAR} ,
Address1 {VARCHAR} NOT NULL ,
Address2 {VARCHAR} ,
City {VARCHAR} NOT NULL ,
Region {VARCHAR} NOT NULL ,
PostalCode {VARCHAR} NOT NULL ,
Country {VARCHAR} NOT NULL ,
Phone {VARCHAR}
))
Message: isc_dsql_prepare_failed

SQL: Message: -607
The operation is not defined for system tables.

Engine Code : 335544569
Engine Message:
Dynamic SQL Error
SQL error code = -607
Invalid command
Specified domain or source column {INTEGER} does not exist

I've searched and found these error messages in lists and have yet to find an explanation as to why they would appear. It seems Firebird is thinking I'm trying to create a system table. What do I put in the command to tell it this is a regular (or user?) table? I've tried adding the database name and a period but gave me another error.

Any pointers would be greatly appreciated!