Oracle Database - Cannot Connect From PHP Script

Jul 19, 2010

I have created an Oracle database on my Windows XP system but cannot connect from a php script

CODE

<?php
if (!$db = @ocilogon("big", "big", "s7s"))
    {
    $error = ocierror();
    printf("Error was: %s", $error["message"]);
    die();
    }
$stmt = ociparse($db,"SELECT count(*) FROM members");
ociexecute($stmt);
?>

When I created the database the connection I used was s7s but whether or not I include that name or just use the ID/password that script will not connect.

View 2 Replies


ADVERTISEMENT

Connect Oracle Database From Delphi - Could Not Resolve Connect Identifier Specified

Oct 6, 2010

I have the following computer/setup:

Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)

I cannot can't to the Oracle database from Delphi. The error I keep getting is:

Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.

Here's what I've done:

1. Create an ODBC connection to my Oracle database

- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.

2. Open Delphi and drop a TDatabase component on my main form.

- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".

Alternatively, I tried using the Delphi ADO components (the dbGo components).

- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".

Again the same error.

My questions are:

1. Can Delphi work with Oracle XE (Express Edition)?

2. If so, then do I need to install the "Instant Client"?

3. Will the instant client for Oracle 10g work with Oracle 10g XE?

4. Do I need to install any additional ODBC driver(s)?

5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?

6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?

View 2 Replies View Related

ODP.NET :: Connect To Database Oracle With C#

Oct 19, 2012

I am trying to develop a web application with C # VS.net, my application is to connect to an Oracle database on a server (LAN), the problem I want to connect to the database without install oracle or ODP on my client machine.

View 1 Replies View Related

SQL & PL/SQL :: How To Connect Oracle 10g Database Through Online

Dec 8, 2011

how to connect oracle database through online

View 8 Replies View Related

Windows :: Connect To 8i Database Via Oracle 9.02 ODBC

Sep 17, 2002

I am attempting to connect to an Oracle 8i database via the Oracle 9.02 ODBC driver and I am receiving the following error message upon testing the connection in WinXp's ODBC Data Source Administrator dialog box: "Unable to connect SQLState=IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" .

I am running Oracle Client 9.2 on a P4 machine running winXP.

View 28 Replies View Related

Forms :: Using 6i To Connect Oracle Database 10g Express

Oct 8, 2011

I have encountered a problem about using Oracle Form 6i to connect Oracle Database 10g express.

As I would like to

I use Oracle Net8 Easy Config to create a connection.

According to "tnsnames.ora", the parameter of connection is as follows;

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA = (SID = XE))
)

Unfortunately, when I use Oracle Net8 Easy Config to test the connection, an error message is prompted as follows:

Connecting....

The test did not succeed.

ORA-03106: fatal two-task communication protocol error

There may be an error in the fields entered or the server may not be ready for a connection. You can check the server and retry, or continue.

View 1 Replies View Related

Networking And Gateways :: Oracle Database Not Connect From Outside LAN Via Static IP

Nov 17, 2011

I have created two database one for production and another one for test.I created both database in shared_server mode(by using dbca),after than I did not change anything.My problem is when i connect to test database from outside lan through static ip its working well,but when i connect to production database which is not connected. I checked and compared two databases,then I find there are some changes in dispatcher and mts_ dispatcher parameters.And I used this query to check the shared_server status,

ie.select * from v$shared_server,

the output of this query is attached with this post.

View 8 Replies View Related

Networking And Gateways :: Using Putty To Connect To Oracle Database?

Jul 5, 2011

Do I need to install the Oracle client in order to use putty to connect to the database?

View 11 Replies View Related

SQL & PL/SQL :: Connect To Oracle Database From Log4net.config File?

Apr 26, 2012

Need to know how to connect to Oracle (11g) database from Log4net.config file. As I need to wright the logs to the Oracle (11g) database when any user logon to the web application.

Note: I am succesfully able to wright the logs to the text files but not able to wright the logs to the Oracle (11g) database.

View 6 Replies View Related

Can Application Connect With Windows Authentication To Oracle 11.2.0.3 Database

Jul 16, 2013

Can application connect with windows authentication to oracle 11.2.0.3 database? if so then how can i set it up! 

View 3 Replies View Related

Windows / .NET :: Procedure To Connect To Oracle Database From MS Access?

Nov 29, 2012

let me know the procedure to connect to Oracle Database from Ms-Access.

We are using Windows as Operating System.

