Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 11:39
    codisart commented #411
  • Dec 04 14:25
    sweigand opened #568
  • Dec 03 16:49
    dregad commented #565
  • Dec 03 16:39
    dregad commented #552
  • Dec 03 16:37
    peterdd commented #552
  • Dec 03 16:37
    peterdd commented #552
  • Dec 03 16:36
    dregad commented #552
  • Dec 03 16:36
    dregad closed #552
  • Dec 03 16:36
    dregad milestoned #552
  • Dec 03 16:36
    dregad labeled #552
  • Dec 03 16:36
    dregad unlabeled #552
  • Dec 03 16:09
    pgusak commented #552
  • Dec 03 13:25
    dregad commented #552
  • Dec 03 11:46
    pgusak commented #552
  • Dec 03 02:49

    mnewnham on extended-metaindex-attributes

    Start Oracle Driver (compare)

  • Dec 02 16:09
    mnewnham commented #552
  • Dec 02 15:10
    pgusak commented #552
  • Nov 30 22:09
    peterdd commented #425
  • Nov 30 22:06
    mnewnham commented #425
  • Nov 30 22:01
    mnewnham commented #448
Damien Regad
@dregad
#449 ?
Didier GM
@didiergm
Looks like it
OK, I'll remove the line as suggested and see what happens; thanks @dregad
Damien Regad
@dregad
Thank you @didiergm. And since @UrvishSSPL has not yet provided any feedback, it would be great if you could let me know by posting a note in the issue, if the problem is indeed fixed and also if you notice any side-effects or regressions.
Didier GM
@didiergm
Of course will do, although it may take a wee while before I am confident there's no issues
Damien Regad
@dregad
No worries. Cheers !
Brice Favre
@brice
Hello, i use the last version of ADODB with the PDO-MySQL driver. I wonder why GenID is not supported? We need it for compatibility with one of our library. What should i do? Is it a good candidate for an issue and a PR?
Damien Regad
@dregad
@brice by all means do submit a pull request.
pikeshawn
@pikeshawn
I am not sure if anyone knows but is there a reason why I could connect with MYSQLi but not with PConnect? I keep getting connection refused with the same params as I use for Mysqli.
this works
$user='user';
$dbname='db';
$password='pass';
$port='1234';
echo "<br>$server<br>$user<br>$password<br>$port<br>$dbname<br>";
if (mysqli_connect($server, $user, $password, $dbname, $port)) {
   echo 'I connected';
} else {
        echo 'not connected';
}
this does not
$database->PConnect($host, $login, $pass, $dbase);
the values for the variables are the same
Mark Newnham
@mnewnham
You're not really comparing like-for-like, firstly, adodb uses mysqli_real_connect to connect, not mysqli_connect. More importantly, when you use pConnect(), you are establishing a persistent connection to the mysql database, which you are not doing with your own example. Try first using ->connect(), then move on from there
Damien Regad
@dregad

ADOdb Version 5.20.14 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.20.14/docs/changelog.md
Federico Martinez
@federicoemartinez
Hi! I need to connect to a MSSQL
Using tls, is that possible with adodb?
Mark Newnham
@mnewnham
Which driver. mssql or mssqlnative?
Federico Martinez
@federicoemartinez
We have this legacy app that needs to run using php 7.2 and support tls to connecto to sqlserver. It uses ADODB_odbc_mssql2012 to access sqlserver but it doesn't seem to work, we get an SSL error. We changed to native and it seems to work, however, the same app uses doctrine1 for migrations and it uses pdo to access sqlserver. Thing is that when we configure adodb to use the nativeclient, the application crashes (i think php segfaults) when we try to access the page where the migrations (and hence doctrine1) is loaded. We tried adodb with PDO_SQLSRV but it lacks the meta* functions. At the moment, we are trying to figure how why it crashes and see if we can update to doctrine2 or something. Sorry for the long story, do you know if it is possible using odbc_mssql2012 ? Thanks!
Federico Martinez
@federicoemartinez
we have configured xdebug to get a trace of the cash and it seems it's crashing in adodb code, specifically in ADORecordset_mssqlnative->_close() Any thoughts on what can we do?
Federico Martinez
@federicoemartinez
we found the query that made it crash: SELECT confvalue "0" from customconf where id = 3
we removed the "0" and it worked. Odd query but I guess it shouldn't crash
Damien Regad
@dregad
Good to hear you found the root cause of the problem. As to why it crashed, if @mnewnham can spare the time and is able to reproduce (I can't as I don't use MSSQL), maybe we'll be able to get to the bottom of the issue. Thanks for the feedback anyway.
Federico Martinez
@federicoemartinez
Thank you! Would you like me to create an issue in github?
Mark Newnham
@mnewnham
Yes please. Could you include a code sample including things like fetchmode. This odd query behavior feels like something I've seen before, a long time ago.
Federico Martinez
@federicoemartinez
Wellington Pinto
@wellspinto_twitter

