Vivek Agarwal’s Portal/Java Blog

An IBM Gold Consultant’s weblog about IBM, Lotus, WebSphere, J2EE, IT Processes, and other IT technologies

Posts Tagged ‘Visio’

Getting past issues with reverse engineering an Oracle schema with Visio on Vista

Posted by Vivek Agarwal on December 14, 2007

Yesterday, I had the need to reverse engineer an Oracle schema in Microsoft Visio on my now not-so-new Vista laptop. While I had the Oracle JDBC drivers copied onto my Vista laptop, I did not have the Oracle client installed. I first tried to install the Oracle 9i client, because the Oracle schema was in a Oracle 9i database instance. The Oracle 9i client installer warns about incompatibility with Vista and it certainly lived up to the billing. I saw several other users with postings about issues. I saw one obvious issue with folder permissions and changed ownership/permissions on the Oracle client install folder, but that did not resolve the issue all the way. While trying to configure an ODBC data source (only for reverse engineering the Oracle schema) , I ran into errors that had again been encountered by many. The first error was “The setup routines for the oracle in orahome92 odbc driver could not be loaded due to system error code 126”. Clicking ok on this error resulted in a secondary error alert – “Could not load the setup or translator library”. At this point, rather than spend more cycles on the issue, I switched to reverse engineering the schema using the eclipse plugin – Clay. Clay worked just fine for reverse engineering the schema (took all of 5 minutes), but the issue with it was that it did not allow me to move the foreign key connectors to make them route better. At this point, I was back looking at the Visio route and the solution was extremely simple! Read the rest of this entry »

Posted in Oracle, Vista, Windows Vista | Tagged: , , , , | 1 Comment »