Accessing Biotics 5 via Third-Party Applications and using them

Accessing Biotics via third-party applications, such as: Tora, Toad, SQLDeveloper, Crystal Reports, ArcGIS.

Installing Oracle (client & server)
 See the attached documents containing instructions for installing the Oracle client and server Oracle 12c: 32- & 64-bit Oracle 11g: 32- & 6...
Tue, 25 Jul, 2017 at 8:17 AM
Connection within Crystal Reports not displaying Tables but something unrecognizable! Help!
Q: In Crystal Reports, I've connected to the Biotics 5 database successfully, but no Tables are being displayed. Instead, I'm getting some other g...
Mon, 5 Feb, 2018 at 11:09 AM
Automate printing of Crystal Reports
This solution utilizes third-party freeware solutions which can be used to call existing Crystal Reports via DOS Command Line. This can then be automated by...
Thu, 23 Feb, 2017 at 9:25 AM
How to automate data export of Biotics 5 shapefiles/data
The following information was provided by Greg Krakow, at Georgia Nongame Conservation Section. The attached document provides instructions regardin...
Wed, 8 Jun, 2016 at 2:32 PM
Crystal Reports: Error connecting to Crystal Reports via Oracle 10g on Windows 7 machine
The following error is received when trying to connect to the Biotics 5 database via Crystal Reports using Oracle 10g on a Windows 7 machine: SP2-1503: U...
Wed, 5 Nov, 2014 at 8:55 AM
Can't access Biotics 5 via Crystal Reports or MS Access on 64-bit machine
Both Crystal Reports and Microsoft Access utilize the 32-bit ODBC connections, regardless of whether it's installed on a 64-bit machine.  Ins...
Tue, 9 Jun, 2015 at 9:13 AM
Crystal Reports:   appears in long text fields in Crystal Reports
Problem: Copying/pasting from another system into Biotics 5 results in the data appearing normal in Biotics, however in Crystal Reports, a weird f...
Wed, 5 Nov, 2014 at 8:56 AM
SQL Developer: Can't access mapped network drives on 64-bit machine
Oracle SQL Developer is installed with the Oracle 11g client and is a very handy tool, similar in functionality to Tora and TOAD.  Unfortunately, the vers...
Mon, 11 Jul, 2016 at 9:31 AM
ArcGIS: OID field renumbered when exporting
Problem: Follow the instructions to Connect to Biotics 5 Database within ArcGIS.  When exporting the query layer to a feature class or geodatabase tabl...
Wed, 22 Jan, 2014 at 1:25 PM
ArcGIS requires 32-bit Oracle installation
ArcGIS requires the 32-bit Oracle installation even on a 64-bit machine.  Failing to install the 32-bit version of Oracle will result in the following error...
Thu, 26 Feb, 2015 at 1:01 PM