connect to an oracle DB

This is a discussion on "connect to an oracle DB" within the PHP Forum section. This forum, and the thread "connect to an oracle DB are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > PHP Forum

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Aug 30th, 2007, 10:59
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
connect to an oracle DB

hi, i want to know how i can connect to a oracle db and send query for it.
my question is just conneting to it.
is it need some extra server for conneting to oracle ?
thanx a lot
missing your question.
(i can't speak english good so i'm sorry)
Reply With Quote

  #2 (permalink)  
Old Aug 30th, 2007, 16:30
alexgeek's Avatar
Technical Administrator

SuperMember
Join Date: Jul 2007
Location: Webforumz 24/7
Age: 15
Posts: 3,772
Blog Entries: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alexgeek
Re: connect to an oracle DB

google is your friend
http://www.orafaq.com/faqphp.htm#CONFIG
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
Reply With Quote
  #3 (permalink)  
Old Aug 31st, 2007, 07:46
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
Re: connect to an oracle DB

thanx a lot
another question.
when i run easyphp it alerts " this application has field to start because OCI.dll ... "
what i can do ?
how can i fix this problem and run OCI.dll ?

Last edited by bahy; Aug 31st, 2007 at 07:50.
Reply With Quote
  #4 (permalink)  
Old Aug 31st, 2007, 08:39
alexgeek's Avatar
Technical Administrator

SuperMember
Join Date: Jul 2007
Location: Webforumz 24/7
Age: 15
Posts: 3,772
Blog Entries: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alexgeek
Re: connect to an oracle DB

this should help;
google "download OCI.dll"
and see if you can donwload the file
then place it in your c:\windows\system32\ folder
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
Reply With Quote
  #5 (permalink)  
Old Aug 31st, 2007, 08:45
SuperMember

SuperMember
Join Date: Jun 2007
Location: uk
Posts: 459
Thanks: 0
Thanked 0 Times in 0 Posts
Re: connect to an oracle DB

this is taken from a setup page.

How to solve it? First choice, you need to put the correct verion of oci.dll (8.1.7) in your currrent PATH environment.
Second choice, you can copy the correct version of oci.dll from $ORACLE_HOME/bin/oci.dll (8.1.7) in to APACHE Home.
I use the second choice because I don't need to change path environment that can take effect to other program that use different oci.dll version.


Hope this helps
Reply With Quote
  #6 (permalink)  
Old Aug 31st, 2007, 08:48
alexgeek's Avatar
Technical Administrator

SuperMember
Join Date: Jul 2007
Location: Webforumz 24/7
Age: 15
Posts: 3,772
Blog Entries: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alexgeek
Re: connect to an oracle DB

Quote:
Originally Posted by dab42pat View Post
this is taken from a setup page.

How to solve it? First choice, you need to put the correct verion of oci.dll (8.1.7) in your currrent PATH environment.
Second choice, you can copy the correct version of oci.dll from $ORACLE_HOME/bin/oci.dll (8.1.7) in to APACHE Home.
I use the second choice because I don't need to change path environment that can take effect to other program that use different oci.dll version.


Hope this helps
I think that method's for linux systems, i use windows.
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)

Last edited by alexgeek; Aug 31st, 2007 at 08:52. Reason: spelling :)
Reply With Quote
  #7 (permalink)  
Old Aug 31st, 2007, 10:43
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
Re: connect to an oracle DB

thanx a lot from you all.
and another question :
(sorry i,m begginer in oracle ) is oracle like sqlite which create a db file in web root ?
Reply With Quote
  #8 (permalink)  
Old Aug 31st, 2007, 10:49
alexgeek's Avatar
Technical Administrator

SuperMember
Join Date: Jul 2007
Location: Webforumz 24/7
Age: 15
Posts: 3,772
Blog Entries: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alexgeek
Re: connect to an oracle DB

can't help you there.
i use mySQL
much easier and greater support
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
Reply With Quote
  #9 (permalink)  
Old Aug 31st, 2007, 10:55
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
Re: connect to an oracle DB

i do things which you say but
it hasn't fix yet ( =((
error are yet active and i'm upset
ERR :
The procedure entry point OCILobRead2 could not be located in the dynamic link library OCI.dll.

this application has fielad to start because OCIW32.dll was not found....
Reply With Quote
  #10 (permalink)  
