sql server compact

[Phil Longstaff]

It's not the driver that's the problem.  SQL is pretty standardized, but there are problems with the parts that aren't.  Gnucash needs to use slightly different SQL when talking to different engines.  Not hard to add a new one, but requires knowledge of the differences and a test environment.

When I get a bit of time, I could add a wiki page on the differences in SQL for the 3 different supported backends.

Phil


________________________________
 From: David T. <sunfish62 at yahoo.com>
To: John Ralls <jralls at ceridwen.us> 
Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org> 
Sent: Thursday, March 15, 2012 2:29:55 PM
Subject: Re: sql server compact
 
Ah. That's too bad. Since libdbi identifies itself as a database abstraction tool, I figured that Gnucash's use of it meant that any of its available drivers might work. Thanks for correcting me.

David



________________________________
From: John Ralls <jralls at ceridwen.us>
To: David T. <sunfish62 at yahoo.com> 
Cc: John A. Wallace <jw72253 at verizon.net>; "gnucash-user at gnucash.org" <gnucash-user at gnucash.org> 
Sent: Wednesday, March 14, 2012 9:05 PM
Subject: Re: sql server compact


On Mar 14, 2012, at 4:05 PM, David T. wrote:

> Gnucash relies on libdbi (http://libdbi.sourceforge.net/) for database abstraction. That page says that FreeTDS is a driver that will access MS SQL Server, but I haven't heard of anyone using it with Gnucash. Maybe you will be the one to try it out and report back to this group?

Even with DBI intermediating the SQL access, each SQL Server has unique setup requirements that are handled in src/backends/dbi/dbibackend.c. At present, we support *only* SQLite3, MySQL, and Postgres. We do not have the resources to support other backends, even though libdbi has drivers available for them. Sorry.

Regards,
John Ralls
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.