Package: php5-odbc
Version: 5.6.9+dfsg-1
Severity: minor
Tags: upstream
Dear Maintainer,
I was getting timeout on login for odbc_connect when connecting to SQL Server
2000 + 2005,
usually to fix such an issue I set the login timeout during connect.
I was expecting to find something that could allow me to set login
timeout in php.ini,
or a timeout value in odbc.c like:
SQLSetConnectOption(
conn->hdbc,
SQL_ATTR_LOGIN_TIMEOUT,//or maybe SQL_ATTR_CONNECTION_TIMEOUT
xxxx);
but I failed to find an option or a refernce on how I can modify the login
timeout.
the suggested solution on MSDN for such an error is to drop
odbc_connect/pconnect and switch to sqlsrv_connect[1].
As I understand odbc_setoption should be called after the login had been done,
otherwise I don't see how I can access the connection handle, before doing
odbc_connect.
[1]
-https://social.msdn.microsoft.com/forums/sqlserver/en-US/d24045a2-6a3d-42f8-8005-6c4a49c17ac4/timeout-expired
-- Package-specific info:
==== Additional PHP 5 information ====
++++ PHP 5 SAPI (php5query -S): ++++
++++ PHP 5 Extensions (php5query -M -v): ++++
++++ Configuration files: ++++
**** /etc/php5/mods-available/odbc.ini ****
extension=odbc.so
**** /etc/php5/mods-available/pdo_odbc.ini ****
extension=pdo_odbc.so
-- System Information:
Debian Release: 8.0
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 3.9-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages php5-odbc depends on:
ii libc6 2.19-13
ii libodbc1 2.3.1-3
ii php5-common [phpapi-20131226] 5.6.9+dfsg-1
ii ucf 3.0030
php5-odbc recommends no packages.
php5-odbc suggests no packages.
Versions of packages php5-common depends on:
ii libc6 2.19-13
ii lsof 4.86+dfsg-1
ii psmisc 22.21-2
ii sed 4.2.2-4+b1
ii ucf 3.0030
Versions of packages php5-common suggests:
pn php5-user-cache <none>
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
