By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,304 Members | 2,064 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,304 IT Pros & Developers. It's quick & easy.

Connecting to a simply accounting database

P: n/a
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?

May 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
sp***********@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.
May 18 '06 #2

P: n/a

sp***********@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

May 18 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.