Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

TierDeveloper is unable to connect with the Oracle Server. How can I solve this problem?

April 26, 2017Connect Oracle problem server tierdeveloper

0

Posted

TierDeveloper is unable to connect with the Oracle Server. How can I solve this problem?

1 Answer

0

Posted

TierDeveloper uses Oracle OLE DB Provider to connect with Oracle (8i/9i/10g) database server. Make sure the following is installed and configured on your system (thats running TierDeveloper). 1. Download Oracle Provider for OLE DB (9.2.0.1.0 or a later version) from Oracle web site http://otn.oracle.com/software/tech/windows/ole_db/htdocs/utilsoft.htm and install it on your system. 2. Use Net Configuration Assistance tool to configure a local Net Service (if one is not already configured on your system) e.g. “testdb” against Oracle Database Server. 3. Launch TierDeveloper and select “Data Object Wizard” to create new project against Oracle database e.g. to connect with Demo (scott/tiger) schema, specify the following values on Connection Attributes page. User Name = scott Password = tiger Service Name = testdb Schema Name = scott 4. Click Next button to proceed so that TierDeveloper reads database schema information.