re: [Dev-C++] Access databases

[Derick v. N. <der...@go...>]

----- Original Message -----=20
From: "Mark Livingstone" <mli...@ip...>
To: <dev...@li...>
Sent: Tuesday, May 13, 2003 3:50 AM
Subject: Re: [Dev-C++] Access databases


On Mon, 12 May 2003 08:38:52 +0200
"Derick van Niekerk" <der...@go...> wrote:

> I am sure I'd be able to find an odbc wrapper but I was thinking more
> along the lines of how M$VC++ is able to access an access database
> without needing to have the datasources set up under ODBC sources.

In which case, you are gettin gout of the GPL world and gettin ginto the
MS specific world of OLE / COM / ADO + other acronyms :-)

I figured as much. As I mentioned before there is a time constraint =
(about 2 weeks). I already have the database set up, so pulling reports, =
issuing queries, input forms and basic transactions are already sorted. =
All I need to do is write a small program to read from the serial port =
and write into the database. The rest is already done. Rewriting the =
program with all the functionallity it has now will take me more than 2 =
weeks - espescially if I need to learn a few new libraries.

> I am writing a programto read information from scales (as in weighing)

I suppose it does sound better if not as correct as massing ;-)
Debatable :)

> into a database. My brother is selling these scales and the company he
> works for will pay royalties for every scale the program is
> distributed with. I need to have the program easy to set up becaus
> their average customer barely knows where to switch on the pc let
> alone set up ODBC.
>=20

But you are locking yourself fairly tightly into a Windows / Access
world. There are zillions of database toolkits, classes, libraries etc.
If you need something simple, do you need Access? Can't you build a
simple database into your own program? Access doesn't come cheap. Why
not have that part of the profit for yourself where possible :-) Lets
face it, how many line items are you likely to need to store? A few
hundred?

This might be a sollution for version 2 of the program...When I am more =
familliar with FLTK (or whatever makes gui easier) and gui development. =
This is not something I can become good at overnight! I am very busy =
working during the day and most of my free time is swallowed by my =
family. I have at most 2 hours a day to do my studies (I am starting my =
degree this year- part time), homework and programming. So when I say 2 =
weeks, I mean 4-8 hours if I am lucky. Far too little time for a =
hobbyist programmer like myself to do a full project!


> I was thinking of doing the entire thing in access and I have the
> database already set up - I just need a small program to handle the
> task of getting information from the serial port (no problem) and
> writing it directly into the appropriate table of the access database.
> Importing and exporting is very messy and I'd rather not do it if I
> can work around it.
>=20
> Thanks again for all your help guys!

NP :-)