Once some of the gotcha’s were taken care of in setting up a data source, getting BI Publisher to connect to SQL Server was fairly straightforward, in fact, it was no more difficult than creating a new data source within Oracle. NOTE: The link to get the JDBC files in the walkthrough document at OTN is broken or outdated, so use one shown earlier, or do a search at MSDN.įrom this point forward, you should be able to create folders and reports in a normal fashion. The edited file also has each tag on one line the line returns above are for formatting in this article. You can go this route if you want (it works just as well, and if you test this, be sure to move or rename the files in the applib folder so you know the jar files are only being referenced via the application.xml file). To be a bit more precise, the example shown at OTN (shown below) has had the closing tags corrected to use “/>” instead of just “>” (just like strict HTML with self-closing tags). You simply add in three library path tags with the path and file name of each jar file. This section discusses editing the application.xml file in the /j2ee/home/config directory. Within this walkthrough, there are instructions on how to configure OC4J to work with foreign datasources. A note on My Oracle Support (Doc ID: 445157.1, How to Install JDBC Connection for MS SQL Server in BI Publisher Enterprise) makes reference to a how-to note at OTN (SQL Server Walkthrough). Copy them to the applib folder as mentioned earlier. Within this folder, you will find the three jar files. Using Windows, run the setup and the JDBC installation for 2000 will be located at:Ĭ:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib …and download the tar or exe file as appropriate for your platform. The SQL Server 2000 JDBC files work you don’t need the single 2005 version named sqljdbc.jar (at least as far as BIP is concerned, and even though we did the setup using a 2005 database).
A quick and easy way to get the requisite files is to download them from MSDN.
0 kommentar(er)
