publisher with Oracle

[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? Thanks.

 

[Ed Bennett]

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).

 

[bell2]

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

 

[Ed Bennett]

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.

 

[Susanne Wenzel]

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

 

[Ed Bennett]

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? <)

 

[Susanne Wenzel]

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

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

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