JDBC connectivity

[Former Member]

Hi

can you please tell how we setup JDBC connection in crystal report. Do we need to setup any while installation?

can you explain in brief

Regards

[Former Member]

Hi,

Here are Steps for JDBC connectivity:

> Install any database (SQL Server 2005) on System.

> Now Open Crystal Report > Select Database Expert > New Connection > JDBC Connectivity.

> Now Enter the respective Details in the window:

Connection Url - jdbc:sqlserver // databases :1433

Database ClassName: com.microsoft.sqlserver.jdbc.sqlServerDriver

Connection Name: (Optional)

Database Name: (Enter database name here)

UserId : Enter user id of database.

Password : Password of database

Click on Finish and database is connected through JDBC.

Regards,

Rameez

[Former Member]

Thanks. got it

[former_member11696]

Hello,

Open CR Designer and hit the F1 key, select Search and type in JDBC. You'll find info on how to configure the driver in the CR help menu.

Don