publisher with Oracle

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bell2 - 08 Nov 2006 21:39 GMT

Hello, Does publisher work with Oracle 9i? Can we create mailing labels in
publisher
by connecting to oracle and retrieving the data in its tables? Thanks.

Reply to this Message

Ed Bennett - 09 Nov 2006 00:08 GMT

> Hello, Does publisher work with Oracle 9i? Can we create mailing labels in
> publisher
> by connecting to oracle and retrieving the data in its tables? Thanks.

The wizard lists Oracle as a supported option. For semi-obvious reasons,
I don't have an Oracle server to test against here. If you want to
donate one to me, I'll happily receive it. Note that the same
limitations will apply as with any other data source (256-character
maximum field length).

Signature

Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org

Reply to this Message

bell2 - 09 Nov 2006 16:26 GMT

Mr Bennett: I do not have the publisher software on my workstation so I have
no idea how the wizard looks like. Could you point me to some documentation
that mentions oracle connectivity? I'm sure by saying oracle server you mean
oracle database server and not web server because I am looking for
connectivity to database. Sure, I'd have donated the oracle server right
away if I had it? Again, I'm not clear ... By the way, Mr Bennett, just want
to make sure you know this, Oracle 10g express edition is available for
download. You might want to give it a try even if you are a SQLServer
advocate and don't like oracle. Thanks.. Please let me know if there's a
article discussing oracle connectivity .. Thanks

> Hello, Does publisher work with Oracle 9i? Can we create mailing labels in
> publisher
> by connecting to oracle and retrieving the data in its tables? Thanks.

Reply to this Message

Ed Bennett - 09 Nov 2006 23:06 GMT

> Mr Bennett: I do not have the publisher software on my workstation so I have
> no idea how the wizard looks like. Could you point me to some documentation
> that mentions oracle connectivity?

Not really, as the only way I checked was to look in the program. If you
like, I can email you a screenshot.

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm claims that as
of Word 2002, Word can connect to an Oracle server. As Publisher 2003's
merge interface is linked with that of Word 2003, I would guess that
that implies that Publisher supports connection to an Oracle server.

> I'm sure by saying oracle server you mean
> oracle database server and not web server because I am looking for
> connectivity to database.

Yes, an Oracle Web Server would be rather useless for serving up data,
which is what is generally necessary to perform a mail merge.

> Sure, I'd have donated the oracle server right
> away if I had it? Again, I'm not clear ... By the way, Mr Bennett, just want
> to make sure you know this, Oracle 10g express edition is available for
> download. You might want to give it a try even if you are a SQLServer
> advocate and don't like oracle.

I have zero need for any database server software, so don't have any
version of either currently installed.

Signature

Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org

Reply to this Message

Susanne Wenzel - 10 Nov 2006 19:19 GMT

Am Wed, 8 Nov 2006 13:39:01 -0800 schrieb bell2:

> Hello, Does publisher work with Oracle 9i? Can we create mailing labels
> in publisher by connecting to oracle and retrieving the data in its
> tables?

Well, I'm not sure whether this is an option for you (couldn't make out if
you wanted something in vba), but maybe it helps. I'm not familiar with
oracle 9i, but here is an example that retrieves data from an Access-MDB
(note that this is a very simple example and these are testdata of course):

Sub VerbindungMDB()
Dim cnn As ADODB.Connection
Dim rec As ADODB.Recordset

Set cnn = New ADODB.Connection
With cnn
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FullPathToMDB;User Id=admin;Password=;"
.Open
End With

Set rec = New ADODB.Recordset
rec.Open "SELECT * FROM Tabelle1 WHERE Testname = ""Hansen""", cnn, adOpenKeyset, adLockOptimistic

ThisDocument.Pages(1).Shapes(1).TextFrame.TextRange.InsertAfter rec.Fields(1).Value
Set rec = Nothing
Set cnn = Nothing

End Sub

What you need for oracle is the correct connectionstring, have a look here:

http://www.connectionstrings.com/

Plus you need to set a reference to the Microsoft ActiveX Data Objects 2.x
Library (at least 2.7 SP1)

I've tested this little code here with Publisher 2002 and it works.

HTH
Greetings
Susanne

Reply to this Message

Ed Bennett - 11 Nov 2006 00:34 GMT

> Well, I'm not sure whether this is an option for you (couldn't make out if
> you wanted something in vba), but maybe it helps. I'm not familiar with
> oracle 9i, but here is an example that retrieves data from an Access-MDB
> (note that this is a very simple example and these are testdata of course):

But why write your own mail merge engine if Publisher's built-in one
works? <:o)

Signature

Ed Bennett - MVP Microsoft Publisher
http://ed.mvps.org

Reply to this Message

Susanne Wenzel - 11 Nov 2006 09:41 GMT

Am Sat, 11 Nov 2006 00:34:45 +0000 schrieb Ed Bennett:
Hi Ed,
nice to hear from you:-),

>> Well, I'm not sure whether this is an option for you (couldn't make out if
>> you wanted something in vba), but maybe it helps. I'm not familiar with
>> oracle 9i, but here is an example that retrieves data from an Access-MDB
>> (note that this is a very simple example and these are testdata of course):
> But why write your own mail merge engine if Publisher's built-in one
> works? <:o)

If it works to your content, you're absolutely right. But I think it can do
no harm to have other options at hand, just in case...

And as this is the Publisher-Programming-NG I thought the poster wanted
something in that area. I use the mailmerge-function in Word now and then
and I sometimes experienced some annoying effects. Probably due to the fact
that word uses DDE (imho up til now) to connect and this is rather an old
technology as far as I know.

Greetings from Germany
Susanne

Signature

Mein System:
Office XP, SP3, aktueller Patchstand
Windows 2000, SP4, aktueller Patchstand

Reply to this Message