Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

connection to oracle db
(1 viewing) (1) Guest
Go to bottomPage: 12345
TOPIC: connection to oracle db
*
#53252
Re:connection to oracle db 9 Years, 2 Months ago Karma: 0
Do you have any idea ... admin?
The administrator has disabled public write access.
 
#53254
Re:connection to oracle db 9 Years, 2 Months ago Karma: 747
Sorry, but we provided before what we could.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#53301
Re:connection to oracle db 9 Years, 2 Months ago Karma: 0
Hi guys, we have news.
Now i can see connection to the database, i've tested with a php script the odbc_connect() and it works great, receiving data from DB.
<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
$dsn = "Driver=Oracle;Server=fun********ecom.local;Port=1521;Database=ser*****;";
echo "ODBC TEST SCRIPT";
$con = odbc_connect($dsn,"USR********RO","PASSWORD");
echo $con;
$rs2 = odbc_exec($con, "select * f******************************************'");
odbc_result_all($rs2);
odbc_close($con);
php?>

By the way from the module i've again some problem,
into HOST field i've placed part of the DSN without the "Database" part, that filled indeed the DB name field.
The connection to DB start correctly, and we can see packets dumping connection, by the way the connection end with "no data received" from DB.
From the wireshark data, seems that the "SELECT" don't start from server. In wich mode is necessary fill the "SQL query" TEXTBOX? If i place over there any select it doesnt sent to the database. As you can see below the TCP stream of the connection, let me know pls!
Last Edit: 2015/02/02 16:31 By admin.
The administrator has disabled public write access.
 
#53305
Re:connection to oracle db 9 Years, 2 Months ago Karma: 747
Use the same value for "Host" parameter like value of $dsn variable in your script. Place "SELECT" SQL query to "SQL -> SQL query" parameter in module settings.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#53307
Re:connection to oracle db 9 Years, 2 Months ago Karma: 0
That was exactly what i did!
The connection to the database work gracefully, the first 2 select to oracle
SELECT VALUE FROM SYS.NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET'
and
SELECT VALUE FROM SYS.NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_NCHAR_CHARACTERSET'
works great, but then the "SELECT" filled into the module does'nt work!
From the tcpdump i cannot see sending the SELECT to the server!
Last Edit: 2015/02/03 09:45 By kmbarm77.
The administrator has disabled public write access.
 
#53308
Re:connection to oracle db 9 Years, 2 Months ago Karma: 747
Could you provide a link to a page where the problem occurs and a temporary access to your J! backend by email so we can investigate the problem?

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12345