BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Strange problem with Oracle and Delphi 2006          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message Guy Guest Posted: Tue Oct 17, 2006 2:32 pm    Post subject: Strange problem with Oracle and Delphi 2006 Hi I have two Oracle servers (8.0.4 and 8.1.7) and three workstations (Xp, one Delphi7 Arch, one Delphi2006 Arch and one both) I'm trying to connect to the Oracle server. With Delphi7 the connection works fine with all 3 methods (BDE, ADO, DBX) and also no problems with SQLExplorer with Delphi2006 (on the same computer!) noting works ADO fails with "vendor xxx missing", BDX fails with "faild to load oci.dll", dbexplorer with "vendor initilization filed" and BDE just hangs.... this is the same worktation that Delphi7 works!!!!! any ideas? Back to top Nick Crisp Guest Posted: Fri Oct 27, 2006 9:37 pm    Post subject: Re: Strange problem with Oracle and Delphi 2006 Hi Guy Can you check that the Authenticated Users group has read and excute permisions on the Oracle home directory and all subdirectories. I think you need to reboot before trying again. If this doesnt work, try giving everyone read + execute. I had this problem with D2006 and a .Net app where the .Net process can't access the Oracle libraries. Regards Nick "Guy" <guy (AT) meitavsys (DOT) co.il> wrote in message news:4534a33b$1 (AT) newsgroups (DOT) borland.com... Quote: Hi I have two Oracle servers (8.0.4 and 8.1.7) and three workstations (Xp, one Delphi7 Arch, one Delphi2006 Arch and one both) I'm trying to connect to the Oracle server. With Delphi7 the connection works fine with all 3 methods (BDE, ADO, DBX) and also no problems with SQLExplorer with Delphi2006 (on the same computer!) noting works ADO fails with "vendor xxx missing", BDX fails with "faild to load oci.dll", dbexplorer with "vendor initilization filed" and BDE just hangs.... this is the same worktation that Delphi7 works!!!!! any ideas? Back to top Guy Guest Posted: Thu Nov 09, 2006 8:05 pm    Post subject: Re: Strange problem with Oracle and Delphi 2006 It is not a permission/security problem, exactly the same setup, on the same computer, user and database works with Delphi7...... It is something that is wrong with DB access mechanishm for Oracle in D2006, But I have no idea what.... I still didnt solve the problem, I'm know able to get to the Oracle DB in D2006 by ADO and BDE by moving oci.dll to the windows dir..... BDP still doesnt work.... Back to top Charles Hodgkins Guest Posted: Fri Nov 10, 2006 11:52 pm    Post subject: Re: Strange problem with Oracle and Delphi 2006 Guy wrote: Quote: Hi I have two Oracle servers (8.0.4 and 8.1.7) and three workstations (Xp, one Delphi7 Arch, one Delphi2006 Arch and one both) I'm trying to connect to the Oracle server. With Delphi7 the connection works fine with all 3 methods (BDE, ADO, DBX) and also no problems with SQLExplorer with Delphi2006 (on the same computer!) noting works ADO fails with "vendor xxx missing", BDX fails with "faild to load oci.dll", dbexplorer with "vendor initilization filed" and BDE just hangs.... this is the same worktation that Delphi7 works!!!!! any ideas? Guy, What does your path statement say and also do you have more than one Oracle client installed. If so did you set the Home correctly? I've been using BDS2006 with Oracle 8.1.7 & 9.2 without problems although I've been using Direct Oracle Access instead of BDX. Also ADO work just fine. I've used it in both native XP and VMWare hosted XP. Charles Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.