This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Just wondering if anyone has been able to get BIRT running against SQLSERVER 2008 with MAXIMO 7.5. I continually get the following error:
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
or
There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
which I think is related to the above.
Here are the entries from my properties file
maximoDataSource.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
maximoDataSource.url=jdbc:sqlserver://localhost:1433;databaseName=MAXDB75;integratedSecurity=false;
maximoDataSource.username=MAXIMO
maximoDataSource.password=maximo
maximoDataSource.schemaowner=dbo
Regards
Peter
Hi,
I have no problems connecting to my 7.5 server this way. Did you remember to copy the sqljdbc.jar file from the Maximo folder to the Eclipse environment and extract the contents to the \WEB-INF\classes folder?
--- In MAXIMO@yahoogroups.com, "pcamarsh" <peter_camarsh@...> wrote:
>
> Just wondering if anyone has been able to get BIRT running against SQLSERVER 2008 with MAXIMO 7.5. I continually get the following error:
>
> java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
>
> or
>
> There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
>
> which I think is related to the above.
>
> Here are the entries from my properties file
>
> maximoDataSource.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
> maximoDataSource.url=jdbc:sqlserver://localhost:1433;databaseName=MAXDB75;integratedSecurity=false;
> maximoDataSource.username=MAXIMO
> maximoDataSource.password=maximo
> maximoDataSource.schemaowner=dbo
>
> Regards
>
> Peter
>