Hi everyone.
I use adodb to connect with an access database.
I have a field with the name MÉD.
I have tried several SELECT and nothing.
SELECT MÉD
SELECT MÉD
SELECT [MÉD]

How to proceed?

Damien Regad
@dregad
@wellspinto_twitter I would say that it's always a bad idea to use accented characters for field names to begin with...
Anyway I don't use Access myself so I'm afraid I won't be of much help here, but this could be a limitation of the underlying ODBC driver which ADOdb relies on. Try to execute your query directly using odbc_execute() or odbc_exec() - if that fails too, then it's not an ADOdb issue, and we won't be able to help.
Crystal Shaneyfelt
@crystalshaneyfelt
Hi, my team switched to using dev-master for PHP 7.2 compatibility. It looks like the update is planned to be included in 5.20.15. We'd like to switch back to using a tagged version if possible. Is there a planned release date for 5.20.15?
Thanks
Damien Regad
@dregad
Yes I was planning on releasing before summer but I got sidetracked sorry
hdale
@hdale

Hi! Would need some help with connecting PHP7.2 on Centos 7 with adoDB 5.20.14 to MSSQL server 2012. I have following settings: Into folder /usr/lib64/php/modules I have copied the files php_sqlsrv_72_nts.signature, php_sqlsrv_72_nts.so, php_sqlsrv_72_ts.signature, php_sqlsrv_72_ts.so. In php.ini I have the extension setup: [mssqlnative]
extension=/usr/lib64/php/modules/php_sqlsrv_72_ts.so. In my connection class I've following settings: <?php
require_once('ADOdb-5.20.14/adodb.inc.php');

$_SYS_DB_CONFIG = array(
'host' => ‘xx.xxx.xxx.xxx’,
'database' => 'test',/
'user' => 'dbuser',
'password' => ‘password’,
'type' => 'mssqlnative'
);
function getDBConnection() {
global $_SYS_DB_CONFIG;
$cnn = adoNewConnection($_SYS_DB_CONFIG['type']);

//$cnn->setConnectionParameter('CharacterSet','ISO-8859-15');

$ret = $cnn->Connect(
            $_SYS_DB_CONFIG['host'],
            $_SYS_DB_CONFIG['user'],
            $_SYS_DB_CONFIG['password'],
            $_SYS_DB_CONFIG['database']
) or die("Unable to connect to server");
if (!$ret) {
Sorry, pressed enter. Ok so I continue previous explanation: I get connection OK, but I have problems with character encoding. The collation of the MSSQL server is Finnish_Swedish_CA_AS. The pages I serve are in encoding 1251. Now I get scrambled all the scandinavian letters like äöå.
hdale
@hdale
I tried to set $cnn->setConnectionParameter('CharacterSet','ISO-8859-15'); but it won't accept it. It only accepts: cnn->setConnectionParameter('CharacterSet','UTF-8');
How to get the scandinavian characters displayed correctly?
hdale
@hdale
Is it so that adoDB 5.20.14 only supports UTF-8? or why is that I can't get ISO-8859-15 working?
KJones
@KJsRepo

So I'm trying to connect to an MSSQL server, and I'm getting a very ADODB error. Connecting with:

$msdb = NewADOConnection("pdo_sqlsrv");

I get:

PHP Fatal error: Uncaught Error: Class 'ADODB_pdo' not found in /srv/npsm/httpd/www/htdocs/ADOdb-5.20.14/drivers/adodb-pdo_sqlsrv.inc.php:6

So I looked for "ADODB_pdo" and found it in (surprise!) adodb-pdo.inc.php, so I manually included it in the test file, and I'm getting:
include("ADOdb-5.20.14/drivers/adodb-pdo.inc.php");

Oops :

PHP Fatal error: Uncaught Error: Call to a member function prepare() on bool in /srv/npsm/httpd/www/htdocs/ADOdb-5.20.14/drivers/adodb-pdo.inc.php:479

KJones
@KJsRepo
Well, that second bit is embarrassing, I just wasn't connecting properly. But I do still have to include the pdo driver file manually.
Damien Regad
@dregad
KJones
@KJsRepo
I see now... I am not a smart man. Thanks for everything!
Damien Regad
@dregad
No worries 😃
KJones
@KJsRepo
I don't think this is an ADOdb problem, but just in case you happen to have any insight on this.... Hitting a MSSQL server: On my Windows / ODBC connection, this query takes 0.01 seconds. On Linux / PDO, it takes 0.12 seconds, so 10x longer.
I'm using PConnect to make the connection, so it should be using pooling...
Damien Regad
@dregad
I don't use mssql sorry can't help
KJones
@KJsRepo
Thanks anyway!
Damien Regad
@dregad

ADOdb Version 5.20.15 released

see changelog https://github.com/ADOdb/ADOdb/blob/v5.20.15/docs/changelog.md