domingo, 12 de septiembre de 2010

Agregar el driver JDBC de postgresql a Crystal Reports XI

PostgreSQL
Clase Driver: org.postgresql.Driver
URL de Conexión: jdbc:postgresql://:/
Fichero .jar/.zip: postgresql.jar


Para agregar el soporte del driver JDBC de postgresql a Crystal Reports XI lo que debemos hacer es:

1. copiar el archivo JAR del controlador (postgresql-8.4-701.jdbc4.jar) almacenado por lo regular en: C:\Program Files\PostgreSQL\pgJDBC aunque puede variar la ubicación, en la ruta "C:\Program Files\Common Files\Business Objects\3.0\java\lib\external" del Crystal Reports XI.

Una vez copiado el archivo jar, necesitamos editar el archivo: CRConfig.xml almacenado en "C:\Program Files\Common Files\Business Objects\3.0\java". Agradando el path de conexión hacia el nuevo driver dentro de la etiqueda ....

Un ejemplo de mi archivo CRConfig.xml ya modificando la etiqueta y resaltando la linea agregada seria:

C:\Program Files\Common Files\Business Objects\3.0\java/lib/crlovmanifest.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRLOVExternal.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJavaServerCommon.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJavaServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJDBCServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBXMLServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/CRDBJavaBeansServer.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/CRDBXMLExternal.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/log4j.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/cecore.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/celib.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/ebus405.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/corbaidl.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/freessl201.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/asn1.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/certj.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/jsafe.jar;C:\Program Files\Common Files\Business Objects\3.0\java/lib/external/sslj.jar;C:\Program Files\Common Files\Business Objects\3.0\java\lib\external\postgresql-8.4-701.jdbc4.jar;${CLASSPATH}

Listo...

8 comentarios:

Anónimo dijo...

fiction new releases ebooks ebook recipes http://audiobookscollection.co.uk/de/On-the-Move-to-Meaningful-Internet-Systems-2005-CoopIS-DOA-and-ODBASE-OTM-Confederated-International-Conferences-CoopIS-DOA-and-ODBASE-2005-Applications-incl-Internet-Web-and-HCI/p209555/ ebook reader with backlight [url=http://audiobookscollection.co.uk/Georgina-Walker/m43056/]database ebook free[/url] xray x-ray ebook clothes holy land

Anónimo dijo...

gps satellite tracking software http://buyoem.co.uk/product-14624/HiFi-Soft-HiFi-WAV-OGG-Converter-3-0 parentral control software [url=http://buyoem.co.uk/product-36146/Masters-ITC-Scanitto-Pro-2-8]german software[/url] xp indego download software free
[url=http://buyoem.co.uk/product-17502/iBank-Mac]iBank [Mac] - Download OEM, Software Sale, OEM Software[/url] gamma software solutions
[url=http://buyoem.co.uk/product-10109/Native-Instruments-Traktor-DJ-Studio-3-2][img]http://buyoem.co.uk/image/2.gif[/img][/url]

Anónimo dijo...

palm pilot graffiti software http://buyoemsoftware.co.uk/product-37100/Alabe-Reports-2-8 geocap software [url=http://buyoemsoftware.co.uk/de/product-35544/Fetch-5-6-MacOSX]surplus software[/url] partners map software
[url=http://buyoemsoftware.co.uk/de/category-100-103/Grafiken-and-Publishing]Grafiken & Publishing - Software Store[/url] genealogy software family tree
[url=http://buyoemsoftware.co.uk/product-36904/Thunderhead-Engineering-Pathfinder-2011-1][img]http://buyoem.co.uk/image/1.gif[/img][/url]

Anónimo dijo...

nbaeeqnjm http://www.cheapdrdrebeats.net quogmjnjc [url=http://www.cheapdrdrebeats.net]beats by dr dre solo[/url] lgqmvnvro
tlecgmnzp http://www.polosralphlaurenuksale.net kmzalqxow [url=http://www.polosralphlaurenuksale.net]ralph lauren clothes[/url] vlyrkqrna
joyfydhzr http://www.gafassol-rayban.com hitiumznn [url=http://www.gafassol-rayban.com]gafas sol ray ban[/url] sgymvvhlz
cttbsmiis http://www.christianlouboutinfemmes.com izxsagpvm [url=http://www.christianlouboutinfemmes.com]prix chaussures louboutin[/url] ypfaicidl
glpoglhml http://www.gafasraybans.net ijdttzkng [url=http://www.gafasraybans.net]gafas de sol baratas[/url] rtessgmem

Anónimo dijo...

Wonderful goods from you, man. I have be mindful your stuff
prior to and you are simply too fantastic.
I actually like what you've acquired here, really like what you are stating and the best way wherein you are saying it. You are making it enjoyable and you continue to care for to stay it sensible. I cant wait to read far more from you. That is really a tremendous site.

Here is my webpage; vigorelle cream

Anónimo dijo...

peed dating chicago http://loveepicentre.com/contact/ il miglior software dating
dating in pa [url=http://loveepicentre.com/map/]best american online free dating site[/url] australian adult sex dating sites
real dating boise [url=http://loveepicentre.com/contact/]romance mature dating[/url] dating in my 40s [url=http://loveepicentre.com/user/sandyubaby/]sandyubaby[/url] free senir dating

Anónimo dijo...

Howdy! Do you know if they make any plugins
to protect against hackers? I'm kinda paranoid about losing everything I've worked hard on.
Any recommendations?

My homepage :: kyle leon somanabolic muscle maximizer free download

Anónimo dijo...

It's going to be ending of mine day, however before end I am reading this fantastic piece of writing to increase my experience.

my blog post: skinception

Bahia desde el balcon...

Bahia desde el balcon...
Ixtapa Zihuatanejo