PHP7/PHPNG Support

2017-05-18T14:27:19.945000Z

Firstly, thanks for this livesaving software!

Development seems to have nearly halted though, which is a concern given the lack of support for php7 now

So I had to create a php wrapper script which depends on odbtpcli to fetch required data, as I can't get the php extension compiled for php7.... it barely works and I don't trust it. Are there any plans to port the php extension to php7?
Conversion guide is at https://wiki.php.net/phpng-upgrading , but I tried to port this and failed due to all the zend changes which are far beyond the scope of my primitive coding abilities

Perhaps it's due to a lack of PHP7 support that ADODB are now listing this as obsolete and say that they won't be including it in ADODB v6? Come guys, let's change that. This is extremely useful software which must benefit from continued development / stay current. Perhaps an official github page is now in order ...??

[ODBEM][0]Memory Allocation Error

2016-10-04T22:01:09.782000Z

Has anyone had the error:

[ODBEM][0]Memory Allocation Error

When doing a prepare statement execute?
Is this error from the ODBTP service or from SQL Server running out of memory.

Compile the php extension with PHP 5.5

2015-07-22T19:25:58.606000Z

I have added php_odbtp.dll to all my 5.3, 5.4, 5.5 & 5.6 builds:
https://www.apachelounge.com/viewtopic.php?t=6359

In stead of remming out ZVAL_ADDREF(zVar), I changed that into Z_ADDREF_P(zVar). According to Chris it works fine.

Compile the php extension with PHP 5.5

2015-04-27T20:48:00.111000Z

I was able to compile odbtp in PHP 5.5 AND 5.6 with this changes in file php_odbtp.c

# diff php_odbtp.c php_odbtp.c.orig 
146c146
< static zend_function_entry odbtp_functions[] = {
---
> function_entry odbtp_functions[] = {
1927c1927
<     // ZVAL_ADDREF(zVar);
---
>     ZVAL_ADDREF(zVar);
4050c4050
<     // ZVAL_ADDREF(zVar);
---
>     ZVAL_ADDREF(zVar);

Regards

Compile the php extension with PHP 5.5

2015-03-13T19:33:58.776000Z

ODBTP will not compile under 5.5. Dont think ODBTP has been updated since 5.3.

I did see a .dll for a 5.4 compile but I have never gotten it to work above 5.3...

Compile the php extension with PHP 5.5

2015-03-13T07:22:58.560000Z

I'm trying to compile the php extension in a Ubuntu Server 14.04 with PHP 5.5:

cd php/ext/odbtp
phpize
./configure
make

But make ends with that error: "make: *** [php_odbtp.lo] Error 1"
Complete log: https://dl.dropboxusercontent.com/u/171128/odbtp_make_output.txt

Any idea? :-(

PHP 5.4

2015-03-13T07:15:29.865000Z

Did you get? I'm trying to compile it for PHP 5.5 and the 'make' command ends with an error 1.

Exceptions: how to get more info

2015-03-03T16:03:22.032000Z

My ODBTP system is really busy and I am getting some exceptions 1 to 3 times a day. I can see a new entry in the exception.log file when that happens. I have also tried enabling LogODBC and LogReadandSent but that did not help get more info. I am looking for more information about the exception in order to find out what is happening. Is it a problem with my client application, the SQL Server or else.
Anyone can suggest some way to get more logging/debugging information that will help me find what is happening ?

Log info taken from a restart this morning at 00h12m21

From exception.log
03/03/2015 00:12:21 (server)

From odbtpsrv.log
...
[03/Mar/2015:00:12:20] OPEN 192.168.0.72 59328
[03/Mar/2015:00:12:20] ODBC[[01000][5701][Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'MYDB'.]
[03/Mar/2015:00:12:20] ODBC[[01000][5703][Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.]
[03/Mar/2015:00:12:20] CLOSE 192.168.0.72 59328
[03/Mar/2015:00:12:20] OPEN 192.168.0.72 59329
[03/Mar/2015:00:12:20] ODBC[[01000][5701][Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'MYDB'.]
[03/Mar/2015:00:12:20] ODBC[[01000][5703][Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.]
[03/Mar/2015:00:12:20] CLOSE 192.168.0.72 59329
[03/Mar/2015:00:12:20] OPEN 192.168.0.72 59330
[03/Mar/2015:00:12:20] ODBC[[01000][5701][Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'MYDB'.]
[03/Mar/2015:00:12:20] ODBC[[01000][5703][Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.]
[03/Mar/2015:00:12:20] CLOSE 192.168.0.72 59330
[03/Mar/2015:00:12:20] OPEN 192.168.0.72 59331
[03/Mar/2015:00:12:20] ODBC[[01000][5701][Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'MYDB'.]
[03/Mar/2015:00:12:20] ODBC[[01000][5703][Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.]
[03/Mar/2015:00:12:21] CLOSE 192.168.0.72 59331
[03/Mar/2015:00:12:21] OPEN 192.168.0.72 59332
[03/Mar/2015:00:12:21] ODBC[[01000][5701][Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'MYDB'.]
[03/Mar/2015:00:12:21] ODBC[[01000][5703][Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.]
[03/Mar/2015:00:12:21] SERVER[Started]
[03/Mar/2015:00:17:28] OPEN 192.168.0.72 1
[03/Mar/2015:00:17:28] ODBC[[01000][5701][Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'MYDB'.]
[03/Mar/2015:00:17:28] ODBC[[01000][5703][Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.]
[03/Mar/2015:00:17:28] CLOSE 192.168.0.72 1
...

Normal client behavior is a 5 seconds pause followed by 10 connections/action/deconnections in rapid succession. The 59k connections is for 12 hours of operation.
My client application pauses 5 minutes when it encounters a connection error.

ODBTP is locally installed on the server as a service. Server is a DL380 G5 with Windows Server 2003 SP1, SQL Server 2005 9.0.4035. CPU usage is around 35%. I have other ODBTP installations on similar hardware/software platforms that do not have exceptions.

My only guess right now is related to the number of connections/deconnections. Our next option is to slow down the rate of work.

Any suggestion will be welcome.
Stephane

Recent posts to Discussion

PHP7/PHPNG Support

[ODBEM][0]Memory Allocation Error

Compile the php extension with PHP 5.5

Compile the php extension with PHP 5.5

Compile the php extension with PHP 5.5

Compile the php extension with PHP 5.5

PHP 5.4

Exceptions: how to get more info