View 1 Replies View Related

Oracle And MySQL Database - Could Not Resolve Connect Identifier Specified

Jun 2, 2011

i tried for 3 days to setup a connection between my oracle database 11.2 (resides on 2003,64 bit Microsoft windows) and a mysql database (resides on 2003,32 bit Microsoft widows).

i used dg4odbc 64 bit which was installed on oracle server, my steps was as follows :

1- configure ODBC driver (MYSQL 3.51 odbc) on oracle server that connect to mysql database and the connection was tested successfully (the name of odbc dsn is DG4ODBC).

2- configure the listener.ora file (which resides on dg4odbc installation path) that contains the following :

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxxxx)(PORT = 1511))

[code]....

3- configure the tnsnames.ora file (which resides on oracle database path) that contains the follwoing :

DG4ODBC =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxxxxxxx)(PORT=1521))
(CONNECT_DATA = ( SERVICE_NAME = DG4ODBC ))
(HS=OK)
)

4- configure that initdg4odbc.ora file that resides on the dg4odbc installation.

HS_FDS_CONNECT_INFO = DG4ODBC
HS_FDS_TRACE_LEVEL = off

5- restart the gateway listener.

6- test DG4ODBC service by tnsping which was successful .when i try to get some data from mysql database by SELECT * FROM MDL_COURSE@DG4ODBC query,the query take some time (15 second !!) and return

ORA-12154: TNS:could not resolve the connect identifier specified

View 2 Replies View Related

Forms :: How To Connect Excel With Oracle Database Via 10g Login Screen

Jul 20, 2010

In fact I have around 50 excelbooks that are connect with oracle via ODBC/or any other way. My task is to build the login screen on form 10g. This form will validate the user via .dll after successfully validation, Form will connect to specific oracle user. This Login Screen will call the new form that will execute the query for the list of excel sheet [table that will keep the name, description and path of the excelbook]. User will select the one excelbook to open. As user will select Excelbook should be open. Now this excel book should be connected with specific oracle user.

Question 1: How to open the excelbook, that excelbook should be connected via form 10g login screen. After connection excel has its own micros to run he query from oracle database.

Question 2: How I can create the mirco into form 10g to run into excelbook/excelsheet.

Question 3: How I can pass the query or function/procedure to the excelbook/excelsheet.

View 3 Replies View Related

Server Administration :: Oracle Hang - Client Cannot Connect Database

Apr 29, 2012

all of the client cann't connect the db,and using sqlplus / as sysdba also cann't login there are many error of TNS-12535 and in the listener.log

alert.log:
Sun Apr 29 18:10:36 2012
opidcl aborting process unknown ospid (42992060) as a result of ORA-604
Sun Apr 29 18:10:54 2012
opidcl aborting process unknown ospid (26280196) as a result of ORA-604

[code]...

View 5 Replies View Related

Client Tools :: Connect Oracle Developer 6i Without Connect String

Aug 17, 2010

I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.

View 1 Replies View Related

Windows / .NET :: Visual Studio 2010 64bit Can't Connect Oracle Database Through 64bit ODBC Driver

Sep 25, 2013

I am developing an 64bit And-In software. My OS is windows7 64bit Ultimate. Developer tool is Microsoft  Visual Studio 2010 Ultimate 64bit any-CUP.Server is SUN server and Oracle database 10.2.0.5 64bit enterprise edition.I have installed instantclient-odbc-win64-10.2.0.5 on my computer.I am able to connect through the command line sqlplus user/pass@server.In date source(c:windowssystem32odbcad32.exe), ODBC Driver connection successful.But in VS2010 C#, use Tools -> Connect Database,I get an error 193 (Oracle in instantclient10_2,c:ora10_64SQORA32.dll) cann't be loaded.SQORA32.dll is 32bit ODBC Driver or 64bit ODBC Driver?How can I connect database with vs2010 64bit? 

View 2 Replies View Related

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

View 1 Replies View Related

Can Connect From Database 1 To 3

Nov 10, 2011

For example, I have 3 database, database 1 and database 2 connect together by database link db_link1, database 2 and database 3 connect together by database link db_link2.

