dbisql connection problems
Mike M
to a new PHP5 server. The site uses PHP code connecting to an external
database that the client maintains. On the old server, it was using
SQLAnywhere 9 client libraries and the extension for PHP4. We've
installed SA11 and the PHP5 module on the new server, but not been
able to connect to the database.
To take PHP out of the equation, I'm trying dbisql, and I find the
same issue. Same connection string, but on the old server, dbisql
comes up and allows me to execute queries, while on the new one, I get
a dialog "Connecting to database..." and it stays that way forever. I
have to kill the app to stop it. Error logging appears identical
between the two servers, except for different client IPs, different
SQLAnywhere version etc. Also, even though the GUI dialog indicates it
is still connecting, the error logging says "Connected to database
successfully" which I'm starting to think is not correct.
Thought it could be a firewall issue, however the client says there
are no restrictions on their end, and indeed I can telnet to the
database server on port 2638 on both machines. And I've checked with
our hosting company, but they say "the firewall is wide open for
connections originating inside the trusted perimeter".
I am including below a redacted copy of the error logging from
attempting to run dbisql on the new server. Is there something I am
missing? Thank you very much for any help you can provide!
Thu Mar 11 2010 12:50:14
12:50:14 Attempting to connect using:
UID=UID-REDACTED;PWD=********;DBN=DBN-REDACTED;ENG=ENG-
REDACTED;CON=SQL_DBC_e4e0f600;LOG=error.log;LINKS='tcpip(host=IP-
REDACTED:2638)';CS=iso_1;LANG=EN
12:50:14 Attempting to connect to a running server...
12:50:14 Trying to start TCPIP link ...
12:50:14 My IP address is 127.0.0.1
12:50:14 My IP address is IP-REDACTED
12:50:14 My IP address is 10.2.1.162
12:50:14 My IP address is ::1%1
12:50:14 My IP address is fe80::230:48ff:fe98:1749%3
12:50:14 My IP address is fe80::230:48ff:fe98:1748%2
12:50:14 TCPIP link started successfully
12:50:14 Attempting TCPIP connection (address IP-REDACTED:2638 found
in sasrv.ini cache)
12:50:14 Trying to find server at cached address IP-REDACTED:2638
without broadcasting
12:50:14 Found server, verifying server name
12:50:14 Found database server at address IP-REDACTED
12:50:14 Found database server fasline on TCPIP link
12:50:14 Connected using client address IP-REDACTED:60299
12:50:14 Connected to server over TCPIP at address IP-REDACTED:2638
12:50:14 Application information:
12:50:14 IP=IP-REDACTED;HOST=HOST-REDACTED;OS='Linux 2.6.18-53.el5 #1
SMP Mon Nov 12 02:14:55 EST 2007 x';EXE=/opt/sqlanywhere11/bin32/
dbisql;PID=0xd1c;THREAD=0xe42b5b90;VERSION=11.0.1.2044;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-300
12:50:14 Connected to the server, attempting to connect to a running
database...
12:50:14 [1865363313] Connected to database successfully
Mike M
connect to the db from the new server nor from the old server. dbping
from SA9 does connect to the db from the old server. We have SA11
because of the libraries needed for the PHP5 module.
Found this
http://dcx.sybase.com/1100en/sachanges_en11/v10upgrade-up-sql-any-123456.html
Management of old databases and old database servers from the current
version of Sybase Central is provided as follows:
* You can connect to and administer version 9 and later databases
running on version 9 and later servers.
* You can connect to a version 5 or later database running on the
same machine as Sybase Central to rebuild the database using the
Unload Database Wizard from Sybase Central. The database is stopped
before it is unloaded.
* There is no support for version 7 and earlier databases running
on version 7 and older database servers.
If I understand -- we cannot use SA11 to connect to the ASA 7 db
server? Is there an option here given that we are running PHP5 and
need to connect to a version 7 server? Thanks...