There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataS
<p>[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]Good day everyone. I would like to ask for some help since im having this issue for the past 3 days now.[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]When i try to run a report on birt, this error is showing:[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());[/color]<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]maximoDataSet.open();[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]Im using sql 2008 R2 with a 64 bit Windows 7 OS. Im using Eclipse Platform 3.7.1 which is the version compatible on our Maximo(the one we are using at the office)[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]Now they gave me a laptop for personal use. so i installed sql, birt jdk on it. But when i try to run the report its showing me the error.[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]Things i have done so far are:[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]1.Check the mxreportdatasources.properties. Here is what i have:[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]maximoDataSource.url=jdbc:inetdae7a:192.168.15.10:1433?database=Maximo[/color]<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]maximoDataSource.driver=com.inet.tds.TdsDriver[/color]<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]maximoDataSource.username=maximo1[/color]<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]maximoDataSource.password=maximo123[/color]<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]maximoDataSource.schemaowner=Maximo[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]* On the hostname, i did try putting my computer name, but still the same error. Also for maximo1 as username and also the pw, i did try them and was able to log on to sql. The ip add that i have used is IPv4 for wifi since im cobbecting it thru wifi. I did also try to use the IP for LAN but still the same error.[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]2.I copied sqljdbc.jar and sqljdbc4.jar to D:MAXIMOBIRTBirt371eclipsepluginsorg.eclipse.birt.report.viewer_3.7.1.v20110905birtWEB-INFlib[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]* I did make sure that the java i installed is for 64 bit os[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]3. I open and allowed the port no 1433 on my windows firewall[/color]<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]4. i Extracted OPTA.jar on [/color]<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]D:MAXIMOBIRTBirt371eclipsepluginsorg.eclipse.birt.report.viewer_3.7.1.v20110905birtWEB-INFclasses[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]Im actually loosing hope on this one. So i would like to ask for some help.[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]Question:[/color]<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]1. Can birt connect to SQL eventhough im using a stand alone laptop as my local host server? One of my friends told me that i MIGHT need a virtual IP add for birt to connect to sql. so that means i need to install a VM software and there will i install also sql for birt to connect.[/color]<br />
<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]Thanks in advance[/color]<br />
[color=rgb(0,0,0);font-family:Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif;font-size:13px;background-color:rgb(244,244,244);]Allan[/color]</p>