Is it possible to pull from Act (v6) for windows

HCL Domino Domino Forum
1

Is it possible to pull from Act! for Windows to pull (ie…company name) into a notes database? (not exporting here, just a reference entry in the document is needed).

If so what should I use? ODBC?

Thanks!

Brett

2

Subject: Is it possible to pull from Act (v6) for windows

ACT! includes ODBC or OLEDB drivers (depending on ACT! version) with its client install. That allows the use of Notes tools like DECS, LEI, and/or LSXLC for integration. I use LSXLC…here is an example to get you started:

Dim src As New LCConnection (“oledb”)

Dim fldLst As New LCFieldList

Dim tempdoc As NotesDocument

Dim db As NotesDatabase

Dim sess As New NotesSession

Dim LCSess As New LCSession



On Error Goto errorhandler

Set db = sess.CurrentDatabase

lcsess.ConnectionPooling = True



src.Provider="ACTOLEDB"

src.Init_DataSource = "P:\ACT_Database.pad"

src.Userid = "Act Administrator"

src.Password = "password"



'REM try the connect

src.disconnect

src.Connect

If Not src.isconnected Then

	Print "Problem connecting to Act! database (dbname=" & src.Init_DataSource & " Userid=" & src.Userid & ")"

	Exit Sub

End If