Using Postgres DB with Crystal Reports for Eclipse

[Former Member]

<p>Hi,<br /><br />is it possible to use the &#39;New Connection&#39; wizard to connect to a postgres DB? How can I do this? Is there a database manager for postgres available?<br /><br />Thanks!<br /></p><p>Regards,</p><p>Ahmed</p>

[former_member11696]

Please re-post if this is still an issue to the Java Development - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly

[Former Member]

<p>Hello,</p><p>I use PostgreSQL 8.1 via the postgresqljdbc driver in crystal/eclipse.</p><p>When accessing views, I have the problem that crystal treats all columns of the views as fields of type BIGINT. </p><p>In fact there are some fields of this type, but many others as well that I would need.</p><p>Can anyone help me on this topic.</p><p> Thanks in advance,</p><p>Hans </p>

[SJohnson]

<p>Hi Ahmed,</p><p> I am not too familiar with the PostgreSQL DB, but I think you should be able to make a connection within the Database Explorer view of Eclipse. I am quite confident that if you can make a connection with this view that Crystal Reports for Eclipse will be able to use the connection. To do this, follow the steps outlined below:</p><ol><li>Create a new connection in the Database Explorer view. Ensure that the JDBC Driver option has a value of &#39;Other&#39; which should be the default</li><li>Enter the Postgres DB name for Database Name</li><li>For JDBC Driver class enter: <strong>org.postgresql.Driver</strong> </li><li>For Class Location browse to your <strong>postgresql.jar</strong> file</li><li>For Connection URLuse the following syntax: <strong>jdbc:postgresql://host:port/database</strong></li></ol><p>Hopefully this will work for you. I found all of this information at the PostgreSQL JDBC Documentation site at <a href="http://jdbc.postgresql.org/doc.html">http://jdbc.postgresql.org/doc.html</a><br /><br />Let me know if this works for you.</p><p>Regards,<br />Sean <br /></p>