Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle Stored Procedures returning records
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00903180
Message ID:
00906102
Views:
17
FWIW, you don't really have to go through the Oracle client install process. You can export the registry key HKLM\SOFTWARE\Oracle then import that reg file into the registry of another machine. Then copy the files from the Oracle home folder and the Oracle folder from Program Files folder to the machine where it is needed. There will also be 1 or 2 program folders in the All Users\Start Menu\Programs folder that need to be copied to the other client machines. You could even create an InstallShield Express project to install all this for you as well as add the registry keys for you.

The only wild card I can think of is the Oracle ODBC driver, but InstallShield Express should be able to handle the installation of this as well.

Oracle does not insert any Uninstall info in the Add/Remove Programs control panel and it keeps all its files in its own folder structure.

Now there is the issue of Copyright and licensing agreements with respect to the client install, but I leave that to you. We have an Agency site license with Oracle, so we can use this type of install without having to physically perform a "formal" install from the Oracle CDs.

>We finally got the Oracle ODBC driver loaded on one of the boxes.
>It works!!! By George it Works!!! :-)
>Now we just have to to load it on everything else :-(
>
>
>***** For anyone else that might need to know how to do this with more variables
>    lcwarehouse = '060R'
>    lcCompany = '61'
>    lcCommodity = 'ROUGHRICE'
>    lnCrop_year = 2003
>    lcClass = 'LONG'
>    lcPool = 'AR'
>
>    lcSQL = "{call get_today_stockrecord_whs.ReturnCursor("
>    lcSQL = lcSQL + ['] + lcwarehouse + [',]
>    lcSQL = lcSQL + ['] + lcCompany + [',]
>    lcSQL = lcSQL + ['] + lcCommodity + [',]
>    lcSQL = lcSQL +  ALLTRIM(STR(lnCrop_year)) + ','
>    lcSQL = lcSQL + ['] + lcClass + [',]
>    lcSQL = lcSQL + ['] + lcPool + [']
>    lcSQL = lcSQL +  ")}"
>    lnRetVal = SQLEXEC(lnHandle, lcSQL, 'todays_view')
>
>Thank you so much.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform