Call to undefined function odbc_connect() php 7

Question

I'm testing out php 7 and have come across this error:

Fatal error: Uncaught Error: Call to undefined function odbc_connect()

From the doc page: http://php.net/manual/en/function.odbc-connect.php php 7 is not listed as supported.

Does anyone have a way around this or know when it will be supported?

Thanks@

what do you have against PDO? http://php.net/manual/en/class.pdo.php — I wrestled a bear once., Dec 16 '15 at 20:28
well php7 doesn't support your driver, so anything you do wil require code changes. — I wrestled a bear once., Dec 16 '15 at 20:39
I'm voting to close this question as off-topic because OP is looking for nonexistent magical solution. — I wrestled a bear once., Dec 16 '15 at 20:39
Wow it's out for 2 weeks and it's a non existent magical solution? Do you have information where they plan on not supporting it? I can wait a little while. — bones, Dec 16 '15 at 20:44
I have the same problem in Windows environment. odbc_connect() function doesn't need any dll or extension. I should never report "undefined function". — Hink, Mar 03 '16 at 13:34
Good question! Look out for the second answer - it worked for me. — Guenther, May 29 '16 at 13:50

score 21 · Answer 1 · answered Mar 03 '16 at 13:44

There is written in doc: ODBC support doesn't need any extension dll. It is true in PHP 5.x, I had to remove "extension=php_odbc.dll" from ini file.
But in PHP 7 I had to put it back.

I found the file "ext/php_odbc.dll" in the new PHP 7 directory again. It works for me :).

score 9 · Accepted Answer · answered Jul 19 '16 at 16:00

9

The DOC page does list PHP 7, so just install php-odbc and you should be good to go. Currently using it myself on RedHat EL7 with Remi php7.

answered Jul 19 '16 at 16:00

Naidim

6,918
2
23
20

score 7 · Answer 3 · answered Oct 27 '16 at 14:53

7

I ran into the same problem. However according to the link you provided PHP7 is in fact supported. So I'm not sure why you have so many comments telling you to go re-write your code.

This is what ultimately fixed the issue for me:

sudo apt-get install php-odbc

Followed by restarting Apache.

answered Oct 27 '16 at 14:53

irwinr

93
1
5

5

I had to do sudo apt install php7.0-odbc for it to work (Ubuntu 16.04) – WoodyDRN Nov 08 '16 at 08:27

score 5 · Answer 4 · answered Jun 24 '18 at 16:30

5

PHP 7.2.7, add extension=php_odbc.dll in php.ini file while either using database as MS Access or Sql Server C:\xxxxxx\php\php.ini

*no semicolon before to extension=php_odbc.dll

answered Jun 24 '18 at 16:30

Kanna Reddy

309
4
5

1

That was already given multiple times. Is there anything new you'd like to add? – Nico Haase Jun 24 '18 at 16:47

score 2 · Answer 5 · answered May 31 '17 at 23:01

Just enble "php_odbc.dll" extension by removing the semicolon and restart Apache.

If there is no such line in php.ini, simply create it on yourself (you will find many similar lines in php.ini) by adding: extension=php_odbc.dll and then restart Apache.

If Apache does not start or cannot load php_odbc.dll, look into to the ext-Folder of PHP, if there is such a DLL called php_odbc.dll. If there is no such DLL, Xampp/PHP7 does not support ODBC natively. In that case you should install an older Xampp Version with PHP 5.x

user2928048 · Answer 6 · 2018-08-31T09:46:30.813

From php.ini file:

> ; Notes for Windows environments :
> ;
> ; - ODBC support is built in, so no dll is needed for it.
> ; - Many DLL files are located in the extensions/ (PHP 4) or ext/ (PHP 5+)

But, in PHP 7, ODBC is not by default. Explicit

extension=odbc

worked for me (new syntax recommended)

Edit: If your architecture is x64 you must use C:\Windows\SysWOW64\odbcad32.exe instead of C:\Windows\system32\odbcad32.exe

score 0 · Answer 7 · answered Sep 25 '20 at 00:36

Here is the error message:

Redhat PHP Fatal error: Uncaught Error: Call to undefined function odbc_connect()

On Redhat Linux 7 you run:

yum install php-odbc

You will get these packages marked in red:

Code sample to test your connection via php command line run: php [filename].php

<?php
// filename: test-connection.php by running command -> php test-connection.php
$connect = odbc_connect("Driver=FreeTDS; Server=sbase.company.ca; Port=1433; TDS_Version=8; ClientCharset=UTF-8; Database=mydbase",'company\\user', 'password');
$query = "SELECT * from mytable";
// perform the query
$result = odbc_exec($connect, $query);
// fetch the data from the database
while(odbc_fetch_row($result)){
        $suid = odbc_result($result, 1);
        $uid = odbc_result($result, 2);
        $gid = odbc_result($result, 3);
        $name = odbc_result($result, 4);
        print("$name|$suid|$uid|$gid\n");
}
// close the connection
odbc_close($connect);
?>

Enjoy!

Call to undefined function odbc_connect() php 7

7 Answers7

Linked

Related