Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Forms with mssql

Oracle Forms with mssql

From: Dolly <dollyaouad_at_hotmail.com>
Date: 1 Nov 2001 00:39:26 -0800
Message-ID: <1b44c473.0111010039.152ae02a@posting.google.com>


Hi
I really need a fast answer;
Am trying to access data on sql 7 server from oracle forms 6i; I installed the OCA and run the script of creating views for ALL_USERS,ALL_OBJECTS,ALL_TABLES,
ALL_VIEWS,ALL_SYNONYMS,ALL_TAB_COLUMNS,ALL_SOURCE,ALL_ERRORS,USER_USERS,    USER_SYNONYMS,ACCESSIBLE_COLUMNS,PRODUCT_USER_PROFILE. I got this script while installing the OCA. Now this script says that it s used for sql6.
The problem is that when i try to connect in the form builder (in the host i put the odbc:name of the odbc i created: database) it fires a real weird error without any number (just a backslash!!!!!); but i can do an explicit connection using exec_sql statements!!! same problem in sql plus but this time it says no interface driver! I really need to make a real connect from the forms builder not in the exe to make based tables block and create master detail blocks!!!! Please answer me as soon as possible; it s really an urgent case and it would be great if u can reply to my mail or to dolly_at_softwaredesign.com.lb
thanks a lot Received on Thu Nov 01 2001 - 02:39:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US