I want to ask: Can I connect from database 1 to database 3 ? ( Of course don't use database link between database 1 and 3, just use database db_link1 and db_link2 )

Both db_link1 and db_link2 are public database link.

Can I restrict user access by 2 these public database link ?

View 1 Replies View Related

ORA-257 Not Able To Connect To Database?

Feb 11, 2013

I am not able to connect to database due to ORA-257. So manually i deleted the archivelog files in diskgroup. however it is showing 13gb free space after deletiion. Archive log files generated due to Import job is running.

In below ways i have tried to connect to database.

1) Through SQLPLUS (Not able to Connect)
2) Through RMAN i tried to connect (Not able to connect)
3) I tried to connect impdp to stop the running job. It was also failed

View 7 Replies View Related

How To Connect To SQL Database Server

Feb 23, 2009

I do not know how to create a connection between oracle to SQL server using topology manager on my application. I understand that I must create a logical and physical architecture to create the connection and the logical and physical architecture is running under topology manager.

View 1 Replies View Related

Forms :: How To Connect Database

Jul 18, 2011

while new form open i need to connect the data base.

View 5 Replies View Related

SQL & PL/SQL :: Password To Connect To Database

Oct 24, 2010

I extracted the script of creating user in my database in SQL navigator and Toad tools but it is displaying encrypted password. But I am unable to connect with that password.

To get the original password then I will be able to connect my database.

View 3 Replies View Related

Forms :: How To Connect 6i To Run On SQL Database

Aug 26, 2010

How can I connect forms6i to run on SQL database ?

View 4 Replies View Related

ORA-00604 When Connect To Database

Sep 10, 2008

I'm writing PRO C program with oracle 8i. My process first connect to the database with using ora_connect(), proceed the task then diconnect with using ora_disconnect(). This would always in a loop, recently after few cycle of connect and disconnect, when the next issue connect statement, it was unable to connect and return me ora-00604 and the process end. Even i restart the process, after few cycle also the same return me ora-00604 during the connect.

View 3 Replies View Related

Database 10.2.0.3 - Cannot Connect To Sqlplus?

Aug 29, 2012

My database in on 10.2.0.3 and facing hang problem when I am connecting to sqlplus.

bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 29 00:54:03 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:
ORA-01075: you are currently logged on

As per Metalink note(215858.1) suggested in forums I have followed steps and produced results below.

bash-3.00$ sqlplus -prelim

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 28 23:28:02 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name: / as sysdba
SYS on test>oradebug help
SYS on test>oradebug setmypid
Statement processed.
SYS on test>oradebug hanganalyze 12

[code]...

Now I have got struck how to analyze above results.

View 3 Replies View Related

How To Connect D2k Form To Database

Jun 8, 2011

How can i connect my d2k form to database, when i installed d2k it gave an error like :

user1.pin(20):os_error while spawning ifsrv660-install forms60 server port=9000
mode=socket batch=yes

after installation when i want to compile my form it gave tns error like:
ora-12154:tns:could not resolve service name

View 3 Replies View Related

XE :: 11g - Can't Connect To Database After Installation

Jan 31, 2013

I recently installed Oracle database 11g XE onto my home computer running Windows 32 bit, but I can't connect to the database. I also have Oracle 10g R2 installed on my computer, and I can still connect to it finely. When trying to make a connection in SQL DEVELOPER, I get this error

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I tried to tnsping the XE database and it returns successfully.

C:>tnsping xe
TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-JAN-2
013 07:59:17
Copyright (c) 1997, 2010, Oracle.  All rights reserved.
Used parameter files:
C:oraclexeapporacleproduct11.2.0server
etworkadminsqlnet.ora

[code]....

View 3 Replies View Related

SQL & PL/SQL :: How Many Users Can Connect With Database

Apr 23, 2010

I want to know what will be the performance of my DB before loading data and how many users can connect with my database.

View 7 Replies View Related

Connect To Database Through JDBC?

Jul 17, 2013

have a problem while i am trying to connect to database through JDBC here is my code,i am using oracle11g express edition import java.sql.

Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;    public class connectiontoDB {    public static void main(String[] args) throws Exception {  // TODO Auto-generated method stub  try{  Class.forName("oracle.jdbc.driver.OracleDriver");  Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","citi","citi");        Statement stmt=con.createStatement();        stmt.executeUpdate("create table user(id number(10))");        System.out.println("connected to database successfully");  }  catch(Exception e){       e.printStackTrace();

View 1 Replies View Related

SQL & PL/SQL :: Code To Connect External Database

Apr 8, 2013

How to write a code(procedure) to connect external database through PLsql coding.. I mean,

first, "Create connection like connection string", then "retrieve data from tables inside the database".

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved