Hi Gary,
The first question I would ask is, is there any overpowering reason you must
use this database product?
After reviewing the PDF in the SDK, and visiting their web site, I am
strongly impressed that this is a poor database solution for any company
that is looking at an extensible or scalable framework for their future.
This product does not have any OLE DB or ODBC drivers, and in fact, the
documentation discourages anyone from trying to obtain or use any such
products with it. You can't even read the Help documentation online without
an account. They make only ONE product for allowing their database product
to interact with any other type of database product, and it only interacts
with Microsoft Access, and only in one direction. That product costs more
than twice as much as the database product.
It is the sort of product which may seem to be "cheap" (inexpensive) in the
short run, but the hidden costs associated with upgrading, in terms of
extensibility and scalability, which involve buying more and more
proprietary software from the company, or buying support from the company,
and/or the cost of paying a programmer for the incredible number of hours
needed to write a custom proprietary application to interact with the
database, make it a cost nightmare in the long run.
In other words, this is the sort of tar baby that very small companies,
headed by technologically ignorant people, innocently buy, thinking that
they are saving money. Eventually, assuming that the company which is using
this software prospers, it *will* have to be abandoned in favor of some real
professional, scalable, extensible product, and the longer they put it off,
the more it will cost.
If you work for this company, you have my sympathies. If you do not work for
this company, but are an independent contractor, my advice would be to
recommend a change in products, and if that recommendation is not heeded,
run, do not walk, to the nearest exit.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Presuming that God is "only an idea" -
Ideas exist.
Therefore, God exists.
<ga********@myway.com> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...
At least I think it's using an API (i don't totally understand the
concept.)
I'm using Act 6. I need to interface with the act database and add
'contacts' to the database. The reason I need to do this is because i'm
writing a little program to add a new prospect to the database when a
telephone lead rings through, the receptionist will use this program,
enter a few pieces of information and then transfer the call to the
salesman - at which point the salesman can pick up the new contact in
the Act program. This should be fairly straightforward.
I'm stuck. I cant figure out how to connect to the database. Or how to
add contacts to it. There is an extensive SDK pack which shows you how
to do this but i've had no joy (partly because the examples are in c++
and i use c# (i've only been learning it over the past couple of
months.)
PLEASE can you take a look www.strident.net/act i've included all the
files and the SDK. And can you then please offer any advice you can on
how I can do this.
So far i've managed to get access to the act namespace, but thats about
it - i can't figure out how to use it. (I got access by running tlbimp
on a .tlb file and referenceing the .dll this created - all of this has
been a very steep learning curve for me!)
I'd really appreciate your effort, i'm totally stumped at the moment.
I just need to
(a) connect to a database.
(b) write / edit it.
Thanks for your time, and do please take a look / offer any advice you
can.
Gary.