Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » jdbc:sqlserver
jdbc:sqlserver [message #368150] Wed, 06 May 2009 19:58 Go to next message
Leo Mising name is currently offline Leo Mising nameFriend
Messages: 10
Registered: July 2009
Junior Member
Hi,

I’m trying to use a report that connects to an MS SQL Server database but
without success.

I have Java action that I use to connect that works just find. In my Java
action I’m doing the following:

I use the driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

I use the URL:
jdbc:sqlserver://<SERVERNAME>:1433;databaseName=<DBNAME>;user=sa;password=;

In my BIRT report I have try this same URL and I have also played around
with it, making changes, but can never connect to the database. There is
no error when I run the report but always get an empty report.

I using BIRT 2.1.3 and I have also placed the Microsoft JDBC driver in the
appropriate place.

Any help would be greatly appreciated, Leo
Re: jdbc:sqlserver [message #368152 is a reply to message #368150] Thu, 07 May 2009 10:39 Go to previous message
Nicola is currently offline NicolaFriend
Messages: 184
Registered: July 2009
Senior Member
Leo ha scritto:
> Hi,
> I�m trying to use a report that connects to an MS SQL Server database
> but without success.
> I have Java action that I use to connect that works just find. In my
> Java action I�m doing the following:
>
> I use the driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
>
> I use the URL:
> jdbc:sqlserver://<SERVERNAME>:1433;databaseName=<DBNAME>;user=sa;password=;
>
> In my BIRT report I have try this same URL and I have also played around
> with it, making changes, but can never connect to the database. There is
> no error when I run the report but always get an empty report.
> I using BIRT 2.1.3 and I have also placed the Microsoft JDBC driver in
> the appropriate place.
> Any help would be greatly appreciated, Leo
>

What if you test your connection in the designer?
Can you preview data of your query?

Bye
Nic
Previous Topic:BIRT - RCP and memory allocation
Next Topic:page order on pdf got messed up
Goto Forum:
  


Current Time: Fri Mar 29 09:07:14 GMT 2024

Powered by FUDForum. Page generated in 0.02741 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top