Home All Groups Group Topic Archive Search About

Connecting to a simply accounting database



Author
18 May 2006 6:11 PM
spiritedSmile
Hi,

I would like to write ASP code to create a custom report for a simply
accounting database.  The databse is saved with a .sdb extension.  I am
able to access the data via access or excel so I should be able to
connect to it with ASP code.  Does anyone know how?

Author
18 May 2006 6:51 PM
Bob Barrows [MVP]
spiritedSm***@gmail.com wrote:
> Hi,
>
> I would like to write ASP code to create a custom report for a simply
> accounting database.  The databse is saved with a .sdb extension.  I
> am able to access the data via access or excel so I should be able to
> connect to it with ASP code.  Does anyone know how?

What have you tried?
I'm not sure what level of experience you have. Do you know how to use an
ADO Connection object?
If not, do a search ove at www.aspfaq.com for examples of using ADO to
connect to databases.
If so, it's simply a matter of using the appropriate connection string.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Author
18 May 2006 7:59 PM
Mike Brind
spiritedSm***@gmail.com wrote:
> Hi,
>
> I would like to write ASP code to create a custom report for a simply
> accounting database.  The databse is saved with a .sdb extension.  I am
> able to access the data via access or excel so I should be able to
> connect to it with ASP code.  Does anyone know how?

That's a Sage product isn't it?  From what I can recall, the only way
to connect to a Sage database is to buy one of their proprietory
drivers (which I seem to remember ain't cheap).

However, you say you are able to access the data via Access or Excel?
Do you mean you can export to those apps, or can you actually open the
..sdb file from within Access and use Access as the front end for the
database?  If the latter, then the Access connection string is the one
you want to use from the list offered by Bob.

--
Mike Brind

AddThis Social Bookmark Button