Final Test

dfilteau · Post by **dfilteau** » Fri 18 Jul 2008 14:07

I have a request due to a problem at the client site.

Some background:
Contractors (like myself) are not permitted to use the wireline Ethernet LAN at the site and can only connect via the wireless G network. As of yesterday afternoon, the wireless network went down just prior to testing my Delphi 2007 console application that was converted from ADO to ODAC access (the app transmits and translates data from SQL Server to Oracle databases). We're hoping to prove that ODAC will improve the time required to insert the rows into the Oracle database. If so, I'll buy ODAC and deploy the application onto the production server.

When I try to execute the console application on the test server (Ethernet connection), it won't run due to the limitations of the trial version (missing DAC105.bpl and ODAC105.bpl libraries). Is there a way to find and include these libraries so we can test the application prior to purchasing the software? I can't test it on my laptop and avoid this issue because as I stated before, the wireless network's down and the MAC restrictions on the Ethernet network prevent me from connecting to the wireline network.

Any help you could provide would be greatly appreciated. Of course, the deadline for a decision on the purchase of the product is today (amazing how technical issues raise their ugly heads at the worst possible moment).

Thanks in advance!

Plash · Post by **Plash** » Fri 18 Jul 2008 15:10

You can resolve the problem in two ways:

1. Install ODAC on the test server.

2. Copy dac105.bpl and odac105.bpl from Windows\System32 folder on your computer to the same folder on the test server.

dfilteau · Post by **dfilteau** » Sun 20 Jul 2008 05:18

Well as luck would have it, neither of these solutions were available to us. I'm confident that your product will meet my client's needs so I decided to buy ODAC. Just waiting for a product registration code now.

Thanks for the suggestion. I'm sure it would have assisted in the testing had we been able to implement it.

dfilteau · Post by **dfilteau** » Mon 21 Jul 2008 17:08

Using the ODAC Professional components and trying to connect to Oracle directly, I still can't connect to the database.

I can't locate information about deploying an ODAC-enabled Delphi console application using direct Oracle access to a Windows server. I've tried your suggestion of copying DAC105.bpl and odac105.bpl to the windows/system32 fodler on the server but still get nothing.

How do I deploy this app? Help!

Thanks.

Plash · Post by **Plash** » Tue 22 Jul 2008 07:18

The dac105.bpl and odac105.bpl files are required only for Trial ODAC edition (or when you build your application with runtime packages).

Please specify whether you receive some error message when trying to connect to the database. Can you connect using Oracle client ?

dfilteau · Post by **dfilteau** » Tue 22 Jul 2008 14:47

Unfortunately there are on diagnostics available in console mode. The process never seems to connect to Oracle so I'm following that lead.

I'll keep you informed.