Interfacing with a database using an API (i think...)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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.

.



Relevant Pages

  • Re: ACT! 2005 Complaints with MS .Net
    ... > utilize that had not been carried forward to the new version, ... > Supposedly the previous versions of ACT! ... > complete code rewrite, and there have been many references to .Net being some ... The old database was pretty ghastly. ...
    (microsoft.public.dotnet.general)
  • Interfacing with a database using an API
    ... I'm using Act 6. ... I need to interface with the act database and add ... on a .tlb file and referenceing the .dll this created - all of this has ... and do please take a look / offer any advice you ...
    (microsoft.public.dotnet.languages.csharp)
  • Act database access using API (I think)
    ... I'm using Act 6. ... I need to interface with the act database and add ... on a .tlb file and referenceing the .dll this created - all of this has ... and do please take a look / offer any advice you ...
    (microsoft.public.dotnet.framework.interop)
  • Interfacing with act database using API (i think)
    ... I'm using Act 6. ... I need to interface with the act database and add ... on a .tlb file and referenceing the .dll this created - all of this has ... and do please take a look / offer any advice you ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Writing a script to stop and start a service
    ... Yes it does use a SQL service but it is ... not actually a SQL database file. ... > Also, you're not completely ruined without a SQL native backup, SBS backup ... Here at my company we use Act! ...
    (microsoft.public.windows.server.sbs)