>Thanks Vladimir
>>Pavel, go to orawin95/sysman/ole2
>I haven't got this directory.
>
>I win yesterday (on win95) with this steps:
>With Oracle installer from Enterprise manager I uninstall all files.
>From CD Oracle Developer 2000 install client software (SQL*Net 2.3.4...).
>Run SQL Net Easy configuration
>Create Datasource with Microsoft driver for Oracle 2.573.4202.
>Sqlconnect from VFP work.
>On this computer Enterprise manager newer works. It allways say 'Java ...'.
>
>On my seconds computer (NT4.0 server) I install client software (Net8 Client 8.0.4..) and Enterprise manager (1.5...).
>Run Oracle Net8 Easy config.
>Make 'Test' - OK.
>Try run Enterprise manager - it working.
>Create Datasource with Oracle driver 8.0.4...
>Try Sqlconnect from VFP - works.
>
>I don't know, what client software is better. I want create datasource on fly, too.
>I have 3 months :-) to rewrite application from fileserver to Oracle.
>Can I avoid ODBC ?
>Now I try some code - and everything is different. For example: updatable views with varchar columns, using sequenses, ... Where can I found code samples ?
>Pavel
You can find any code samples from me, we wrote and used big vcx classes to work with oracle. We also did automatic forms designerfrom Oracle to VFP.
Simple forms can be done automatically.
I have doubt , you alone for 3 month will do VFP/Client server product.
Any way, user security takes of big work.
You can avoid ODBC in PowerBulder and Oracle forms, not at Microsoft products.
We rare use remote views on the reason the form load very slow
Next reason, there are so name schemas in Oracle.
You could keep for example one developer base at one schema and real base with same tables at other.
when you create remote views, schema is merged in view, so if you like to switch to different schema,
you have to have other VFP base or programm which substitute all scwith different one
We use sqlexec
Sequencies are very easy, they are instead of seeds in MS SQL
There is brilliant book on Oracle, best I know. I have 5-8 books and all of them much bigger, but less usefull.
I have expirience with writing also VFP/Interbase and VFP/MS SQL7
so everybody wellcomed to ask me.
I guess, I know all rakes at VFP/Oracle way, half of the on the rest of servers.
Where is written everything, tomorrow I can tell you referencies.