need some advice and direction, please
Jill S
My mission is to use an outlook custom form to call the exchange
server, which in turn uses an odbc connection to query Oracle and
return those values back to the Outlook form. I'm currently stuck on
the VB part. I found an article on Integrating Enterprise Data with MS
Outlook at:
http://technet.microsoft.com/cdonline/content/complete/Desk/Outlook/Tech
Note/off408ef.htm
the exchange server comes in because they want to automate the form to
be ran every so often. I understand I will need event scripting for
that part, but right now I can't figure out how to connect to the
database and what I need to do with the ActiveX DLL or EXE (not sure
which to use) after it's created.
I'm new at all this and would really appreciate any help you can give
me. Thanks!
Jill
Sent via Deja.com http://www.deja.com/
Before you buy.
Simon Jones (MSD)
Regards,
Simon Jones
MillStream Designs Ltd
Independent IT Consultants
Jill S <js...@my-deja.com> wrote in message news:7ttqhj$kn4$1...@nnrp1.deja.com...
Jill S
run it, nothing happens. I figure this is a good thing since there
isn't any apparent errors, but I'm not sure if I need to create a form
that is associated with the DLL.
In Outlook98, I have a post and the following code in VBScript:
Dim txtOracleList
Dim objListRDO
Const rdDriveNoPrompt = 1
Const rdOpenStatic = 3
Sub Item_Open()
Set txtOracleList = Item.GetInspector.ModifiedFormPages("Oracle
List").Controls("txtOracleList")
Set objListRDO = CreateObject("ListServerRDO.CListServer")
End Sub
'where ListServerRDO is the Project and CListServer is the class
Sub cmdGetUpdate_Click()
Dim strSQL
txtOracleList.Value = ""
strSQL = "Select responsibility_name from
apps.fnd_responsibility_tl;"
objListRDO.ConnectString = "DSN=Dev;UID=apps;PWD=apps"
txtOracleList.Value = objListRDO.GetList(strSQL)
End Sub
I'm getting an error on the last line txtOracleList.Value = ...,
saying "Application defined or object defined error".
Since it's getting past the objListRDO.ConnectString line, does this
mean that it's connecting to the database? I can't tell at all what is
going on.
I put a stop statement in the code to try to bring up the
debugger to step through the code, but that doesn't do anything but
show a message box saying a stop statement as been encountered. Then I
get the other error and a message box that says, operation failed. Does
my code look right? I'll be more than happy to post the DLL code if
anyone wants to take a peek at that.
Thanks for all your help!
Jill
In article <7tv6nt$g7v$1...@uranium.btinternet.com>,
"Simon Jones (MSD)" <sim...@btinternet.com> wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0028_01BF14AF.039DAA80
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> It is perfectly possible to retrieve data from Oracle onto an Outlook
98 =
> form but the programming would have to be in VBScript. Outlook 2000 =
> gives you much better programming capabilities. You may be able to
make =
> a COM component in Visual Basic and then call this from your Outlook =
> form.
>
> I don't think you'll be able to automate Exchange to "run a form
every =
> so often". You may be able to make Exchange call a COM component =
> whenever an item is added or modified in a folder.=20
>
> ActiveX DLLs are "in-process" components. They are faster to call. =
> ActiveX EXEs are "out-of-process" components. They are slower to
call. =
> Read more in the MSDN library about the other differences.
>
> Does this help?
>
> Regards,
> Simon Jones=20
> MillStream Designs Ltd=20
> Independent IT Consultants=20
>
> Jill S <js...@my-deja.com> wrote in message =
> news:7ttqhj$kn4$1...@nnrp1.deja.com...
> I'm using Outlook98, Exchange 5.5, VB 6.0 (enterprise), and Oracle =
> 8.0.
> My mission is to use an outlook custom form to call the exchange
> server, which in turn uses an odbc connection to query Oracle and
> return those values back to the Outlook form. I'm currently stuck on
> the VB part. I found an article on Integrating Enterprise Data with
MS
> Outlook at:
>
> =
>
http://technet.microsoft.com/cdonline/content/complete/Desk/Outlook/Tech
> Note/off408ef.htm
>
> the exchange server comes in because they want to automate the form
to
> be ran every so often. I understand I will need event scripting for
> that part, but right now I can't figure out how to connect to the
> database and what I need to do with the ActiveX DLL or EXE (not sure
> which to use) after it's created.
>
> ------=_NextPart_000_0028_01BF14AF.039DAA80
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2614.3401" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT color=3D#000080>It is perfectly possible to retrieve data =
> from Oracle=20
> onto an Outlook 98 form but the programming would have to be in =
> VBScript.=20
> Outlook 2000 gives you much better programming capabilities. You may
be =
> able to=20
> make a COM component in Visual Basic and then call this from your =
> Outlook=20
> form.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT color=3D#000080>I don't think you'll be able to automate =
> Exchange to=20
> "run a <STRONG>form</STRONG> every so often". You may be able
to=20
> make Exchange call a COM component whenever an item is added or =
> modified in=20
> a folder. </FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT color=3D#000080>ActiveX DLLs are "in-process" components. =
> They are=20
> faster to call. ActiveX EXEs are "out-of-process" components. They
are =
> slower to=20
> call. Read more in the MSDN library about the other =
> differences.</FONT></DIV>
> <DIV><FONT color=3D#000080></FONT> </DIV>
> <DIV><FONT color=3D#000080>Does this help?</DIV><BR>
> <P><FONT color=3D#000080 face=3DVerdana size=3D2>Regards,<BR>Simon =
> Jones</FONT>=20
> <BR><FONT color=3D#000080 face=3DVerdana size=3D2>MillStream Designs =
> Ltd</FONT>=20
> <BR><FONT color=3D#000080 face=3DVerdana size=3D2>Independent IT =
> Consultants</FONT>=20
> </P></FONT>
> <BLOCKQUOTE=20
> style=3D"BORDER-LEFT: #000080 2px solid; MARGIN-LEFT: 5px; MARGIN-
RIGHT: =
> 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
> <DIV>Jill S <<A =
> href=3D"mailto:js...@my-deja.com">js...@my-deja.com</A>>=20
> wrote in message <A=20
> =
> href=3D"news:7ttqhj$kn4$1...@nnrp1.deja.com">news:7ttqhj$kn4
$1...@nnrp1.deja.co=
> m</A>...</DIV>I'm=20
> using Outlook98, Exchange 5.5, VB 6.0 (enterprise), and Oracle =
> 8.0.<BR>My=20
> mission is to use an outlook custom form to call the =
> exchange<BR>server, which=20
> in turn uses an odbc connection to query Oracle and<BR>return those
=
> values=20
> back to the Outlook form. I'm currently stuck on<BR>the VB part. I =
> found an=20
> article on Integrating Enterprise Data with MS<BR>Outlook =
> at:<BR><BR><A=20
> =
>
href=3D"http://technet.microsoft.com/cdonline/content/complete/Desk/Outl
o=
>
ok/Tech">http://technet.microsoft.com/cdonline/content/complete/Desk/Out
l=
> ook/Tech</A><BR>Note/off408ef.htm<BR><BR>the=20
> exchange server comes in because they want to automate the form =
> to<BR>be ran=20
> every so often. I understand I will need event scripting
for<BR>that =
> part, but=20
> right now I can't figure out how to connect to the<BR>database and =
> what I need=20
> to do with the ActiveX DLL or EXE (not sure<BR>which to use) after =
> it's=20
> created.</BLOCKQUOTE></BODY></HTML>
>
> ------=_NextPart_000_0028_01BF14AF.039DAA80--
Simon Jones (MSD)
Regards,
Simon Jones
MillStream Designs Ltd
Independent IT Consultants
Jill S <js...@my-deja.com> wrote in message news:7u089e$ds1$1...@nnrp1.deja.com...