Re: Developer 2000 - to be use with non oracle database

Hi Azan,
  I've been migrating application (developer/2000) and database Oracle RDBMS to Ms SQL Server 7

 First, You have to install Oracle OCA (Open Client Adapter) for ODBC ,   it will install some documentations that explain the connectivity from Ora developer/2000 to many database
  in 'open 2000 documentation' group menu. you can follow them. Documentation for connecting to SQL7
is not available yet. but u can use "Using Dev2000 with Sybase and SQL Server" (SQL 6.5)  u can connect your dev/2k to Sql7 thru ODBC by typing "scott/tiger_at_odbc:sql7" as connect string (sql7 is DSN)
 but u must create some 'oracle dictionary'/tables (such as : 'ALL_TABLES' table, etc) on Ms Sql7 first
  because Ora Dev/2k Forms STILL read oracle syntax and oracle dictionary.   It will be the main problem when you compile your programs, if you re not experience enough with dev/2k.

  I dont recommed you using Dev/2k Forms , if your application is complicated.

 I dont think Dev/2k Forms Menus Securities still work, either

TS

azhan98_at_tm.net.my wrote:

> Hi all,
>
> I have a very straight forward question.
>

;;;;;;;

> So, my question is,
> I can also use it with Microsoft SQL Server right?
>
> If so, how can I connect to MS SQL Server using Oracle Report & Oracle Form.
>
> Appreciate if you can give me an example and explanation.
>
> Thanks & Best Regards
>
> Azman
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Dec 02 1998 - 12:58:19 CET