Hi

I am not an expert but I believe that ANSI SQL compliance does NOT
include the syntax used in Stored Procedures. I am sure you will find
that Firebird has a completely different syntax to SQL Server. My
understanding is that when you create an application to be used with
multiple databases you need limit your table definitions (nameing
conventions etc) and SQL statements to the minimums of each database
involved, i.e. you cant take advantage of any of the powerful features
of the database engines involved.

I have heard of companies that moved from just firebird/interbase to FB
and SQL server. This was made for marketing reasons but made it so that
no stored procedures could be used. This made the application somewhat
less than ideal.

AFAIK the best way to implement multiple dbs would be to provide a
middleware application that provides an consistent interface to your app
while using the SQLs appropriate for whatever DB you are connected to.

I am no expert and am sure others will be able to provide more information.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



kogerbnz wrote:

> Hello
>
> I have a design question for my application.
> I'm going to make a Windows application that uses Firebird TODO:
> embedded? and MSSQL server. I don't know either of the two databases
> very well, AFAIK Firebird is more ANSI complient(TODO=).
> Right now I'm wondering if it would best to make the SQL statements as
> stored procedures or make a SQL statements module in the application.
> I'm thinking that the last solution would be the best, because I will
> only have to write the procedures once. I assume that the statements
> for both databases will mostly be the same.
>
> What do you think, did I forget something?
>
> Thank you very much in advance,
> Karsten
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>