Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » issues connecting eclipse birt report to sqlserver(trouble connecting eclipse birt report to sqlserver)
issues connecting eclipse birt report to sqlserver [message #1403930] Mon, 28 July 2014 15:36 Go to next message
Francis White is currently offline Francis WhiteFriend
Messages: 1
Registered: July 2014
Junior Member
Hello All,

Please i need assistance with how to connect Eclipse birt report to sql server.
Please i will really appreciate if any body can give a detail step by step approach on how to connect birt report from the report designer to sqlserver 2008r2 with all the necessary jay files. because all the videos i hv seen seem to be very vague and this process is-meant to be smooth.and after downloading the sqljdbc drivers am still getting this error

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, Cannot open database "AdventureWorks2014" requested by the login. The login failed. ClientConnectionId:440a81e4-4c36-4edb-a5d8-dfce720075d4.

when i try to connect using this parameter:

jdbc:sqlserver://localhost\NEWSQLEXPRESS:1433;databaseName=AdventureWorks2014;



but when i try to connect using this one:

jdbc:jtds:sqlserver://BBT-SAS-PC:1433;databaseName=AdventureWorks2014;

I get the following error :

There is an error in get connection, I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property..

Please I will appreciate a very clear cut and understanding response as this is very urgent.

Thank you


Re: issues connecting eclipse birt report to sqlserver [message #1403987 is a reply to message #1403930] Mon, 28 July 2014 23:50 Go to previous message
Russell Bateman is currently offline Russell BatemanFriend
Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

On 07/28/2014 11:01 AM, Francis White wrote:
> Hello All,
>
> Please i need assistance with how to connect Eclipse birt report to sql
> server.
> Please i will really appreciate if any body can give a detail step by
> step approach on how to connect birt report from the report designer to
> sqlserver 2008r2 with all the necessary jay files. because all the
> videos i hv seen seem to be very vague and this process is-meant to be
> smooth.and after downloading the sqljdbc drivers am still getting this
> error
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error
> in get connection, Cannot open database "AdventureWorks2014" requested
> by the login. The login failed.
> ClientConnectionId:440a81e4-4c36-4edb-a5d8-dfce720075d4.
>
> when i try to connect using this parameter:
>
> jdbc:sqlserver://localhost\NEWSQLEXPRESS:1433;databaseName=AdventureWorks2014;
>
>
>
>
> but when i try to connect using this one:
>
> jdbc:jtds:sqlserver://BBT-SAS-PC:1433;databaseName=AdventureWorks2014;
>
> I get the following error :
>
> There is an error in get connection, I/O Error: SSO Failed: Native SSPI
> library not loaded. Check the java.library.path system property..
>
> Please I will appreciate a very clear cut and understanding response as
> this is very urgent.
>
> Thank you

There's a separate BIRT forum for this.
Previous Topic:Kepler Service Release 2 and Java 8 support
Next Topic:error getting Eclipse running on Windows Server 2008R2?
Goto Forum:
  


Current Time: Fri Apr 26 13:36:44 GMT 2024

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

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

Back to the top