RE: [Fastcgipp-users] Understanding if/how to use MSSQL as the database engine instead of MySQL

[Bryan Seeds]

Eddie,

You rock thanks.. =) kind of what I figured, well I have a desire to get it
to work, guess I got a lot of studying to do =)  Might pick your brain from
time to time, thanks!


-Bryan


-----Original Message-----
From: Eddie Carle [mailto:address@hidden 
Sent: Monday, November 16, 2009 4:38 PM
To: Bryan Seeds
Cc: address@hidden
Subject: Re: [Fastcgipp-users] Understanding if/how to use MSSQL as the
database engine instead of MySQL

On Mon, 2009-11-16 at 10:24 -0600, Bryan Seeds wrote:
> I would like to try to connect to a MSSQL database and run queries.
> What do I have to do to change the database engine.. Do I need to 
> extend the ASql::ConnectionPar, is there any resources I can read into 
> or a starting point that any of you guys can share to get me in the 
> right direction?  Has any tried this?

There isn't really any doc explaining how to expand ASql to handle other
database types. You would basically have create an ASql::MSSQL namespace
that defines things the same way as ASql::MySQL. The classes and templates
defined in ASql are very basic and just provide a dirty concept of how it
should be done along with some classes and helper functions I figured would
be useful for other database types.

You'd have to look through all the doxygen docs and code for ASql::MySQL and
try to figure out what I was thinking:) Maybe go through the flow of the
database example. It covers most of the ASql functionality but not
everything. Beware the code is still in a development stage. I've been
deploying ASql separate from fastcgi++ in a few projects and still haven't
figured out an ideal way to handle transactions. If you've got the fortitude
to tackle that I'd be happy to answer any questions you've got.
Unfortunately I've no experience with MSSQL and no real motive to implement
for my own uses.
--
        Eddie Carle