Subject Cannot write data to Firebird on Windows 2003 server SQL error -206
Author stevedude652
As a summary of the problem; on the production system, we seem to be
able to read data from the database, but not write the data to the
database using the Scheduler application. Also:
1. He is running the production system on Windows 2003 which is the
one that is failing to write at the moment. The error given is SQL
error -206, Column unknown. However the column is in the database.
2. He can run the same app and database on his test system (Windows
XP) which runs fine.
3. Also note that the production system is a VM.
4. Also see the below trail of e-mails

If anyone has any ideas, please let me know as I am out of ideas.

Thanks before hand,


From: Adrian
Sent: Friday, July 11, 2008 6:13 PM
To: 'Steve '
Subject: RE:

Hello Steve,

I installed and am running scheduler as the same user, (not admin but
an administrator) (I added write and modify to users group and it
still failed, all other groups had write permissions already)

I am fairly sure I only moved the database around using the backup and
restore method but I can try rebuilding that database. (note: when I
moved this database back to the test server it worked correctly, hence
it is probably ok)

I have tried upgrading firebird (1.5.5) – no change

I have tried 2 versions of IB Provider – both work for reading but
same results for the write

I have tried using both of the drivers provided by IB Provider in the
connection string – both work for reading but same results for the write

The server is a VM, are there any possible issues that may arise from

Also I was wondering about the last 2 lines in the log. Are the
updates actually working and just the inserts are failing or is there
some missing failure information?

[5592][1][100/16-34-026-13W4/00 Meter] Meters Table : Successfully
updated Meters table in the database
[5592][1][100/16-34-026-13W4/00 Meter] Meters Table : Successfully
updated meters table with new dates/sequence

If the updates are working I will have to try full control on the
related file permissions.


From: Steve
Sent: Friday, July 11, 2008 2:17 PM
To: 'Adrian '
Subject: RE:

A couple of comments/suggestions: First, if you
installed the app as admin and then are running it as a different
user, it may cause a write issue. When the Scheduler starts up, it
just reads configuration information; not until it reads data from a
device does it write to the database so it could be a permission
issue. If you right-click on the Scheduler and give it write
permission, then that may clear it up.

Also, and I'm sure you are aware of this, if you move a database you
must ensure that no app is connected to the database or you may
corrupt the database. I just thought I would mention that.

I hope this helps, if I think of anything else, I'll let you know.


From: Adrian
Sent: Friday, July 11, 2008 12:56 PM
To: 'Steve '

Hello Steve,

I have checked out the connection string on both the test server and
the server, they are identical other than the location. (Works fine on
our server not on the server)

I have tried using LCPI.IBProvider 1 and 2, both have the same
results, (it must able to read from the database since it does find
and execute the schedule)

Any ideas?

If you have some time I can get you on the server and you can see if
you can find anything.