In article <buqqof$m6n$1_at_grillo.cs.interbusiness.it>, nobody_at_nowhere.com
says...
> Hello,
> I don't know where to post my question, so please be patient if this is not
> properly the right place.
>
> Simply, I want to connect to oracle using Microsoft Word VB.
> I have configured an ODBC DSN.
> Reading VB help, I didn't find useful information to successfully connect,
> and use a recordset to navigate through data. It seems everything is tied to
> MailMerge.
>
> I read some examples, but they didn't work. They used ODBC and ADO
> conncetions, both don't work on my Word 2000 (using oracle 9.2).
>
> My VB macro returns "unknown user-defined type" error, on declaration of
> variable (test1, in my case) in the following ways:
> - Dim test1 As ADODB.Connection
> - Dim test1 As Connection
> - Dim test1 As New Connection
> - Dim test1 As Recordset
>
> So, I'm going to thing I'm missing something...
>
> Regards
>
>
>
You may have forgotten to add a reference to "Microsoft ActiveX Data
Objects" in your project (menu Tools/References). Otherwise Word doesn't
know what an "ADODB.Connection" is.
Received on Fri Jan 23 2004 - 04:56:47 CST