Old Aug 31st, 2007, 11:00
alexgeek's Avatar
Technical Administrator

SuperMember
Join Date: Jul 2007
Location: Webforumz 24/7
Age: 15
Posts: 3,772
Blog Entries: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alexgeek
Re: connect to an oracle DB

you on linux or windows?
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
Reply With Quote
  #11 (permalink)  
Old Aug 31st, 2007, 11:02
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
Re: connect to an oracle DB

i'm on windows

Last edited by bahy; Aug 31st, 2007 at 11:04.
Reply With Quote
  #12 (permalink)  
Old Aug 31st, 2007, 11:03
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
Re: connect to an oracle DB

Quote:
can't help you there.
i use mySQL
much easier and greater support
i use mysql too but i want to learn oracle too as like as i know sqlite !
Reply With Quote
  #13 (permalink)  
Old Aug 31st, 2007, 11:06
alexgeek's Avatar
Technical Administrator

SuperMember
Join Date: Jul 2007
Location: Webforumz 24/7
Age: 15
Posts: 3,772
Blog Entries: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alexgeek
Re: connect to an oracle DB

okay.
downloading the DLL files and putting them in yur system 32 folder should sort everything
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
Reply With Quote
  #14 (permalink)  
Old Aug 31st, 2007, 12:07
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
Re: connect to an oracle DB

thanx. i do it and then response.
thanx a lot

Last edited by bahy; Aug 31st, 2007 at 12:11.
Reply With Quote
  #15 (permalink)  
Old Aug 31st, 2007, 12:24
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
Re: connect to an oracle DB

now error says :
The procedure entry point OCILobRead2 could not be located in the dynamic link library OCI.dll.
.... what i do now ?
Reply With Quote
  #16 (permalink)  
Old Aug 31st, 2007, 12:26
alexgeek's Avatar
Technical Administrator

SuperMember
Join Date: Jul 2007
Location: Webforumz 24/7
Age: 15
Posts: 3,772
Blog Entries: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alexgeek
Re: connect to an oracle DB

cos i'm so nice.
i'm gunna try and install oracle on my server now
and if i get any of these errors i'll tell you
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
Reply With Quote
  #17 (permalink)  
Old Aug 31st, 2007, 12:27
alexgeek's Avatar
Technical Administrator

SuperMember
Join Date: Jul 2007
Location: Webforumz 24/7
Age: 15
Posts: 3,772
Blog Entries: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alexgeek
Re: connect to an oracle DB

which edition you using?
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
Reply With Quote
  #18 (permalink)  
Old Aug 31st, 2007, 15:13
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
Re: connect to an oracle DB

i don't know what you mean.
i didn't install oracle on my system. i'm just trying to work by php with oracle.
Reply With Quote
  #19 (permalink)  
Old Aug 31st, 2007, 15:16
alexgeek's Avatar
Technical Administrator

SuperMember
Join Date: Jul 2007
Location: Webforumz 24/7
Age: 15
Posts: 3,772
Blog Entries: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alexgeek
Re: connect to an oracle DB

how are you supposed to use it if you don't even have it?
Last Blog Entry: 3D Chess in your browser! (Mar 14th, 2008)
Reply With Quote
  #20 (permalink)  
Old Aug 31st, 2007, 15:27
Junior Member
Join Date: Jun 2007
Location: IRan
Age: 19
Posts: 29
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bahy Send a message via Yahoo to bahy
Re: connect to an oracle DB

i think which my first question is it !!!!!!!!!!!!!
plz read my first question again.
and i think if it need the oracle program must said in php.net
but there just says OCI needed.
plz help me ((((
Reply With Quote
Reply

Tags
oracle

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle DBA Web JobBot Job Opportunities 0 Feb 20th, 2007 11:30
Oracle DBA - Investment Bank Web JobBot Job Opportunities 0 Feb 20th, 2007 11:30
Oracle Corporation:- Scientist Position rose Job Opportunities 0 Feb 7th, 2007 02:31
Java/Oracle Developer - Cardiff Web JobBot Job Opportunities 0 Jan 16th, 2007 09:30
Oracle Developer Position lintasllc Job Opportunities 0 Dec 15th, 2005 19:55


All times are GMT. The time now is 07:37.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43