CR4E - JDBC Connection Properties - How do I set GenericJDBCDriver to Yes

[Former Member]

Hi,

I need to setup my JDBC connection in CR4E like I would in my CRConfig.xml

For example, I need to add this to my connection properties:

<GenericJDBCDriver>

<Option>Yes</Option>

<DatabaseStructure>catalogs,schemas,tables</DatabaseStructure>

<StoredProcType>Standard</StoredProcType>

<LogonStyle>SQLServer</LogonStyle>

</GenericJDBCDriver>

Without setting these properties for my JDBC connection things do not work. I guess I need to use the Optional properites, but I do not know what the syntax would be for what I want.

Please help.

Thanks,

Nick

[Former Member]

Hi Nick,

I know it's been a while, but did you have any luck solving this one?

I'm trying to do a similar thing to solve problems I have connecting to an Ingres DB.

Cheers,

Darran

[Former Member]

Please find below an example of setting the JDBC tags for Ms Sql 2000 (sp4)

<JDBC>
	<CacheRowSetSize>100</CacheRowSetSize>
	<JDBCURL>jdbc:microsoft:sqlserver://vm-5akouassiwk2:1433</JDBCURL>
	<JDBCClassName>com.microsoft.jdbc.sqlserver.SQLServerDriver</JDBCClassName>
	<JDBCUserName>sa</JDBCUserName>
	<JNDIURL></JNDIURL>
	<JNDIConnectionFactory></JNDIConnectionFactory>
	<JNDIInitContext>/</JNDIInitContext>
	<JNDIUserName>weblogic</JNDIUserName>
	<GenericJDBCDriver>
		<Option>No</Option>
		<DatabaseStructure>catalogs,tables</DatabaseStructure>
		<StoredProcType>Standard</StoredProcType>
		<LogonStyle>SQLServer</LogonStyle>
	</GenericJDBCDriver>
</JDBC>

[Former Member]

Hi,

Thanks for the reply, but that is not what I am after. That is how I have my CRConfig.xml setup as well for my webapp, but I'm trying to design reports in the pluggin for Eclipse. I have to setup a data source connection and it does not seem to have a CRConfig.xml, but a GUI that you use to setup your database connection.

ANy help on this?

THanks

Nick

[Former Member]

Just to give more information in what I am trying to do.

I am trying to create new reports with the CR4E using a generic JDBC driver. Now Crystal Reports Designer XI uses the CRConfig.xml file to initialize the JDBC connection properties. For my JDBC driver I NEED to be able to set the Gereric tags. Can some one please tell me how I do this in CR4E because it appears there is no CRConfig.xml and just this connection profile thing.

At the moment I am creating my reports in CR XI designer and my webapp has the CRConfig.xml has the generic tags set. I would like to use Eclipse though to design my reports.