Subject | Newbie: problems with ODBC |
---|---|
Author | washito2 |
Post date | 2002-01-21T22:45Z |
Hi, I'm moving from MS SQL Server to Interbase and have a question.
I have installed Interbase (Firebird Release 0.9-4 Test 1) with
Interbase ODBC 3.0 Driver in a server Windows 200 Server SP 2, and in
the client I have Windows 98 SE.
1) If I create a table in the client, I can use it in the client and
in the server, but if I create the table in the server (with
ibConsole) and try to use it in the client via ODBC I receive the
following message
Table "xx" has no columns, possible invalid table format.
2) If I want to create a table in the client with the next format
Create table xx ( yy decimal(p,s))
or Create table xx ( yy numeric(p,s))
it works with p <= 8, but with biggers numbers the following message
appears:
SQL Error Code=-817. Metadata update statement is not allowed by
the current database SQL dialect 3.
If somebody could help me...
Thanks
I have installed Interbase (Firebird Release 0.9-4 Test 1) with
Interbase ODBC 3.0 Driver in a server Windows 200 Server SP 2, and in
the client I have Windows 98 SE.
1) If I create a table in the client, I can use it in the client and
in the server, but if I create the table in the server (with
ibConsole) and try to use it in the client via ODBC I receive the
following message
Table "xx" has no columns, possible invalid table format.
2) If I want to create a table in the client with the next format
Create table xx ( yy decimal(p,s))
or Create table xx ( yy numeric(p,s))
it works with p <= 8, but with biggers numbers the following message
appears:
SQL Error Code=-817. Metadata update statement is not allowed by
the current database SQL dialect 3.
If somebody could help me...
Thanks