Eclipse Community Forums: BIRT » JDBC Driver problem for MSSQL- Schema not showing up in Data Source

Home » Archived » BIRT » JDBC Driver problem for MSSQL- Schema not showing up in Data Source

JDBC Driver problem for MSSQL- Schema not showing up in Data Source [message #871177]

Fri, 11 May 2012 05:51

Eclipse User

Hi

Below is the detail of the environment

1. Windows server 2008 Enterprise
2. MS SQL SERVRE 2008 R2
3. JAVA 1.6 (32 bit)
4. JDBC DRIVER - sqljdbc_4.0.2206.100_enu
5.BIRT Version- 3.7.2

I am able to create the jdbc connection in data source but schema is not loading while creating data set. I am thinking this is a compatability of the driver with the OS. same driver works for window 7 . Please let us know if window 2008 server is supported and what would be the compatible version of driver.

Attachment: birt_error.jpg
(Size: 75.47KB, Downloaded 234 times)

Re: JDBC Driver problem for MSSQL- Schema not showing up in Data Source [message #871262 is a reply to message #871177]

Fri, 11 May 2012 12:44

Eclipse User

Any chance you could try the jtds jdbc driver as a test?

Jason

On 5/11/2012 5:51 AM, Sameer Singh wrote:
> Hi
>
> Below is the detail of the environment
>
> 1. Windows server 2008 Enterprise
> 2. MS SQL SERVRE 2008 R2
> 3. JAVA 1.6 (32 bit)
> 4. JDBC DRIVER - sqljdbc_4.0.2206.100_enu
> 5.BIRT Version- 3.7.2
>
> I am able to create the jdbc connection in data source but schema is not loading while creating data set. I am thinking this is a compatability of the driver with the OS. same driver works for window 7 . Please let us know if window 2008 server is supported and what would be the compatible version of driver.
>

Re: JDBC Driver problem for MSSQL- Schema not showing up in Data Source [message #893269 is a reply to message #871177]

Tue, 03 July 2012 08:32

Eclipse User

Did you had any luck on this problem? I am also facing the same issue.
Let me know if you have any break through.

Previous Topic:	BIRT support for PDF and Excel report Generation
Next Topic:	How to automatically change fonts on all LABELS ,DETAILS ROWS and master page FOOTERS AND HEADERS?

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 19:16:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter